Top Support Solutions for Azure SQL Database

[Server Man]

These are the top Microsoft Support solutions for the most common issues experienced when using Azure SQL Database (updated quarterly).

1. Solutions related to performance and time-outs:

• Troubleshoot and Optimize Queries with Azure SQL Database
• Azure SQL Database Performance and Elasticity Guide

2. Solutions related to managing databases:

• Copying Databases in Azure SQL Database
• Migrating Databases to Azure SQL Database (formerly SQL Azure)
• Azure SQL Database Backup and Restore

3. Solutions related to dropped or terminated connections:

• sys.database_connection_stats
• Azure SQL Database Resource Management
• Troubleshoot connection problems to Azure SQL Database

4. Solutions related to connection time-outs:

• Troubleshoot connection problems to Azure SQL Database
• Windows Azure SQL Database Connectivity Troubleshooting Guide
• Windows Azure SQL Database Connection Management

5. Solutions related to Connectivity - Server is unavailable error:

• Check your Azure status
• Troubleshoot connection problems to Azure SQL Database

Continue reading...