Timeout in SQLServer 2008
Posted on 2013-10-29
We didn't know that we have any kind of problem in our system related to the database.
But we have been analysing the timeout errors registered from the .NET aplication, we can see that sometimes the error "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding" happens in query's with an average response time of less than 100 miliseconds.
The timeout of the .NET connection is 60s.
So seems that we have a process that cause to colapse the system.
In order to get the guilty, we want to establish a timeout for the worker processes in SQL Server, in order that anyone that use more than 50 seconds, has to be killed.
Does somebody know how to fix in SQLServer a limit/timeout for querys/processes/jobs?
Thanks in advance,