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

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.

• Microsoft.Sql resource provider operations

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.