I was looking to change the memory that mssearch use's on my sql server but can't seem to figure out where to change it. I looked at http://www.sql-server-performance.com/full_text_search.asp and can't seem to get to a "performance" tab. Any pointers? I also have a very large database and it does take the CPU to 100% at first and then settles out and just spikes to 100% but then goes right back down to go back up to 100%. It appears that it averages out around 65% while it is running.
One thing I did find out while reading is about Full popuplation or Incremental population. The article I read that as most people should be able to tell that Incremental only updates information that has been changed. Full population erases all information and starts from scratch. The advantage of doing a Full population is that search's are faster ran against a full vrs incremental.
Now my guess is that you should normally use Incremental on a regular schedule (every couple hours) and Full population once or twice a week.
You will. The more often the updates, the more up to date your index will be. The best option is to use change tracking with a background update. That will update the index on every insert and keep it updated in real time. It will also spread out your processing time instead of lumping it into a few large updates.
Topic Locked
Posted - 09 February 2005 : 22:54:41
