Full Text Query's Timing out while Populating

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 2000 Forums

SQL Server Development (2000)

Full Text Query's Timing out while Populating

Author

Topic

redbrad0
Posting Yak Master

176 Posts

Posted - 2005-05-31 : 22:09:55

I have a Windows 2003 Enterprise Edition with Duel 3.6 GHz with hyperthreading and 6GB of ram. This is a dedicated SQL Server with memory set to be Dynamically configured from 0 - 5120 MB. There is a total of 2,214,454 records in the Full Text Catalog and while it is doing the Incremental Population the query's against the Full Text 50% of the time will timeout. I am guessing this could be the cause of SQL using most of its resouces to update the catalog but I am not sure. Does anyone have any ideas how I can fix this problem?

Quality NT Web Hosting & Design

tomy74
Starting Member

32 Posts

Posted - 2005-06-01 : 05:36:09

Hi,

Incremental Population : A population which only adjusts index entries for rows that have been added, deleted, or modified after the last population. To use Incremental Population the indexed table must have a column of the timestamp data type. If the indexed table does not have a timestamp column, only full population can be used.

The population of full-text indexes can be made either through Enterprise Manager or through the sp_fulltext_catalog system stored procedure.

Because full-text index population can take time, these populations should be scheduled during CPU idle time and slow production periods, such as in the evenings or on weekends.

Thanks,

Tarek Ghazali

redbrad0
Posting Yak Master

176 Posts

Posted - 2005-06-01 : 16:06:19

Well I do have a datetime field in the table. Here is the data structure of the table that is being used.


CREATE TABLE [dbo].[RSS_Feeds_Data] (
	[Data_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[Data_FeedID] [int] NULL ,
	[Data_Title] [nvarchar] (400) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[Data_Link] [nvarchar] (400) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[Data_Desc] [varchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[Data_DateCreated] [datetime] NULL ,
	[Data_Desc_Checksum] AS (binary_checksum(substring([Data_Desc],1,8000))) ,
	[Data_Title_Checksum] AS (binary_checksum(substring([Data_Title],1,4000))) 
) ON [PRIMARY]
GO

The only columns I have Full Text Indexing are the Data_Title, Data_Link and Data_Desc. Do I need to have the Data_DateCreated in the full text catalog also? If so do I have to recreate the entire catalog to have it add in the date?

Quality NT Web Hosting & Design

redbrad0
Posting Yak Master

176 Posts

Posted - 2005-06-03 : 20:23:20

Anyone?

Quality NT Web Hosting & Design

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources