--- 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 --- # Azure SQL Database ## 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/).