Azure SQL Managed Instance monitoring data reference
This article contains all the monitoring reference information for this service.
See Monitor Azure SQL Managed Instance for details on the data you can collect for SQL Managed Instance and how to use it.
Metrics
This section lists all the automatically collected platform metrics for this service.
For information on metric retention, see Azure Monitor Metrics overview.
Supported metrics for Microsoft.Sql/managedInstances
The following table lists the metrics available for the Microsoft.Sql/managedInstances resource type.
- All columns might not be present in every table.
- Some columns might be beyond the viewing area of the page. Select Expand table to view all available columns.
Table headings
- Category - The metrics group or classification.
- Metric - The metric display name as it appears in the Azure portal.
- Name in REST API - The metric name as referred to in the REST API.
- Unit - Unit of measure.
- Aggregation - The default aggregation type. Valid values: Average (Avg), Minimum (Min), Maximum (Max), Total (Sum), Count.
- Dimensions - Dimensions available for the metric.
- Time Grains - Intervals at which the metric is sampled. For example,
PT1M
indicates that the metric is sampled every minute,PT30M
every 30 minutes,PT1H
every hour, and so on. - DS Export- Whether the metric is exportable to Azure Monitor Logs via diagnostic settings. For information on exporting metrics, see Create diagnostic settings in Azure Monitor.
Metric | Name in REST API | Unit | Aggregation | Dimensions | Time Grains | DS Export |
---|---|---|---|---|---|---|
Average CPU percentage Average CPU percentage |
avg_cpu_percent |
Percent | Average, Maximum, Minimum | <none> | PT1M | Yes |
IO bytes read IO bytes read |
io_bytes_read |
Bytes | Average, Maximum, Minimum | <none> | PT1M | Yes |
IO bytes written IO bytes written |
io_bytes_written |
Bytes | Average, Maximum, Minimum | <none> | PT1M | Yes |
IO requests count IO requests count |
io_requests |
Count | Average, Maximum, Minimum | <none> | PT1M | Yes |
Storage space reserved Storage space reserved |
reserved_storage_mb |
Count | Average, Maximum, Minimum | <none> | PT1M | Yes |
Storage space used Storage space used |
storage_space_used_mb |
Count | Average, Maximum, Minimum | <none> | PT1M | Yes |
Virtual core count Virtual core count |
virtual_core_count |
Count | Average, Maximum, Minimum | <none> | PT1M | Yes |
Metric dimensions
For information about what metric dimensions are, see Multi-dimensional metrics.
This service doesn't have any metrics that contain dimensions.
Resource logs
This section lists the types of resource logs you can collect for this service. The section pulls from the list of all resource logs category types supported in Azure Monitor.
Supported resource logs for Microsoft.Sql/managedInstances
Category | Category display name | Log table | Supports basic log plan | Supports ingestion-time transformation | Costs to export |
---|---|---|---|---|---|
DevOpsOperationsAudit |
Devops operations Audit Logs | AzureDiagnostics Logs from multiple Azure resources. |
No | No | No |
ResourceUsageStats |
Resource Usage Statistics | AzureDiagnostics Logs from multiple Azure resources. |
No | No | No |
SQLSecurityAuditEvents |
SQL Security Audit Event | AzureDiagnostics Logs from multiple Azure resources. |
No | No | No |
Supported resource logs for Microsoft.Sql/managedInstances/databases
Category | Category display name | Log table | Supports basic log plan | Supports ingestion-time transformation | Costs to export |
---|---|---|---|---|---|
Errors |
Errors | AzureDiagnostics Logs from multiple Azure resources. |
No | No | No |
QueryStoreRuntimeStatistics |
Query Store Runtime Statistics | AzureDiagnostics Logs from multiple Azure resources. |
No | No | No |
QueryStoreWaitStatistics |
Query Store Wait Statistics | AzureDiagnostics Logs from multiple Azure resources. |
No | No | No |
SQLInsights |
SQL Insights | AzureDiagnostics Logs from multiple Azure resources. |
No | No | No |
Azure Monitor Logs tables
This section refers to all of the Azure Monitor Logs tables relevant to this service, which are available for query by Log Analytics using Kusto queries.
This service uses the following tables to store resource log data.
Table | Notes |
---|---|
AzureActivity | Entries from the Azure Activity log that provides insight into any subscription-level or management group level events that have occurred in Azure. |
AzureDiagnostics | Azure Diagnostics reveals diagnostic data of specific resources and features for numerous Azure products including Azure SQL databases, elastic pools, and managed instances. For more information, see Diagnostics metrics. |
AzureMetrics | Metric data emitted by Azure services that measure their health and performance. Activity from Azure products including Azure SQL databases, elastic pools, and managed instances. |
Activity log
The linked table lists the operations that can be recorded in the activity log for this service. These operations are a subset of all the possible resource provider operations in the activity log.
For more information on the schema of activity log entries, see Activity Log schema.
Related content
- See Monitor SQL Managed Instance for a description of monitoring Azure SQL Managed Instance.
- See Monitor Azure resources with Azure Monitor for details on monitoring Azure resources.