Blog Post

Azure SQL Database Alerting

,

It’s good to be proactive and one way is to setup alerts and it is no different when using Azure SQL Database. I like creating alerts for my Azure SQL Databases and I encourage you to do the same.

I keep things simple and like to look at certain performance based metrics but before talking about what metrics are available let’s step through an example.

For this post I want to setup an alert for CPU percentage utilised that when it is greater than 50% over the last 5 minutes I would like to know about it. First step is to navigate to your Azure SQL Database.

SheepDb

Click on your database and under the monitoring node you should find Alert Rules where you should then click Add alert.

AddAlerts

This is what the main screen will look like.

mainscreen

The different metrics available to you are:

metrics

As mentioned before I want to be alerted on CPU so I apply the following.

CPUOPTION

I then cause CPU spikes over a 5-minute window. This is easy for me to do because I am bad at T-SQL.

cpuishigh

I get a pleasant email from Microsoft – simple yet effective.

email

 

Filed under: Azure, Azure SQL DB Tagged: Admin, Alerts, Azure, Azure SQL DB, CPU, portal

Rate

You rated this post out of 5. Change rating

Share

Share

Rate

You rated this post out of 5. Change rating