May 14, 2010 at 3:57 am
I have setup FULLText search catalog on SQL Server 2005. from the properties there is a tab "Population Schedule", My question is when its necessary to schedule it? and at what frequency should I keep population the search catalog? How to weight this when it should be done? Is it necessary? can we do this manually or scheduling is better? any idea
Shamshad Ali.
May 22, 2010 at 6:19 am
There is still no any respone on my question;
From the link : http://www.mssqlcity.com/Tips/tipFTS.htm
it says "Consider using a full population when a large percentage of records were changed or added at once."
My question is how one know the percentage of records were changed? how it can be automated?
From this artichle
it says the following
Now how do I find out when I am populating what is going on and how to figure out its not stuck anywhere.
1) Look at the Status column and these are some expected values:
select * from sys.dm_fts_index_population
Status 5 : Processing normally
Status 8 : Encountered row-level errors that will be retried
Status 7 : Has stopped processing
2) Look at the Status column and below are some expected values. Also the item count will indicate the number of items that are currently stored in the FTCatalog. Generally when a population is in progress this value is expected to increase.
select fulltextcatalogproperty(‘catalog_name’, ‘PopulateStatus’)
select fulltextcatalogproperty(‘catalog_name’, ‘ItemCount’)
Status 1 : Full population in progress
Status 6 : Incremental population in progress
Status 7 : Building index
Status 4 : Recovering
3) Another way is to track the size of the .CI/.PI files in the catalog folder. This is a manual process and makes sense when you are populating a large table with lot of documents. In this case, the longer the population goes on, these files are expected to grow in size & number.
This is not still resolving my question.
Shamshad Ali.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply