Edit

Share via

Azure SQL Managed Instance monitoring data reference

  • Article

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. These metrics are also part of the global list of all platform metrics supported in Azure Monitor.

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

The io_bytes_read, io_bytes_written, and io_requests metrics are averages aggregated over a 15-second interval, and further aggregated using the time granularity interval and aggregation selected in the Azure Monitor metrics explorer.

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 Example queries Costs to export
DevOpsOperationsAudit Devops operations Audit Logs AzureDiagnostics

Logs from multiple Azure resources.

 No No Queries No
ResourceUsageStats Resource Usage Statistics AzureDiagnostics

Logs from multiple Azure resources.

 No No Queries No
SQLSecurityAuditEvents SQL Security Audit Event AzureDiagnostics

Logs from multiple Azure resources.

 No No Queries No

Supported resource logs for Microsoft.Sql/managedInstances/databases

Category Category display name Log table Supports basic log plan Supports ingestion-time transformation Example queries Costs to export
Errors Errors AzureDiagnostics

Logs from multiple Azure resources.

 No No Queries No
QueryStoreRuntimeStatistics Query Store Runtime Statistics AzureDiagnostics

Logs from multiple Azure resources.

 No No Queries No
QueryStoreWaitStatistics Query Store Wait Statistics AzureDiagnostics

Logs from multiple Azure resources.

 No No Queries No
SQLInsights SQL Insights AzureDiagnostics

Logs from multiple Azure resources.

 No No Queries No

Azure Monitor Logs tables

This section lists the Azure Monitor Logs tables relevant to this service, which are available for query by Log Analytics using Kusto queries. The tables contain resource log data and possibly more depending on what is collected and routed to them.

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