Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
The following table lists the metrics available for the Microsoft.Sql/managedInstances resource type.
Table headings
- Metric - The metric display name as it appears in the Azure portal.
- Name in Rest API - Metric name as referred to in the REST API.
- Advanced platform metrics - A premium, paid tier of platform metrics in Azure Monitor that provide more granular observability for Azure resources.
- Unit - Unit of measure.
- Aggregation - The default aggregation type. Valid values: Average, Minimum, Maximum, Total, Count.
- Dimensions - Dimensions available for the metric.
- Time Grains - Intervals at which the metric is sampled. For example,
PT1Mindicates that the metric is sampled every minute,PT30Mevery 30 minutes,PT1Hevery hour, and so on. - DS Export - Shows whether the metric is exportable to Azure Monitor Logs via Diagnostic Settings.
For information on exporting metrics, see - Create diagnostic settings in Azure Monitor.
For information on metric retention, see Azure Monitor Metrics overview.
For a list of supported logs, see Supported log categories - Microsoft.Sql/managedInstances
| Metric | Name in REST API | Advanced platform metrics | Unit | Aggregation | Dimensions | Time Grains | DS Export |
|---|---|---|---|---|---|---|---|
| Average CPU percentage Average CPU utilization as a percentage of the instance's vCore limit. |
avg_cpu_percent |
No | Percent | Average, Maximum, Minimum | <none> | PT1M | Yes |
| Workers percentage Worker threads in use (%). |
avg_workers_percent |
No | Percent | Average, Maximum, Minimum | <none> | PT1M | Yes |
| IO bytes read Bytes read from storage by the instance. |
io_bytes_read |
No | Bytes | Average, Maximum, Minimum | <none> | PT1M | Yes |
| IO bytes written Bytes written to storage by the instance. |
io_bytes_written |
No | Bytes | Average, Maximum, Minimum | <none> | PT1M | Yes |
| IO requests count Number of I/O requests issued by the instance. |
io_requests |
No | Count | Average, Maximum, Minimum | <none> | PT1M | Yes |
| Log rate limit Maximum allowed transaction log write rate in MB/s. |
log_rate_limit_mbps |
No | Count | Average, Maximum, Minimum | <none> | PT1M | Yes |
| Log rate Current transaction log write rate in MB/s. Reflects write activity intensity across all databases on the instance. |
log_rate_mbps |
No | Count | Average, Maximum, Minimum | <none> | PT1M | Yes |
| Storage space reserved Storage space reserved for the instance, in MB. |
reserved_storage_mb |
No | Count | Average, Maximum, Minimum | <none> | PT1M | Yes |
| Storage space used Storage space used by the instance, in MB. |
storage_space_used_mb |
No | Count | Average, Maximum, Minimum | <none> | PT1M | Yes |
| Virtual core count Number of vCores provisioned for the managed instance. |
virtual_core_count |
No | Count | Average, Maximum, Minimum | <none> | PT1M | Yes |