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.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
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

Events

The Azure SQL Database integration does not include any event at this time.

Service Checks

The Azure SQL Database integration does not include any service check at this time.

Troubleshooting

Need help? Contact Datadog Support.