snappy...including Search. is real-time indexing back on?
Should continue to get snappier, though in relatively small increments until the new box gets here and is put into production.
Indexing is pretty close to realtime now and, having made it through today without causing problems, will likely stay that way. Of course, with the new box, it'll be very realtime since the new version of SQL handles it so much better.
For the benefit of anyone out there dealing with SQL-Server and full-text indexing, learn from what I learned the hard way.
Unless your server isn't very busy, DO NOT enable "Update Index in Background". But DO leave "Change Tracking" enabled. Change Tracking apparently causes little or no overhead. In any event, the amount is quite acceptable.
But if you enable background updating, the server spends every waking CPU cycle trying (in vain) to keep the catalogs updated.
What I've done, instead, is schedule an event to run every 15 minutes to basically do what the "Update Index" command in enterprise manager does. I can see every time it runs. The histogram spikes briefly then it's done just as quickly as it started.
Oh, and firing off "Incremental Population" is a real losing proposition, too.
Anyway, I've got other routines I really need to dramatically change and in the meantime will try index refreshing every 5 minutes tomorrow to see how it's working, then when I'm done with these other routines, I'll go back through and tidy up things I've broken along the way. Like apparently "Ignore", which I thought I'd already fixed.
