Create an alert on a metric for Azure SQL Database
b) Select the Azure SQL Database and click on "Alerts" under "Monitoring".
c) Click on "New Alert Rule"
d) Select the Resource (in this scenario it's Azure SQL Database) and Resource Group.
e) Add the condition you would like to monitor and trigger an alert on.
f) Select the condition to trigger alert where the average CPU time is greater than 85% with the data aggregated on a 5 minutes basis.
g) Create a new action group with the action type "Email/SMS/Push/Voice".
h) Provide the email address where the alerts needs to be sent and any other options also you would like to include along with enabling the common alert schema. (https://docs.microsoft.com/en-us/azure/azure-monitor/platform/alerts-common-schema)
i) Once created, the action group click ok. You can also create more than one action group and send alerts to the appropriate alert groups.
j) Finally provide the alert name and description and also enable the Alert rule as soon as it is created.
k) Finally you can see your alert rule created as well as enabled.