Azure SQL Database Monitoring
Starter
Professional
Bleemeo collects metrics for Azure SQL Database via Azure Monitor (Microsoft.Sql/servers/databases namespace). Metrics are polled every 1 minute.
Metrics
Section titled “Metrics”| Metric | Description |
|---|---|
sql_cpu_used | Percentage of CPU in use relative to the service tier limit |
sql_io_reads | Percentage of data IO in use relative to the service tier limit |
sql_io_writes | Percentage of log IO in use relative to the service tier limit |
sql_mem_used_perc | Percentage of application memory in use relative to the service tier limit |
sql_disk_used | Data space used in bytes |
sql_disk_used_perc | Percentage of storage space used relative to the service tier limit |
sql_connection | Number of successful connections to the database |
Permissions
Section titled “Permissions”Requires the Monitoring Reader role and the Microsoft.Insights resource provider registered on the subscription — see Permissions Summary.
Estimated Azure Cost
Section titled “Estimated Azure Cost”$0.432/month per batch of up to 50 databases in the same region (1 Azure Monitor API call per minute) — see Estimated Azure Costs.
See Also
Section titled “See Also”- Configuration — set up Azure credentials and permissions