Platform = Intel 3.0G 4-way duel core (+ hyper-threading makes 16 CPU)
running Win2003 AS - SP1 SQL Server 2000 (can't go to 2005 yet). 135G DB
without catalogs - which are on a Raid 1+0 external drive via fiber (12
spindles).
1) I need to improve performance of full-text catalogs of a large DB
(135G). The largest of the 6 full-text files is about 1.2G – the others are
relatively small. I found this -
http://msdn.microsoft.com/library/en-us/dnsqlpro04/html/sp04f9.asp (thanks
Hilary) - but the EvaluationOrder key is set to 0 and HitInterval is set to
something like 40M+ (by default) - and the article is confusing on which reg
values need to be changed or give some idea of magnitude to try using. Is it
the EvaluationOrder parm to give more CPU to FTC? The catalog is still
populating - CPU ~5-10 % at most. What exactly is recommended to try and
give the FTC more CPU. Disk Queue length is 0 or 1.
2) Is there a graceful way to shutdown SQL Server to eliminate the Recovery
mode of the FTC once SQL comes back up? (This may be caused by being in the
middle of a populate when SQL goes down).
3) I'm open to any suggestions / tips as well.
Thanks in advance!
Chris - 14 Dec 2005 14:59 GMT
> Platform = Intel 3.0G 4-way duel core (+ hyper-threading makes 16 CPU)
> running Win2003 AS - SP1 SQL Server 2000 (can't go to 2005 yet). 135G DB
[quoted text clipped - 19 lines]
>
> Thanks in advance!