SQL Exception

Sanjay D

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?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Madan Shekar8y ago
Hey
when you created database instace in azure , you have to chnage the firewall settings

by deafult ip is set to 255.255.255.255
please chnage to 0.0.0.0

now use proper credentials it will work
Jignesh Trivedi13y ago
hi Sanjay,
First Exception is clearly show there is network issue between your application server and database server.
second and third problem due to your query please try to find out in which situation dead lock is occurred? also follow the best practice of SQL like use minimum transaction time etc....
and also see the execution query plan and create new index to resolved time out problem.
hope this will help you.