Microsoft Azure SQL Database

Crawler

Overview

Azure SQL Database gives you a robust datastore with the flexibility to scale to meet demand.

Get metrics from Azure SQL Database to:

Visualize the performance of your SQL Database.
Correlate the performance of your SQL Database with your applications.

Setup

Installation

If you haven’t already, set up the Microsoft Azure integration first. There are no other installation steps that need to be performed.

Data Collected

Metrics

azure.sql_servers_databases.active_queries (count)	Active queries across all workload groups. Applies only to data warehouses. Shown as query
azure.sql_servers_databases.app_cpu_billed (count)	App CPU billed. Applies to serverless databases.
azure.sql_servers_databases.app_cpu_percentage (gauge)	App CPU percentage. Applies to serverless databases. Shown as percent
azure.sql_servers_databases.app_memory_percentage (gauge)	App memory percentage. Applies to serverless databases. Shown as percent
azure.sql_servers_databases.base_blob_storage_size (gauge)	Base blob storage size. Applies to Hyperscale databases. Shown as byte
azure.sql_servers_databases.blocked_by_firewall (count)	Blocked by Firewall Shown as connection
azure.sql_servers_databases.cache_hit_percentage (gauge)	Cache hit percentage. Applies only to data warehouses. Shown as percent
azure.sql_servers_databases.cache_used_percentage (gauge)	Cache used percentage. Applies only to data warehouses. Shown as percent
azure.sql_servers_databases.connection_failed (count)	Failed Connections Shown as connection
azure.sql_servers_databases.connection_successful (count)	Successful Connections Shown as connection
azure.sql_servers_databases.cpu_limit (count)	CPU limit. Applies to vCore-based databases.
azure.sql_servers_databases.cpu_percent (gauge)	CPU percentage Shown as percent
azure.sql_servers_databases.cpu_used (count)	CPU used. Applies to vCore-based databases.
azure.sql_servers_databases.data_space_allocated (gauge)	Allocated data storage. Not applicable to data warehouses. Shown as byte
azure.sql_servers_databases.data_storage_size (count)	Data Storage Size is comprised of the size of your data and the transaction log. The metric is counted towards the 'Storage' portion of your bill. Applies only to data warehouses.
azure.sql_servers_databases.deadlock (count)	Deadlocks. Not applicable to data warehouses.
azure.sql_servers_databases.differential_backup_storage_size (gauge)	Cumulative differential backup storage size. Applies to vCore-based databases. Not applicable to Hyperscale databases. Shown as byte
azure.sql_servers_databases.disaster_recovery_storage_size (count)	Disaster Recovery Storage Size is reflected as 'Disaster Recovery Storage' in your bill. Applies only to data warehouses.
azure.sql_servers_databases.dtu_consumption_percent (gauge)	DTU Percentage. Applies to DTU-based databases. Shown as percent
azure.sql_servers_databases.dtu_limit (count)	DTU Limit. Applies to DTU-based databases. Shown as unit
azure.sql_servers_databases.dtu_used (count)	DTU used. Applies to DTU-based databases. Shown as unit
azure.sql_servers_databases.dwu_consumption_percent (gauge)	DWU percentage. Applies only to data warehouses. Shown as percent
azure.sql_servers_databases.dwu_limit (count)	DWU limit. Applies only to data warehouses. Shown as unit
azure.sql_servers_databases.dwu_used (count)	DWU used. Applies only to data warehouses. Shown as unit
azure.sql_servers_databases.effective_cap_resource_percent (gauge)	A hard limit on the percentage of resources allowed for the workload group, taking into account Effective Min Resource Percentage allocated for other workload groups. Applies only to data warehouses. Shown as percent
azure.sql_servers_databases.effective_min_resource_percent (gauge)	Minimum percentage of resources reserved and isolated for the workload group, taking into account the service level minimum. Applies only to data warehouses. Shown as percent
azure.sql_servers_databases.full_backup_storage_size (gauge)	Cumulative full backup storage size. Applies to vCore-based databases. Not applicable to Hyperscale databases. Shown as byte
azure.sql_servers_databases.local_tempdb_percentage (gauge)	Local tempdb percentage. Applies only to data warehouses. Shown as percent
azure.sql_servers_databases.log_backup_storage_size (gauge)	Cumulative log backup storage size. Applies to vCore-based and Hyperscale databases. Shown as byte
azure.sql_servers_databases.log_write_percent (gauge)	Log IO percentage. Not applicable to data warehouses. Shown as percent
azure.sql_servers_databases.memory_percentage (gauge)	Memory percentage. Applies only to data warehouses. Shown as percent
azure.sql_servers_databases.physical_data_read_percent (gauge)	Data IO percentage Shown as percent
azure.sql_servers_databases.queued_queries (count)	Queued queries across all workload groups. Applies only to data warehouses. Shown as query
azure.sql_servers_databases.replication_links.count (gauge)	The amount of replication links per database
azure.sql_servers_databases.sessions_percent (gauge)	Sessions percentage. Not applicable to data warehouses. Shown as percent
azure.sql_servers_databases.snapshot_backup_storage_size (gauge)	Cumulative snapshot backup storage size. Applies to Hyperscale databases. Shown as byte
azure.sql_servers_databases.snapshot_storage_size (count)	Snapshot Storage Size is the size of the incremental changes captured by snapshots to create user-defined and automatic restore points. The metric is counted towards the 'Storage' portion of your bill. Applies only to data warehouses.
azure.sql_servers_databases.sql_server_process_core_percent (gauge)	CPU usage percentage for the SQL Server process, as measured by the operating system. Shown as percent
azure.sql_servers_databases.sql_server_process_memory_percent (gauge)	Memory usage percentage for the SQL Server process, as measured by the operating system. Shown as percent
azure.sql_servers_databases.status (gauge)	Status of Azure SQL Database
azure.sql_servers_databases.storage (gauge)	Data space used. Not applicable to data warehouses. Shown as byte
azure.sql_servers_databases.storage_percent (gauge)	Data space used percent. Not applicable to data warehouses or hyperscale databases. Shown as percent
azure.sql_servers_databases.tempdb_data_file_size_kilobytes (count)	Tempdb Data File Size Kilobytes.
azure.sql_servers_databases.tempdb_log_file_size_kilobytes (count)	Tempdb Log File Size Kilobytes.
azure.sql_servers_databases.tempdb_percent_log_used (gauge)	Tempdb Percent Log Used. Shown as percent
azure.sql_servers_databases.workers_percent (gauge)	Workers percentage. Not applicable to data warehouses. Shown as percent
azure.sql_servers_databases.workload_group_active_queries (count)	Queued queries within the workload group. Applies only to data warehouses. Shown as query
azure.sql_servers_databases.workload_group_allocation_by_cap_resource_percent (gauge)	Allocated percentage of resources relative to the specified cap resources per workload group. Applies only to data warehouses. Shown as percent
azure.sql_servers_databases.workload_group_allocation_by_system_percent (gauge)	Allocated percentage of resources relative to the entire system per workload group. Applies only to data warehouses. Shown as percent
azure.sql_servers_databases.workload_group_query_timeouts (count)	Queries that have timed out for the workload group. Applies only to data warehouses. Shown as query
azure.sql_servers_databases.workload_group_queued_queries (count)	Active queries within the workload group. Applies only to data warehouses. Shown as query
azure.sql_servers_databases.xtp_storage_percent (gauge)	In-Memory OLTP storage percent. Not applicable to data warehouses. Shown as percent

Events

The Azure SQL Database integration does not include any events.

Service Checks

The Azure SQL Database integration does not include any service checks.

Troubleshooting

Need help? Contact Datadog support.