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


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

Leave a Reply