CODEWITHSUNDEEP
sqlsql-serverazureazure-sql-database
Sumit Gupta
Sumit Gupta

Reputation: 2192

SQL Azure: Frequent error

We are having trouble with Sql Azure. We deploy a ancient .Net 4.0/C# based website on Azure. It is all good, except that every here and there we start getting Timeout or anything related to database start giving error. Couple of time it stop insert, DataSet.Fill function fails with Timeout or "Column not found".

As I understand it happens when SQL Azure is probably is busy to respond to our request and break connection in between, probably restarting or switching the node. However it looks bad on end client, when such error appears. Our Database is less than 1 GB in size and we got 10-15 at a time. So I don't think we have heavy load [as Azure is ready for 150 GB Database ours is less than 1% of it].

Anyone suggest what we should do to avoid such error, can we detect such upcoming error?

Upvotes: 0

Views: 151

Answers (1)

pateketu
pateketu

Reputation: 451

You will need to use Transient Fauly handling, The Transient Fault Handling Application Block is good place to start. When refactoring with legacy code for Sql Azure, I found it easier to use the SqlConnection and SqlCommand Extension methods:

Example of SqlConnection extions: 

var retryPolicy = RetryPolicyFactory.GetDefaultSqlConnectionRetryPolicy()
using(var connection = new SqlConnection(connectingString))
{
        connection.OpenWithRetry(retryPolicy);
        ///Do usual stuff with connection
}

Upvotes: 1

Related Questions