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 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 for information about entity types in SolarWinds Observability.
The following table lists azure.sql.servers.databases in the search box.
| Metric | Description |
|---|---|
azure.sql.servers.databases.connection_failed | Failed Connections. The total number of connections that failed. |
azure.sql.servers.databases.connection_successful | Successful Connections. The total number of successful connections. |
azure.sql.servers.databases.cpu_percent | CPU Utilization. The average percentage of CPU used. |
azure.sql.servers.databases.deadlock | Deadlocks. The total number of deadlocks. |
azure.sql.servers.databases.log_write_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 | Data IO Percentage. The average data I/O percentage based on the limit of the service tier. |
azure.sql.servers.databases.sessions_percent | Sessions Percentage. The average percentage of concurrent sessions based on the limit of the service tier. |
azure.sql.servers.databases.storage | Data Space Used. The total amount of space used to store data. |
azure.sql.servers.databases.storage_percent | Storage Utilization. The average percentage of spaced used to store data based on the limit of the service tier. |