Use a monitor to monitor key performance metrics

Select a database on the MySQL Database on Azure management interface and select the Monitor window to monitor key performance metrics for this database in real time.

monitor-ibiza

Click on Add alert to add alert rules as required. The system currently supports the following metrics:

Performance metric Description
Com_delete The number of delete queries
Com_insert The number of insert queries
Com_replace The number of replace queries
Com_select The number of select queries
Com_update The number of update queries
Failed Connection The number of failed connections
CPU Utilization Average CPU usage
Network Out Outgoing data traffic
Network In Incoming data traffic
Queries The number of queries
Replication Lag In Second Replication lag (second)
Replication Queries Replication queries
Replication Transaction Replication items
Slow Queries The number of slow queries
Storage Storage space used
Successful Connections The number of successful connections
Concurrent Connections The number of concurrent connections
Throttled Connections The number of throttled connections

You can select a time range of 5, 10, 15, 30, or 45 minutes, and 1, 2, 3, 4, 5, or 6 hours. If a particular metric complies with the preset conditions and thresholds, MySQL Database on Azure will send an email to the administrator or route the alert to the Webhook that you set up.