Error Code: 40613 – Azure SQL Database Unavailable

Summary Table

Background

Error code 40613 indicates that your Azure SQL Database is currently unavailable. This is a transient error that can occur due to service unavailability, ongoing maintenance, or failover processes in Azure. The error prevents you from connecting to the database, and it usually requires you to handle the situation gracefully within your application.

Error Code Explanation

• Error Code: 40613
• Message: “Database ‘<database_name>’ on server ‘<server_name>’ is currently unavailable. Please retry the connection later. If the problem persists, contact customer support, and provide them the session tracing ID of ‘<trace_id>’.”

Why This Issue Occurred

This issue happens when your database becomes temporarily inaccessible due to one of the following reasons:

1. Service Maintenance: Azure performs maintenance operations to ensure high availability, scalability, and security. During these operations, brief unavailability can occur.
2. Database Failover: Azure SQL Database uses a geo-redundant architecture. During a failover (switching from primary to a secondary replica), the database might be briefly inaccessible.
3. High Traffic or Load: A sudden increase in workload or excessive resource usage can cause the database to become temporarily unavailable.
4. Provisioning Issues: Changes such as scaling up/down or applying configuration changes may lead to temporary unavailability.

Root Cause

• Transient Conditions: Short-lived issues in the network or service that typically resolve themselves.
• Scheduled Maintenance: Azure periodically schedules maintenance windows that may cause a brief downtime.
• High Resource Usage: The database might be throttled or temporarily disabled if it exceeds resource limits.

Workarounds and Solutions

Step-by-Step Solution

Step 1: Implement Retry Logic

Since this error is often transient, implementing a retry logic in your application can help manage the issue.

Example using C# with Entity Framework:

using (var context = new YourDbContext())
{
    var retryPolicy = Policy
        .Handle<SqlException>(ex => ex.Number == 40613)
        .WaitAndRetry(3, retryAttempt => TimeSpan.FromSeconds(2), (exception, timeSpan, context) =>
        {
            Console.WriteLine($"Retrying due to error: {exception.Message}");
        });

    retryPolicy.Execute(() =>
    {
        var data = context.YourTable.FirstOrDefault();
        Console.WriteLine(data);
    });
}

In this example, the application tries to execute the query three times, with a 2-second wait between attempts, if error code 40613 is encountered.

Step 2: Check Database Status in Azure Portal

1. Log in to the Azure Portal.
2. Navigate to SQL databases and select your database.
3. Verify the database status under the Overview section. It should be “Online.” If it’s “Unavailable,” this could indicate maintenance or an ongoing issue.

Step 3: Review Maintenance Schedules and Alerts

1. Check the Service Health and Resource Health sections in the Azure portal.
2. Set up alerts to notify you of any planned maintenance or outages:
   • Go to Monitor > Alerts.
   • Create a new alert rule for the database resource, and set conditions like “Resource Health” changes to “Unavailable.”

Step 4: Check Azure SQL Resource Utilization

High resource usage can cause temporary unavailability. Monitor metrics such as DTU (Database Transaction Unit) or vCore utilization.

1. Go to the Azure portal, navigate to your SQL database, and check Monitoring > Metrics.
2. Review CPU, DTU, and storage metrics.
3. If usage is consistently high, consider upgrading the service tier.

Example: Scaling Up the Database Using PowerShell

# Variables
$ResourceGroupName = "YourResourceGroup"
$ServerName = "YourServerName"
$DatabaseName = "YourDatabaseName"
$ServiceObjective = "S3"

# Scale the database
Set-AzSqlDatabase -ResourceGroupName $ResourceGroupName -ServerName $ServerName -DatabaseName $DatabaseName -RequestedServiceObjectiveName $ServiceObjective

Step 5: Verify Network Connectivity

Sometimes, connectivity issues can trigger the error. Ensure that your application can access the database:

• Check if your IP address is added to the database firewall rules in the Azure portal.
• Ensure there are no network issues on your side or with Azure.

Step 6: Contact Azure Support

If the issue persists beyond a reasonable time, you may need to contact Azure support:

1. Provide the session tracing ID included in the error message for faster troubleshooting.
2. Share detailed information about when and how often the error occurs.

Real-World Example Scenario

Scenario: You have an e-commerce application connected to an Azure SQL Database. During a peak shopping season, customers face issues with intermittent connectivity, resulting in error code 40613.

Step-by-Step Response:

1. Retry Logic: Implement a retry mechanism in your application to handle transient issues.
2. Scale the Database: Upgrade to a higher service tier (e.g., from Standard S2 to Premium P1) to handle increased traffic.
3. Monitor Resource Health: Set up alerts to get notified about any unplanned outages or resource throttling.
4. Check Azure Portal: Validate that the database status shows “Online.” If it’s in maintenance, inform users and retry later.

Additional Tips

• Retry Logic Best Practice: Use exponential backoff (increase the wait time between retries) to avoid overwhelming the service.
• SQL Database Geo-Replication: Enable active geo-replication for high availability to switch to another region during downtime.

Mohammad Gufran Jahangir