Sanjay D

Sanjay D

  • NA
  • 16
  • 13.9k

SQL Exception

May 3 2013 11:14 AM

I am not sure if I selected right category here. Any ways here is my issue.

 

I start getting below error(s) sporadic in nature
---------------------------------------------

SQL Exception :

Type: System.Data.SqlClient.SqlException
Message: A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)
Source: .Net SqlClient Data Provider

Type: System.Data.SqlClient.SqlException
Message: Transaction (Process ID 254) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Source: .Net SqlClient Data Provider

Type: System.Data.SqlClient.SqlException
Message: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
Source: .Net SqlClient Data Provider


----------------------------------------
I have hosted SQL server on Azure; So far what we tried.
1. Adding CommandTimout= 0 to SQL calls
2. Increase physical memory for SQL Server.
3. Even restatred the SQL service.

Still no joys.. Any one can suggest What further we can do? 

 


Answers (2)