Microsoft Azure SQL Database
Overview
Microsoft Azure SQL Database is a fully-managed, cloud-based relational database service provided by Microsoft Azure. It is built on the Microsoft SQL Server database engine and offers a scalable and high-performance solution for hosting SQL databases in the Azure cloud environment.
Prerequisites
You can check the list of prerequisites required for Azure SQL DB here. These are the same for any other Azure service that you need to monitor using AIOps. Move to the section Adding Azure resources for Monitoring on the above link to view the prerequisites for Azure resource monitoring.
List of Supported KPIs
| Name | Description | Type |
|---|---|---|
| azure.sql.database.server | Server of the SQL Database | String |
| azure.sql.database.elastic.pool.name | Elastic Pool Name of the SQL Database | String |
| azure.sql.database.creation.time.seconds | Creation Time in seconds for the SQL Database | Count |
| azure.status | Status of the SQL Database | String |
| azure.sql.database.storage.size.bytes | Storage Size in bytes for the SQL Database | Count |
| azure.location | Location of the SQL Database | String |
| status | Status of the SQL Database | String |
| azure.sql.database.failover.group.id | FailOver Group ID of the SQL Database | String |
| azure.sql.database.earliest.restore.date | Earliest Restore Date of the SQL Database | String |
| azure.sql.database.creation.time | Creation Time for the SQL Database | String |
| azure.sql.database.server.fqdn | Server FQDN of the SQL Database | String |
| azure.sql.database.id | ID of the SQL Database | String |
| azure.sql.database.replication.links | Replication Links of the SQL Database | Count |
| azure.sql.database.resource.group | Resource Group of the SQL Database | String |
| azure.sql.database | SQL Database | String |
| azure.sql.database.cpu.percent | Average CPU usage percentage of the SQL Database | Percent |
| azure.sql.database.data.io.percent | Average percentage of physical data read for the SQL Database | Percent |
| azure.sql.database.log.io.percent | Average percentage of log write for the SQL Database | Percent |
| azure.sql.database.successful.connections | Total count of successful connections to the SQL Database | Count |
| azure.sql.database.failed.connections | Total count of failed connections to the SQL Database | Count |
| azure.sql.database.firewall.blocked.connections | Total count of connections blocked by the firewall for the SQL Database | Count |
| azure.sql.database.deadlocks | Total count of deadlocks encountered in the SQL Database | Count |
| azure.sql.database.in.memory.oltp.storage.used.percent | Average percentage of storage used for in-memory OLTP in the SQL Database | Percent |
| azure.sql.database.worker.utilization.percent | Average percentage of worker utilization in the SQL Database | Percent |
| azure.sql.database.session.utilization.percent | Average percentage of session utilization in the SQL Database | Percent |
| event.timestamp | Timestamp of the event | Count |
| azure.sql.database.data.storage.allocated.bytes | Average allocated data storage in bytes for the SQL Database | Bytes |
| azure.sql.database.data.storage.used.bytes | Average used data storage in bytes for the SQL Database | Bytes |
| azure.sql.database.data.storage.used.percent | Average percentage of used data storage for the SQL Database | Percent |
| azure.sql.database.dtu.limit | Average DTU limit for the SQL Database | Count |
| azure.sql.database.dtu.utilization.percent | Average DTU utilization percentage for the SQL Database | Percent |
| azure.sql.database.used.dtu | Average used DTU for the SQL Database | Count |