SQL Server 2005 Full Text Search Timeout

Setup ASP.Net 3.5 application with a SQL Server 2005 backend Full Text Search index (to search a document library stored in the database) Web frontend to the document search Search is handled by a stored procedure Symptoms Running a query first thing in the morning results in a SQL timeout Subsequent queries are very fast…

0