Sunday, February 26, 2012

Fulltext search won't repopulate when running on batteries

Here's one that had me stumped for a good couple of hours.
While working on my laptop, I was trying to rebuild a fulltext search
catalog. I tried numerous times repopulating, deleting and rebuilding.
whenever I tried to start it populating, I got messages in the event
log saying the crawl had started, but no sign of any disk or CPU
activity.
Eventually, I just had a hunch to try and plug it into the mains power
and all of a sudden the indexing sprung into life. Seens it won't
start the indexing process when running on batteries!!
I've searched all over the documentation and the web but I can't find
any other references to this feature.
Andy
Your observation is correct. The indexing process does pause when your
computer is on batteries.
Have a look at
www.microsoft.com/exchange/ techinfo/deployment/2000/bestindexing.doc
Which is for exchange which uses the same indexing and querying engine that
SQL FTS uses. It has this reference.
Microsoft Gatherer: Reason to back off This counter shows the code
describing why the gathering service halted the population.
0 - Up and running
1 - High IO rate
4 - Back off on user activity (by default this is disabled in server
install)
5 - Battery low (currently, if running on battery, not on AC power)
"Andy Fish" <ajfish@.blueyonder.co.uk> wrote in message
news:c925c3dc.0501090219.7dda3d6a@.posting.google.c om...
> Here's one that had me stumped for a good couple of hours.
> While working on my laptop, I was trying to rebuild a fulltext search
> catalog. I tried numerous times repopulating, deleting and rebuilding.
> whenever I tried to start it populating, I got messages in the event
> log saying the crawl had started, but no sign of any disk or CPU
> activity.
> Eventually, I just had a hunch to try and plug it into the mains power
> and all of a sudden the indexing sprung into life. Seens it won't
> start the indexing process when running on batteries!!
> I've searched all over the documentation and the web but I can't find
> any other references to this feature.
> Andy
|||Andy,
You might want to checkout the links under "SQL Server 2000 Full-Text Search
Resources and Links" at:
http://spaces.msn.com/members/jtkane/Blog/cns!1pWDBCiDX1uvH5ATJmNCVLPQ!305.entry
Specifically, 323739 "INF: SQL Server 2000 Full-Text Search Deployment White
Paper"
Regards,
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"Andy Fish" <ajfish@.blueyonder.co.uk> wrote in message
news:c925c3dc.0501090219.7dda3d6a@.posting.google.c om...
> Here's one that had me stumped for a good couple of hours.
> While working on my laptop, I was trying to rebuild a fulltext search
> catalog. I tried numerous times repopulating, deleting and rebuilding.
> whenever I tried to start it populating, I got messages in the event
> log saying the crawl had started, but no sign of any disk or CPU
> activity.
> Eventually, I just had a hunch to try and plug it into the mains power
> and all of a sudden the indexing sprung into life. Seens it won't
> start the indexing process when running on batteries!!
> I've searched all over the documentation and the web but I can't find
> any other references to this feature.
> Andy
|||Hmm, so to find out why it's stopped gathering, I'm expected to look in
performance monitor - now that is a bit obscure :-)
"John Kane" <jt-kane@.comcast.net> wrote in message
news:ueyAY5o9EHA.1264@.TK2MSFTNGP12.phx.gbl...
> Andy,
> You might want to checkout the links under "SQL Server 2000 Full-Text
> Search
> Resources and Links" at:
> http://spaces.msn.com/members/jtkane/Blog/cns!1pWDBCiDX1uvH5ATJmNCVLPQ!305.entry
> Specifically, 323739 "INF: SQL Server 2000 Full-Text Search Deployment
> White
> Paper"
> Regards,
> John
> --
> SQL Full Text Search Blog
> http://spaces.msn.com/members/jtkane/
>
> "Andy Fish" <ajfish@.blueyonder.co.uk> wrote in message
> news:c925c3dc.0501090219.7dda3d6a@.posting.google.c om...
>
|||Andy,
Yep, as before this paper was published (I was a *contributor*), there was
no other documentation on monitoring the MSSearch gathering process, so
obscure or not, it is at least public now! Look for more blog entries on
this topic at my blog!
Regards,
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"Andy Fish" <ajfish@.blueyonder.co.uk> wrote in message
news:O9bO1TJ#EHA.2568@.TK2MSFTNGP10.phx.gbl...[vbcol=seagreen]
> Hmm, so to find out why it's stopped gathering, I'm expected to look in
> performance monitor - now that is a bit obscure :-)
> "John Kane" <jt-kane@.comcast.net> wrote in message
> news:ueyAY5o9EHA.1264@.TK2MSFTNGP12.phx.gbl...
http://spaces.msn.com/members/jtkane/Blog/cns!1pWDBCiDX1uvH5ATJmNCVLPQ!305.entry
>

No comments:

Post a Comment