SQL Search is Slow on the First Search

This is an Old one but some people I find still get stuck scratching their head, including me.

If you are using full Text indexing for your web based searches, you most likely don’t have Internet access on your SQL server, and this is the root cause of the search performing very slowly on the first attempt of the search, as SQL is trying to establish a connection for ‘Signature verification’

You can turn this feature off:

run

sp_fulltext_service ‘verify_signature’, 0;
GO

 

for more info go to

http://support.microsoft.com/kb/915850

This entry was posted on Wednesday, April 30th, 2008 at 6:55 am and is filed under Microsoft, SQL Server, Software, Techie . You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

One Response to “SQL Search is Slow on the First Search”

Leave a Reply