The length and status of the full text index population

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

discover - 14 Nov 2006 17:56 GMT

Is there any function that we can to check the length of the full text
index population and the status(whether it is finished successfully or
failed)?

Now I have to check it from application event log to determine how long
it takes. We can see SQL job's "Run Duration" from job history. Is
there anything like this for full text index catalog in SQL or even
function in mssearch?

One of my full text catalog takes almost 47 hours to run for
"Incremental population". This catalog only contains one fulltext
index. The table for this FT has 1184808 records. We have SQL 2000.
Does this sound right?

Thank you in advance!

Reply to this Message

Hilary Cotter - 14 Nov 2006 20:21 GMT

Its really hard to do in SQL 2000. Basically you have to peek at the
gatherer, figure out where it is and then resolve this back to the SQL
Server PK.

Here is an article which talks about how to do it and includes some source.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlpro04/html
/sp04f9.asp

Signature

Hilary Cotter

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

> Is there any function that we can to check the length of the full text
> index population and the status(whether it is finished successfully or
[quoted text clipped - 11 lines]
>
> Thank you in advance!

Reply to this Message

discover - 15 Nov 2006 21:07 GMT

H Hilary:

This article of yours is very helpful. But there are still some
questions that I want to confirm with you.

1) If I use change tracking with "Update index" on schedule, I wouldn't
need "Incremental population", right? (if I schedule a update every
night and a full population on weekend, would it be better than do a
"Incremental" everyday?)

2) We can use commands to create catalog, full text index. Is there a
command to schedule the catalog or FT index?

3) I want to try your samples. But I couldn't found all the MS search
related libraries. Do you know where I can down load them?

Thank you!

Reply to this Message

Hilary Cotter - 17 Nov 2006 21:26 GMT

Answers inline.

Signature

Hilary Cotter

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

>H Hilary:
>
[quoted text clipped - 5 lines]
> night and a full population on weekend, would it be better than do a
> "Incremental" everyday?)

Exactly

> 2) We can use commands to create catalog, full text index. Is there a
> command to schedule the catalog or FT index?

sp_fulltext_table 'tablename','start_incremental'

> 3) I want to try your samples. But I couldn't found all the MS search
> related libraries. Do you know where I can down load them?

C:\Program Files\Common Files\System\MSSearch\Bin
the file is srchadm.dll

> Thank you!

Reply to this Message