Datadog-Microsoft Azure SQL Database Integration

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.blocked_by_firewall
(count)
Count of connection attempts blocked by the firewall
shown as connection
azure.sql_servers_databases.connection_failed
(count)
Count of failed connections
shown as connection
azure.sql_servers_databases.connection_successful
(count)
Count of successful connections
shown as connection
azure.sql_servers_databases.deadlock
(count)
Count of deadlocks
shown as
azure.sql_servers_databases.dtu_limit
(gauge)
Database throughput units utilization limit
shown as unit
azure.sql_servers_databases.dtu_used
(gauge)
Database throughput units used
shown as unit
azure.sql_servers_databases.sessions_percent
(gauge)

shown as percent
azure.sql_servers_databases.storage_percent
(gauge)
Percent of the maximum size for the database used
shown as percent
azure.sql_servers_databases.storage
(gauge)
Total size of the database
shown as byte
azure.sql_servers_databases.workers_percent
(gauge)

shown as percent
azure.sql_servers_databases.cpu_percent
(gauge)
Average CPU utilization
shown as percent
azure.sql_servers_databases.physical_data_read_percent
(gauge)
Average IO utilization
shown as percent
azure.sql_servers_databases.log_write_percent
(gauge)
Average log utilization
shown as percent
azure.sql_servers_databases.xtp_storage_percent
(gauge)
In-Memory OLTP storage percent
shown as percent
azure.sql_servers_databases.dtu_consumption_percent
(gauge)
Database throughput units utilization
shown as percent
azure.sql_servers_databases.dwu_consumption_percent
(gauge)
Data warehouse units utilization
shown as percent
azure.sql_servers_databases.dwu_limit
(gauge)
Data warehouse units utilization limit
shown as unit
azure.sql_servers_databases.dwu_used
(gauge)
Data warehouse units used
shown as unit