November 4, 2011 at 2:08 am
I am getting this error in my application from past few days quite frequently:
Exception information: Exception type: SqlException
Exception message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
I have checked the query time out parameter and its the default 600 which is good enough for our application. I don't know from where to start the investigation.
November 4, 2011 at 2:23 am
You need to find out which operation is taking more than 600 seconds to complete, and look at improving its performance.
John
November 4, 2011 at 7:28 am
1.First of all plz check your query or you can put it.
2. Are any job is running on the sql server.
3. Is deadlock you have checked.
Use this quey for open connection in SQL Server
=================================
SELECT db_name(dbid) as DatabaseName, count(dbid) as NoOfConnections,
loginame as LoginName
FROM sys.sysprocesses
WHERE dbid > 0
GROUP BY dbid, loginame
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply