The Azure SQL Database integration collects platform metrics and diagnostic logs from your Azure SQL Database (single database) instances. Once enabled, the SigNoz agent discovers SQL Database resources in your monitored resource groups and configures telemetry collection.
This integration requires SigNoz Azure agent version v0.0.12 or later.
This integration collects platform metrics for the Microsoft.Sql/servers/databases resource type — the Azure SQL Database PaaS offering. Azure SQL Managed Instance and SQL Server on Azure VMs expose a different set of metrics. SQL Managed Instance is covered by the separate Azure SQL Managed Instance integration.
Getting started
Connect your Azure subscription first. See Azure One-Click Integrations for setup instructions.
Once connected:
- In SigNoz, navigate to Integrations > Microsoft Azure.
- Select SQL Database from the left panel.
- Toggle Log Collection and Metric Collection on.
The agent deploys the necessary Event Hubs and diagnostic settings in the background. Data starts flowing within a few minutes. Navigate to Dashboards and open the Azure SQL Database Overview dashboard to confirm metrics are appearing.
What's collected
Logs
| Name | Path | Type |
|---|---|---|
| Resource ID | resources.azure.resource.id | string |
Key metrics
Each metric is collected with average, maximum, and minimum aggregations where applicable. The table below lists representative metrics; see the Data Collected tab in the integration for the complete list.
| Metric name | Unit | Type |
|---|---|---|
azure_cpu_percent_average | Percent | Gauge |
azure_sql_instance_cpu_percent_average | Percent | Gauge |
azure_sql_instance_memory_percent_average | Percent | Gauge |
azure_physical_data_read_percent_average | Percent | Gauge |
azure_log_write_percent_average | Percent | Gauge |
azure_workers_percent_average | Percent | Gauge |
azure_sessions_count_average | Count | Gauge |
azure_sessions_percent_average | Percent | Gauge |
azure_storage_average | Bytes | Gauge |
azure_storage_percent_average | Percent | Gauge |
azure_allocated_data_storage_average | Bytes | Gauge |
azure_connection_successful_average | Count | Gauge |
azure_connection_failed_average | Count | Gauge |
azure_blocked_by_firewall_average | Count | Gauge |
azure_deadlock_average | Count | Gauge |
azure_availability_average | Percent | Gauge |
azure_replication_lag_seconds_average | Seconds | Gauge |
azure_full_backup_size_bytes_average | Bytes | Gauge |
azure_diff_backup_size_bytes_average | Bytes | Gauge |
azure_log_backup_size_bytes_average | Bytes | Gauge |
azure_xtp_storage_percent_average | Percent | Gauge |
Dashboards
The integration includes a pre-built Azure SQL Database dashboard. Pre-built dashboards are locked and cannot be edited. To customize, use Export JSON from the dashboard menu and import it as a new dashboard.
Key panels include:
- CPU percentage, SQL instance CPU and memory percentage, and workers percentage
- Data IO percentage and log IO percentage
- Sessions count and sessions percentage
- Successful and failed connections, blocked-by-firewall, and deadlocks
- Data space used, allocated, and used percentage
- Full, differential, and log backup storage size
- Availability and replication lag
Next steps
- Create alerts to get notified on CPU saturation, failed connections, or availability drops
- Build custom dashboards to correlate database metrics with application performance
Get Help
If you need help with the steps in this topic, please reach out to us on SigNoz Community Slack. If you are a SigNoz Cloud user, please use in product chat support located at the bottom right corner of your SigNoz instance or contact us at cloud-support@signoz.io.
