October 30, 2001 at 5:17 am
I'm trying to keep a full text catalog constantly updated using change_tracking, and background_updateindex - however, it seems to run the procssors extremely high. We have 8 processors running, and i wondered if a) this is normal behaviour and b) if its possible (or desirable) to dedicate a couple of the processors just to doing this operation?
October 30, 2001 at 6:03 am
You're going to pay for doing the constant update - I don't have the experience with that to say for sure, but I doubt dedicating processors is a good idea. Anyone else tried this?
Andy
December 3, 2001 at 2:41 am
Hi
Are you sure its doing incremental updates? have you got a timestamp column?
if not then incrementals will not work. On my server the disks get thrashed and CPU's hardly move... even so, watch out for this as a high cpu can also be due to the disks trashing.
cheers
chris
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply