SQL Database metrics
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. Use the Azure Resource Manager to gather metrics for this resource, then ensure your cloud platform is configured in SolarWinds Observability SaaS to collect this resource type's data. See Add an Azure cloud account.
Depending on the subscription pricing tier of your Azure account or its resources, additional metrics may be available for this entity. To collect additional Azure metrics, select the premium pricing tier when configuring your Azure namespaces.
Many of the collected metrics from Azure SQL Database entities are displayed as widgets in SolarWinds Observability explorers; additional metrics may be collected and available in the Metrics Explorer. You can also create an alert for when an entity's metric value moves out of a specific range. See Entities in SolarWinds Observability SaaS for information about entity types in SolarWinds Observability SaaS.
The following table lists azure.sql.servers.databases
in the search box.
Metric | Units | Description |
---|---|---|
sw.metrics.healthscore | Percent (%) | Health score. A health score provides real-time insight into the overall health and performance of your monitored entities. The health score is calculated based on anomalies detected for the entity, alerts triggered for the entity's metrics, and the status of the entity. The health score is displayed as a single numerical value that ranges from a Good (70-100) to Moderate (40-69) to Bad (0-39) distinction. To view the health score for Azure SQL Database entities in the Metrics Explorer, filter the |
azure.sql.servers.databases.allocated_data_storage | bytes | The amount of formatted file space allocated for storing database data. This space grows automatically but does not decrease after data deletions, ensuring faster future inserts. |
azure.sql.servers.databases.blocked_by_firewall | Count | The number of connection attempts that were blocked due to firewall rules in Azure SQL Database. This helps monitor access control and security settings. |
azure.sql.servers.databases.connection_failed | Count | Failed Connections. The total number of connections that failed. |
azure.sql.servers.databases.connection_successful | Count | Successful Connections. The total number of successful connections. |
azure.sql.servers.databases.cpu_percent | Percent (%) | CPU Utilization. The average percentage of CPU used. |
azure.sql.servers.databases.deadlock | Count | Deadlocks. The total number of deadlocks. |
azure.sql.servers.databases.dtu_consumption_percent | Percent (%) | The percentage of Database Transaction Units (DTUs) consumed relative to the allocated DTU limit. DTUs represent a blend of CPU, memory, reads, and writes, helping gauge database performance. |
azure.sql.servers.databases.dtu_limit | Count | The maximum number of DTUs allocated to a database. This limit determines the available compute, storage, and I/O resources for the database. |
azure.sql.servers.databases.dtu_used | Count | The actual number of DTUs consumed by the database workload. This metric helps assess resource utilization and performance. |
azure.sql.servers.databases.log_write_percent | Percent (%) | Log Write Percentage. The average log I/O percentage based on the limit of the service tier. |
azure.sql.servers.databases.physical_data_read_percent | Percent (%) | Data IO Percentage. The average data I/O percentage based on the limit of the service tier. |
azure.sql.servers.databases.rateOfConnectionFailure | Percent (%) | The rate of failed connection attempts to an Azure SQL Database. Connection failures can occur due to firewall rules, authentication issues, or transient network errors. |
azure.sql.servers.databases.sessions_percent | Percent (%) | Sessions Percentage. The average percentage of concurrent sessions based on the limit of the service tier. |
azure.sql.servers.databases.storage | bytes | Data Space Used. The total amount of space used to store data. |
azure.sql.servers.databases.storage_percent | Percent (%) | Storage Utilization. The average percentage of spaced used to store data based on the limit of the service tier. |
azure.sql.servers.databases.workers_percent | Percent (%) | The percentage of available worker threads being utilized in an Azure SQL Database. High worker utilization can indicate performance bottlenecks, excessive concurrent queries, or inefficient query execution. |
azure.sql.servers.databases.xtp_storage_percent | Percent (%) | The percentage of In-Memory OLTP storage used in an Azure SQL Database. This metric is relevant for databases using memory-optimized tables and helps monitor available memory for in-memory processing. |