Connection Error


my application getting error below in logs.  but, there no errors in event viewer, etc. on sql server side. 

can tell me of way assist me in diagnosing error?  performance counter related logins can track?  being error message client side, trying figure out way find root cause, , have not been succesful in attempts.


system.data.sqlclient.sqlexception: timeout expired. timeout period elapsed prior completion of operation or server not responding.


peace

the error message saying that 

sqlcommand.commandtimeout property has expired; default value timeout 30 seconds.

see more at:

".net framework class library -> sqlcommand.commandtimeout property"

http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.commandtimeout.aspx


this not sql server issue. client application issue, client app executing query or stored proc timing out (taking more 30 seconds). run sql profiler or server side trace (using application name filter). rpc completed , sql batchcompleted events.

this error message has been explained here

http://blogs.msdn.com/spike/archive/2008/07/31/timeout-expired-the-timeout-period-elapsed-prior-to-completion-of-the-operation-or-the-server-is-not-responding.aspx



SQL Server  >  SQL Server Database Engine



Comments

Popular posts from this blog

Conditional formatting a graph vertical axis in SSRS 2012 charts

Register with Power BI failed

SQL server replication error Cannot find the dbo or user defined function........