Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
coolerbob
Aged Yak Warrior
841 Posts |
 Posted - 2008-04-03 : 04:57:33
|
| I've got a free text index on a table that is taking 15-30 % of processing becuase there is a lot of insert activity on this table at the moment.I know the indexer backs off if the server gets busy - or so the theory goes.Is there a way for me to tell it to take more of a back seat? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-03 : 23:08:51
|
| Did you enable change tracking? Try disable it and set scheduled diff population instead. |
 |
|
|
|
|
|
Free Text Index performance