From time to time i experience timeout errors when connecting to my Azure SQL server / database.
Until now, the problem only lasted a few minutes. Today at the time of writing it has lasted for over an hour.
I have tried SQL Management Studio, local application, Azure web application, but they all time out.
If i access the database in the management portal i get this error: "The server could not retrieve metrics (Internal Server Error)."
When i look at the Azure Status page, every service seems to be running just fine.
How do i diagnose this?
Can my application in any way cause this?
Is this simply because the Azure SQL service is unavailable?
Can i do something to avoid down times this long?
My application is a ASP.NET MVC 5 application using Entity Framework 6 to access the database.
The error i get:
Database 'database name' on server 'server name' is not currently available. Please retry the connection later. If the problem persists, contact customer support, and provide them the session tracing ID of '71FC623D-FBB9-43E2-AF68-ED4DE0CD01CE'.