Azure Integration - SQL Database

Mackerel supports obtaining and monitoring SQL Database metrics in Azure Integration. When integrating with Azure Integration, billable targets are determined using the conversion 1 Instance = 1 Micro Host.

Please refer to the following page for Azure Integration configuration methods and a list of supported Azure services.
Azure Integration

Obtaining metrics

The metrics obtainable with Azure Integration’s SQL Database support are as follows. For Metric explanations, refer to the Azure help page.

The maximum number of metrics obtainable is 12.

Graph name Metric Metric name in Mackerel Unit Aggregation Type
CPU cpu_percent azure.sql_database.cpu_percent Percent Average
Data Read physical_data_read_percent azure.sql_database.physical_data_read_percent Percent Average
Log Write log_write_percent azure.sql_database.log_write_percent Percent Average
DTU dtu_used azure.sql_database.dtu.used Count Average
DTU Consumption dtu_consumption_percent azure.sql_database.dtu_consumption_percent Percent Average
In-Memory OLTP storage xtp_storage_percent azure.sql_database.xtp_storage_percent Percent Average
Connections connection_successful
Count Total
Deadlocks deadlock azure.sql_database.deadlock_count Count Total
Workers workers_percent azure.sql_database.workers_percent Percent Average
Sessions sessions_percent azure.sql_database.sessions_percent Percent Average