How long takes to do Resume Full Text Index Popula

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Transact-SQL (2008)

How long takes to do Resume Full Text Index Popula

Author

Topic

krishna.netblogs
Starting Member

7 Posts

Posted - 2012-08-11 : 05:17:06

Hi

I have a table having 220 lakshs of records and one of the coulmn is Full Text enabled.We have used ContainsTable() to search for data, but we are unable to get results as expected. so we done rebuild.During Index Rebuild, population is failed.I have found this error in error log and it is saying to do resume population.So I want to know howlong it takes to complete Resume population process.

Please look at the below more details about FT Index table.

Row count - 22155112

Index space - 1,903.250 MB (1.9 GB)

Data space - 87,552.258 MB (87 GB)

sqlserver2008 R2
and the below query we have used


SELECT Distinct top 50 cal.case_id,cal.cas_details 
From g_case_action_log cal (READUNCOMMITTED)
inner join containstable(es.g_case_action_log, cas_details,
 ' ("235355" OR "<br>235355" OR "235355<br> ") ') as key_tbl on cal.log_id = key_tbl.[key]Where cal.product_id = 38810 ORDER By cal.case_id DESC

this query is not going to search in recent inserted/updated rows. this is the actual issue we are facing.

Can any one suggest me how to fix this error and if population need to be resume, then can you please let me know for how long takes to do resume population.

Regards

krishna

krishna.netblogs
Starting Member

7 Posts

Posted - 2012-09-18 : 08:23:05

Hi
This issue has been resolved by changing one of settings of FullText Catalog i.e. Track Changes.this property has 3 options.
1) Automatic
2) Manual
3) Do not track changes
But the 3rd (Do not track changes) option has selected in our case during FTCatalog installation.that's why we are getting this issue.Now we have selected as Automatic .Now we are getting expected results.

Thanks

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources