Post reply

Full Text query times out on execution

  • October 25, 2006 at 10:10 am

    #117340

    I've been noticing that the first time (after a long period of inactivity) a query is performed on a Full Text catalog, it takes an extremely long time to perform the query, in most cases resulting in a timeout.  The next time I run the query, it takes a millisecond to run.

    I'm assuming SQL Sever buffers up the catalog or may have to rebuild the index.  How can I get around this?

  • October 27, 2006 at 6:36 am

    #668466

    Check BOL for the following keywords "Full-Text Search [SQL Server], performance".  There's a ton of information on the page, so I'm not going to quote it, but I think your problem lies in the description listed in the reference.

    Let me know if that didn't help.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • October 27, 2006 at 6:57 am

    #668478

    I think there is a KB for this problem.

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

    You may experience a 45-second delay when you run a full-text query in an instance of SQL Server 2005 that is running on a server without Internet access

  • October 27, 2006 at 7:57 am

    #668502

    That did it.....thanks! 

  • October 27, 2006 at 10:27 pm

    #668622

    Nice to hear that it helped.

     

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply