Diagnose Azure SQL timeout

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'.

July 13th, 2015 6:02pm

Hi Kasper,

I can help taking a closer look at the availability issues you are experiencing with Azure SQL Database. Please email me the server and database names at mihaelab @ microsoft dot com.

Thanks,

Mihaela

Free Windows Admin Tool Kit Click here and download it now
July 16th, 2015 1:40pm

Hi Kasper,

I can help taking a closer look at the availability issues you are experiencing with Azure SQL Database. Please email me the server and database names at mihaelab @ microsoft dot com.

Thanks,

Mihaela

July 16th, 2015 5:38pm

Hi Kasper,

I can help taking a closer look at the availability issues you are experiencing with Azure SQL Database. Please email me the server and database names at mihaelab @ microsoft dot com.

Thanks,

Mihaela

Free Windows Admin Tool Kit Click here and download it now
July 16th, 2015 5:38pm

Hi Kasper,

I can help taking a closer look at the availability issues you are experiencing with Azure SQL Database. Please email me the server and database names at mihaelab @ microsoft dot com.

Thanks,

Mihaela

  • Marked as answer by KasperTygesen Friday, July 17, 2015 7:56 PM
July 16th, 2015 5:38pm

Hi Kasper,

I can help taking a closer look at the availability issues you are experiencing with Azure SQL Database. Please email me the server and database names at mihaelab @ microsoft dot com.

Thanks,

Mihaela

  • Marked as answer by KasperTygesen Friday, July 17, 2015 7:56 PM
Free Windows Admin Tool Kit Click here and download it now
July 16th, 2015 5:38pm

Hi Kasper,

I can help taking a closer look at the availability issues you are experiencing with Azure SQL Database. Please email me the server and database names at mihaelab @ microsoft dot com.

Thanks,

Mihaela

  • Marked as answer by KasperTygesen Friday, July 17, 2015 7:56 PM
July 16th, 2015 5:38pm

I ended up submitting a support request after 4 hours of downtime.

I was told that the specific server hosting my database wasn't running properly in that time frame.
So it has been resolved now, but thanks :-)

Free Windows Admin Tool Kit Click here and download it now
July 17th, 2015 3:57pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics