We've just upgraded a database to SQL 2005 Standard sp1 on a Windows 2003 sp1 server and we are experiencing a problem with Full Text Search. We recreated a Full Text Catalogue in the new SQL 2005 db and it seemed to populate fine. However, now when we run a query on that FTI for the first time it takes about 30-45 seconds to return a result. After that first query, subsequent queries return the result immediately. Then if there is an approximate 30 minute gap until the next query is run then it goes back to taking 30-45 seconds to return the result. It seems as though the results of the query are cached and remain in the chache as long as queries continue to be submitted at <30 minute intervals. If a query is not submitted in 30 minutes then the cache expires. That is only my theory. Has anyone seen this issue? Any insite you can provide is greatly appreciated. Thanks.Does your system have internet access? On loading the system resources for FTS, it will connect to the internet to validate the signature. The duration is about what you've reported, 45sec. After about 30 minutes of no activity, the resouces will be unloaded to save memory.
So, to keep the resources in memory you could create a job that execute the query every 10minutes.|||
Hi OJ,
The signature of what? Is there any option to disable this validation?
Please advice. Thanks, Radu.
|||It's the signature of the DLLs/binaries used by MsSearch (FTS) service. You can turn off the checking by running
exec sp_fulltext_Service 'verify_signature',0
没有评论:
发表评论