Mike Fal shows how to create Azure SQL Database alerts using Powershell:
So let’s get down to brass tacks and actually create an alert. To do this, we need some info first:
-
The Resource Group we will create the alert in.
-
An Azure location where the alert will live.
-
An Azure SQL Database server and database we are creating the alert for.
-
What metric we will monitor and what is the threshold we will be checking.
-
(optional) An email to send an alert to.
Mike follows this up with code and shows it’s not scary at all to create these alerts from within Powershell.