| title | Monitoring data reference for Azure SQL Database |
|---|---|
| description | This article contains important reference material you need when you monitor Azure SQL Database. |
| ms.date | 03/01/2024 |
| ms.custom | horz-monitor |
| ms.topic | reference |
| author | WilliamDAssafMSFT |
| ms.author | wiassaf |
| ms.service | azure-sql-database |
| ms.subservice | monitoring |
| ms.reviewer | mathoma |
[!INCLUDE horz-monitor-ref-intro]
See Monitor Azure SQL Database for details on the data you can collect for SQL Database and how to use it.
[!INCLUDE horz-monitor-ref-metrics-intro]
For a list of commonly used metrics for Azure SQL Database, see Azure SQL Database metrics.
The following table lists the metrics available for the Microsoft.Sql/servers/databases resource type. [!INCLUDE horz-monitor-ref-metrics-tableheader] [!INCLUDE microsoft-sql-servers-databases-metrics-include]
The following table lists the metrics available for the Microsoft.Sql/servers/elasticpools resource type. [!INCLUDE horz-monitor-ref-metrics-tableheader] [!INCLUDE microsoft-sql-servers-elasticpools-metrics-include]
The following table lists the metrics available for the Microsoft.Sql/servers/jobAgents resource type. [!INCLUDE horz-monitor-ref-metrics-tableheader] [!INCLUDE microsoft-sql-servers-jobagents-metrics-include]
[!INCLUDE horz-monitor-ref-metrics-dimensions-intro]
[!INCLUDE horz-monitor-ref-metrics-dimensions]
| Metric | Dimension |
|---|---|
| Failed Connections : System Errors | Error ValidatedDriverNameAndVersion |
| Failed Connections : User Errors | Error ValidatedDriverNameAndVersion |
| Successful Connections | SslProtocol ValidatedDriverNameAndVersion |
| Workload group active queries | WorkloadGroupName IsUserDefined |
| Workload group query timeouts | WorkloadGroupName IsUserDefined |
| Workload group allocation by system percent | WorkloadGroupName IsUserDefined |
| Workload group allocation by cap resource percent | WorkloadGroupName IsUserDefined |
| Effective cap resource percent | WorkloadGroupName IsUserDefined |
| Effective min resource percent | WorkloadGroupName IsUserDefined |
| Workload group queued queries | WorkloadGroupName IsUserDefined |
[!INCLUDE horz-monitor-ref-resource-logs]
[!INCLUDE microsoft-sql-servers-databases-logs-include]
[!INCLUDE horz-monitor-ref-logs-tables]
| Table | Notes |
|---|---|
| AzureActivity | Entries from the Azure Activity log that provides insight into any subscription-level or management group level events that have occurred in Azure. |
| AzureDiagnostics | Azure Diagnostics reveals diagnostic data of specific resources and features for numerous Azure products including SQL databases, SQL elastic pools, and SQL managed instances. For more information, see Diagnostics metrics. |
| AzureMetrics | Metric data emitted by Azure services that measure their health and performance. Activity from Azure products including SQL databases, SQL elastic pools, and SQL managed instances. |
[!INCLUDE horz-monitor-ref-activity-log]
- See Monitor SQL Database for a description of monitoring Azure SQL Database.
- See Monitor Azure resources with Azure Monitor for details on monitoring Azure resources.
- Monitor Azure SQL workloads with database watcher (preview)
- Review the Azure Monitor metrics and alerts including Recommended alert rules.