Troubleshooting Timeout error -2146232060

14 March,2013 by Jack Vamvas

I receive queries about the Timeout error -2146232060  error from developers .  The error message body is similar to below. Quite often , when they restart the server , the problem disappears and then reappears.

System.Data.SqlClient.SqlException occurred
  Message=Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
  Source=.Net SqlClient Data Provider
  ErrorCode=-2146232060
  Class=11
  LineNumber=0
  Number=-2
  Procedure=""
  Server=xxxxxxxxxxxxxxxx
  State=0
  StackTrace: ………………

 

Troubleshooting Tips for Timeout error -2146232060 

 

1)   Do all the target objects exist on the SQL Server instance?

2)    Have you tried to increase the command timeout on the application side? The Command Timeout value is on the command object

3)      Check for blocking on the SQL Server , it could be causing a delay on the process you’re attempting to execute . Read more SQL Server - How to detect and troubleshoot blocking and deadlocks

4)      Check SQL Server Error Logs .

5)    Are you using MS DTC ? Are there orphaned records creating blocking? Click for more information MS DTC and sys.dm_tran_active_transactions

6)   Can you run the code from SSMS ? Does it run without the error?

Read More

Powershell Get-EventLog and Event Log messages - SQL Server DBA

SQL Server - Powershell and SQL Error Logs - SQL Server DBA

 


Author: Jack Vamvas (http://www.sqlserver-dba.com)


Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on Troubleshooting Timeout error -2146232060


sqlserver-dba.com | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer