Documentation forAppOptics

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.