Connection error in SQL Azure

Some of the major reasons for connection issues in SQL Azure are as follows:

• Lock Consumption
• Log File Size
• Uncommitted Transactions
• Transactions blocking system calls
• TempDB Usage and Size
• Excessive Memory Usage
• Maximum Database Size
• Transaction Termination
• Denial of Service Attacks
• Network Problems
• Failover Problems

Confused / Curious / Impressed with the above points ? Well, I cannot take credit for what I have summarized from a SQL Azure whitepaper. Same can be read from here. If not the entire whitepaper, at least the above list can be quite handy while troubleshooting for the root cause of connection issues with SQL Azure. Also with little modification, this list can be translated into development standards for application interfaces to connect with SQL Azure.