SQL Index defrag and maintenance tasks for Search

Hi all, this topic is an area that has caused me much pain and work.  My goal for this was to follow the recommended SQL guidelines while minimizing the impact that these maintenance jobs have on Crawling and Queries.  We know from the SQL Monitoring an I/O post that Search is extremely I/O intensive .  As it turns out so is all of the regular maintenance that SQL recommends, so finding the right balance between the two is an interesting scheduling task.

Read the complete post : blogs.msdn.com/enterprisesearch

Next PostNewer Post Previous PostOlder Post Home