The Azure SQL Database Managed Instance integration collects platform metrics and diagnostic logs from your SQL Managed Instance resources. Once enabled, the SigNoz agent discovers SQL Managed Instance resources in your monitored resource groups and configures telemetry collection.
This integration collects platform metrics for the Microsoft.Sql/managedInstances resource type. For the Azure SQL Database PaaS offering (single database), use the separate Azure SQL Database 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 Managed Instance 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 Managed Instance Overview dashboard to confirm metrics are appearing.
What's collected
Logs
| Name | Path | Type |
|---|---|---|
| Resource ID | resources.azure.resource.id | string |
Metrics
Each metric is collected with average, maximum, and minimum aggregations.
| Metric name | Unit | Type |
|---|---|---|
azure_avg_cpu_percent_average | Percent | Gauge |
azure_io_bytes_read_average | Bytes | Gauge |
azure_io_bytes_written_average | Bytes | Gauge |
azure_io_requests_average | Count | Gauge |
azure_reserved_storage_mb_average | Count | Gauge |
azure_storage_space_used_mb_average | Count | Gauge |
azure_virtual_core_count_average | Count | Gauge |
Dashboards
The integration includes a pre-built Azure SQL Database Managed Instance 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:
- Average CPU percentage and virtual core count
- IO bytes read, IO bytes written, and IO requests count
- Storage space reserved and storage space used
Next steps
- Create alerts to get notified on CPU saturation or storage exhaustion
- 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.
