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.SqlExceptionMessage: 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.SqlExceptionMessage: 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.SqlExceptionMessage: 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 calls2. Increase physical memory for SQL Server.3. Even restatred the SQL service.
Still no joys.. Any one can suggest What further we can do?