SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Timeout expired problem
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

yterbium
Starting Member

1 Posts

Posted - 10/11/2012 :  05:30:10  Show Profile  Reply with Quote
Hi,

firstly some introduction to our software:
we have website, written in ASP.NET, hosted in ISS on Windows Server 2008 R2, web edition, as our storage we use MS SQL 2008 R2, Web Edition.

Main problem:
we are getting timeout expired exceptions, when executing sp that search on fulltext indexed columns.

Details:
On our sql we have mutlible databases. Each database have spSearch (which is same on each db). This spSearch searches with CONTAINS/CONTAINSTABLE on data, that are full-text indexed. Normaly this spSearch takes about 1-3 seconds executing.

But when we execute this spSearch throught our web site, using ADO.NET
executeStoredProcedure, from beggining everything works great. Results are return normaly, in 1-3 seconds.

But after some random time (or some number of calling spSearch???) from our website, we start to get timeout expired exception. If one user gets this exception, on database, in which this user is, all users gets this error from now on. If we execute this spSearch in management studio on this db, it executes normaly, in 1-3 seconds, without any timeout error. If some user executes this sp on other db, it executes normaly.

What seems to help is to rebuild fulltext catalog on the db, if we do this, all users from our site can now search with spSearch without any problem. But after some time, everything starts again.

Qustions:
The biggeest mystery is, that how it is possible, that from our site we are unable to search, but from management studio it executes right away at the same time?

We are out of solutions, so we appreciate any help.

Thanks and regards







  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000