Unexpected Timeout

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an application that connects to sql server. Two installs of the
application are frequently experiencing the following error:
"System.InvalidOperationException: Timeout expired." We've checked and
confirmed that all connections are closed and disposed. The two sites that
are having problems with it also receive a lower than average amount of
traffic. I've had them check for deadlocked transactions and the maximum
number of concurrent connections. If anyone has any other ideas on what else
to check it would be appreciated. Thanks, Scott
 
If it's not transaction deadlocking, then it would seem that either the
database server is too busy running other queries, etc, or there is a
network issue with the machine connecting to the database server.
 
Both people claim that the server is dedicated to our application. Both
external clients and web sites / services running on the same machine get the
timeouts.
 
It is important to differentiate if this is happening on a connection open,
or on a query. If during execution of a query, then what query, is it always
the same one, or different ones all the time?

There are just so many variables, no one on this board can tell you
definitively why it would happen. And it doesn't look like you have or are
telling us enough information.

Again, this could be a networking problem. Maybe try moving the DB to the
same machine as the application and see if that gets rid of the problem. If
it does, that would point more toward a flaky network.
 
It's always on opening the connection. When the db and app are on the same
machine it still occurs. It's only for these two installs. We have a hosted
version of the application that gets hammered and doesn't experience the
timeouts.
 
hi
it is common when you trying to delete a big amount of rows.
just suggestion
Shrink your database and try once more
What is your database size, transaction log size?

fox
 
Scott

For this is in my opinion task manager the first to look at, what is it
saying on those servers.

Maybe there is not even time to do the operations.

Just my first thought,

Cor
 
Back
Top