Documentation forSolarWinds Observability SaaS

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 some of the metrics collected for these entities. To see the Azure SQL Database metrics in the Metrics Explorer, type azure.sql.servers.databases in the search box.

MetricDescription
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.