Azure SQL Database
Overview
Azure SQL Database is a general-purpose relational database, provided as a managed service. With it, you can create a highly available and high-performance data storage layer for the applications and solutions in Azure.
Configuration
On the Azure integration page, ensure that the Azure SQL Databases service is selected for metric collection.
Metrics
| Name | Description | Tags |
|---|---|---|
| azure.sql.cpu.percent | CPU percentage | Name, Subscription, Region |
| azure.sql.physical_data_read_percent | Data IO percentage | Name, Subscription, Region |
| azure.sql.log_write_percent | Log IO percentage | Name, Subscription, Region |
| azure.sql.dtu_consumption_percent | DTU percentage | Name, Subscription, Region |
| azure.sql.storage | Total database size | Name, Subscription, Region |
| azure.sql.connections.success | Successful Connections | Name, Subscription, Region |
| azure.sql.connections.failure | Failed Connections | Name, Subscription, Region |
| azure.sql.blocked_by_firewall | Blocked by Firewall | Name, Subscription, Region |
| azure.sql.deadlock | Deadlocks | Name, Subscription, Region |
| azure.sql.storage_percent | Database size percentage | Name, Subscription, Region |
| azure.sql.xtp_storage_percent | In-Memory OLTP storage percent | Name, Subscription, Region |
| azure.sql.workers_percent | Workers percentage | Name, Subscription, Region |
| azure.sql.sessions_percent | Sessions percentage | Name, Subscription, Region |
| azure.sql.dtu_limit | DTU Limit | Name, Subscription, Region |
| azure.sql.dtu_used | DTU used | Name, Subscription, Region |
| azure.sql.allocated_data_storage | Data space allocated | Name, Subscription, Region |
Navigation Notice: When the APM Integrated Experience is enabled, AppOptics shares a common navigation and enhanced feature set with other integrated experience products. How you navigate AppOptics and access its features may vary from these instructions.