Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Other Technologies / Full-Text Search / December 2005

Tip: Looking for answers? Try searching our database.

1.2G Catalog file (and climbing)

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Chris - 14 Dec 2005 02:52 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
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!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.