Determine Correct metrics for Alerts when Azure SQL is down

Question

Hi Team,

I wanted to setup an alert , when Azure SQL is down. Which metrics is the correct one to be used to alert when Azure SQL is down. Moreover how much is the cost implications for setting up an alert in Azure Monitor.

Thanks!

Answer 1

Hi @Shweta Chavan ,

To elaborate further upon Rahul's response, as explained here you could leverage 'Resource Health' signal when you setup an alert. For illustration, please check below screenshots which shows you the alert configuration from Azure Monitor. Regarding the cost, as explained here, Azure Monitor activity alerts, service health alerts and resource health alerts are free of charge.

Illustration: From Azure Monitor, configure alert as shown below and then select action group as required, provide alert name, tags, and review and create it.

Answer 2

Hi Shweta Chavan

I believe you can set up an alert on the resource health of server.  

Resource health determines the health of your SQL database by examining the success and failure of logins to the resource. Currently, Resource health for your SQL Database resource only examines login failures due to system error and not user error. The health status is updated every 1 to 2 minutes.

Here is a reference document on how to set up an alert on those line https://azure.microsoft.com/en-us/blog/three-ways-to-get-notified-about-azure-service-issues/

Thank you!