Checking the integrity of the FT catalog/index

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tran.hai@gmail.com - 24 Oct 2005 17:08 GMT

What would be an efficient way to check for the integrity of a FT
catalog or index in SQL 2000? Beside monitoring the event logs, I'm
planning to write a script to parse out a string of text from a text
column of a random row from a table has FT indexes, then go back and do
a FT search on that string/words to make sure the catalog is ok.

SQL 2005 has cidump, does SQL 2000 has any equivalent utility?

Thanks,
Hai

Reply to this Message

John Kane - 25 Oct 2005 06:03 GMT

Hai,
The MSSearch service does its own internal integrity checking by design, so
little to no addition checking is normally required. However, I would
recommend that you monitor the free space, memory and cpu usage via the
"Microsoft Search" Performance counters. The following blog entry has links
to the more common SQL FTS issues.

SQL Server 2000 Full-Text Search Resources and Links
http://spaces.msn.com/members/jtkane/Blog/cns!1pWDBCiDX1uvH5ATJmNCVLPQ!305.entry

323739 "INF: SQL Server 2000 Full-Text Search Deployment White Paper" will
have more information about the MSSearch perfmon counters.

Regards,
John

Signature

SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/

> What would be an efficient way to check for the integrity of a FT
> catalog or index in SQL 2000? Beside monitoring the event logs, I'm
[quoted text clipped - 6 lines]
> Thanks,
> Hai

Reply to this Message

tran.hai@gmail.com - 27 Oct 2005 16:22 GMT

Thanks John!

Reply to this Message