--- title: Azure SQL Database description: >- Azure SQL Database is a relational database service based on the Microsoft SQL Server engine breadcrumbs: Docs > Integrations > Azure SQL Database --- > For the complete documentation index, see [llms.txt](https://docs.datadoghq.com/llms.txt). # Azure SQL Database {% callout %} # Important note for users on the following Datadog sites: us2.ddog-gov.com {% alert level="info" %} To find out if this integration is available in your organization, see your [Datadog Integrations](https://app.datadoghq.com/integrations) page or ask your organization administrator. To initiate an exception request to enable this integration for your organization, email [support@ddog-gov.com](mailto:support@ddog-gov.com). {% /alert %} {% /callout %} ## Overview{% #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{% #setup %} ### Installation{% #installation %} If you haven't already, set up the [Microsoft Azure integration first](https://docs.datadoghq.com/integrations/azure.md). There are no other installation steps that need to be performed. ## Data Collected{% #data-collected %} ### Metrics{% #metrics %} | | | | | **azure.sql_servers_databases.active_queries**(count) | Active queries across all workload groups. Applies only to data warehouses. | | **azure.sql_servers_databases.data_space_allocated**(gauge) | Allocated data storage. Not applicable to data warehouses.*Shown as byte* | | **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.data_storage_size**(gauge) | Data storage size. Applies to Hyperscale databases.*Shown as byte* | | **azure.sql_servers_databases.blocked_by_firewall**(count) | Blocked by Firewall. | | **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. | | **azure.sql_servers_databases.connection_successful**(count) | Successful Connections. | | **azure.sql_servers_databases.core_count**(gauge) | Core count. | | **azure.sql_servers_databases.cpu_limit**(gauge) | CPU limit. Applies to vCore-based databases. | | **azure.sql_servers_databases.cpu_percent**(gauge) | CPU percentage.*Shown as percent* | | **azure.sql_servers_databases.cpu_percent.max**(gauge) | Maximum CPU percentage (Max Aggregated)*Shown as percent* | | **azure.sql_servers_databases.cpu_used**(gauge) | CPU used. Applies to vCore-based databases. | | **azure.sql_servers_databases.cpu_used.max**(count) | Maximum CPU used. Applies to vCore-based databases. (Max Aggregated) | | **azure.sql_servers_databases.deadlock**(count) | Deadlocks. Not applicable to data warehouses. | | **azure.sql_servers_databases.remote_data_reads**(count) | Remote data reads in bytes.*Shown as byte* | | **azure.sql_servers_databases.total_remote_bytes_read_and_written**(count) | Total remote bytes read and written by compute.*Shown as byte* | | **azure.sql_servers_databases.remote_log_writes**(count) | Remote log writes in bytes.*Shown as byte* | | **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.dtu_consumption_percent**(gauge) | DTU Percentage. Applies to DTU-based databases.*Shown as percent* | | **azure.sql_servers_databases.dtu_limit**(gauge) | DTU Limit. Applies to DTU-based databases. | | **azure.sql_servers_databases.dtu_used**(gauge) | DTU used. Applies to DTU-based databases. | | **azure.sql_servers_databases.dwu_consumption_percent**(gauge) | DWU percentage. Applies only to data warehouses.*Shown as percent* | | **azure.sql_servers_databases.dwu_limit**(gauge) | DWU limit. Applies only to data warehouses. | | **azure.sql_servers_databases.dwu_used**(gauge) | DWU used. Applies only to data warehouses. | | **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.physical_data_read_percent.max**(gauge) | Maximum Data IO percentage (Max Aggregated)*Shown as percent* | | **azure.sql_servers_databases.queued_queries**(count) | Queued queries across all workload groups. Applies only to data warehouses. | | **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.data_backup_storage_size**(gauge) | Cumulative data backup storage size. Applies to Hyperscale databases.*Shown as byte* | | **azure.sql_servers_databases.sql_server_process_core_percent**(gauge) | CPU usage as a percentage of the SQL DB process. Not applicable to data warehouses.*Shown as percent* | | **azure.sql_servers_databases.sql_server_process_memory_percent**(gauge) | Memory usage as a percentage of the SQL DB process. Not applicable to data warehouses.*Shown as percent* | | **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**(gauge) | Space used in tempdb data files in kilobytes. Not applicable to data warehouses. | | **azure.sql_servers_databases.tempdb_log_file_size_kilobytes**(gauge) | Space used in tempdb transaction log file in kilobytes. Not applicable to data warehouses. | | **azure.sql_servers_databases.tempdb_percent_log_used**(gauge) | Space used percentage in tempdb transaction log file. Not applicable to data warehouses.*Shown as percent* | | **azure.sql_servers_databases.workload_group_active_queries**(count) | Active queries within the workload group. Applies only to data warehouses. | | **azure.sql_servers_databases.workload_group_query_timeouts**(count) | Queries that have timed out for the workload group. Applies only to data warehouses. | | **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_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.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.workload_group_queued_queries**(count) | Queued queries within the workload group. Applies only to data warehouses. | | **azure.sql_servers_databases.workers_percent**(gauge) | Workers percentage. Not applicable to data warehouses.*Shown as percent* | | **azure.sql_servers_databases.xtp_storage_percent**(gauge) | In-Memory OLTP storage percent. Not applicable to data warehouses.*Shown as percent* | | **azure.sql_servers_databases.count**(gauge) | Count of Azure SQL Database resources. | | **azure.sql_servers_databases.app_cpu_billed_ha_replicas**(count) | Sum of app CPU billed across all HA replicas associated with the primary replica or a named replica. | | **azure.sql_servers_databases.availability**(gauge) | Percentage of SLA compliant availability for the database. Availability is calculated based on connections and for each one-minute data point the value will be either 100% if connection(s) succeed or 0% if all connections fail due to system errors. Note:Select 1-minute time granularity to view SLA compliant availability.*Shown as percent* | | **azure.sql_servers_databases.failed_connections_user_errors**(count) | Failed connections : user errors. | | **azure.sql_servers_databases.free_amount_consumed**(gauge) | Free amount of vcore seconds consumed this month. Applies only to free database offer. | | **azure.sql_servers_databases.free_amount_remaining**(gauge) | Free amount of vcore seconds remaining this month. Applies only to free database offer. | | **azure.sql_servers_databases.failed_ledger_digest_uploads**(count) | Ledger digests that failed to be uploaded. | | **azure.sql_servers_databases.successful_ledger_digest_uploads**(count) | Ledger digests that were successfully uploaded. | | **azure.sql_servers_databases.replication_lag_preview**(gauge) | Replication lag or RPO is the number of seconds that the secondary database is behind the primary database. This value is available on the primary database only.*Shown as second* | | **azure.sql_servers_databases.sessions_count**(gauge) | Number of active sessions. Not applicable to synapse DW analytics. | | **azure.sql_servers_databases.sql_instance_cpu_percent**(gauge) | CPU usage by all user and system workloads. Not applicable to data warehouses.*Shown as percent* | | **azure.sql_servers_databases.sql_instance_memory_percent**(gauge) | Memory usage by the database engine instance. Not applicable to data warehouses.*Shown as percent* | ### Events{% #events %} The Azure SQL Database integration does not include any events. ### Service Checks{% #service-checks %} The Azure SQL Database integration does not include any service checks. ## Troubleshooting{% #troubleshooting %} Need help? Contact [Datadog support](https://docs.datadoghq.com/help/).