Microsoft Azure SQL Managed Instance Monitoring
Overview
Azure SQL Managed Instance is an intelligent, scalable cloud database service that combines the broadest SQL Server database engine compatibility with all the benefits of a fully managed and evergreen platform as a service. SQL Managed Instance has near 100% compatibility with the latest SQL Server (Enterprise Edition) database engine, providing a native virtual network (VNet) implementation that addresses common security concerns, and a business model favorable for existing SQL Server customers.
Applications Manager's Azure SQL Managed Instance monitoring tool helps you monitor the performance of Azure SQL Managed Instances, ensuring optimal database performance, identifying bottlenecks, and resolving issues promptly.
Creating a new Azure SQL Managed Instance monitor
To learn how to create a new Azure SQL Managed Instances monitor, click here.
Monitored Parameters
Navigate to the Category View by clicking the Monitors tab. Hover over 'Child Monitors' under Microsoft Azure in the Cloud Apps table, and then select the SQL MI monitor from the displayed tooltip. This action will display the bulk configuration view for Azure SQL Managed Instance in three tabs:
- Availability tab gives the availability history for the past 24 hours or 30 days.
- Performance tab gives the health status and events for the past 24 hours or 30 days.
- List view tab enables you to perform bulk admin configurations.
The Microsoft Azure monitor provides a brief detail of the Azure SQL Managed Instance under the given subscription. Following are the list of metrics monitored in Azure SQL Managed Instance Monitoring in their corresponding tabs:
Note: Data shown for all the metrics in Azure SQL Managed Instance monitor is collected via Azure REST APIs (Azure Service APIs and Azure Monitor API)
Overview
| Parameter | Description |
|---|
| INSTANCE INFORMATION |
| Instance State | Current state of the instance. |
| Instance Provisioning State | Current provisioning state of the instance. Possible values:- Accepted
- Cancelled
- Created
- Creating
- Deleted
- Deleting
- Failed
- NotSpecified
- Registering
- Running
- Succeeded
- TimedOut
- Unknown
- Unrecognized
- Updating
|
| CPU USAGE |
| Average CPU | Average amount of CPU used over a specified poll interval (in %). |
| STORAGE |
| Used Storage Space | Amount of storage space used at the time of poll interval (in GB). |
| Free Storage Space | Amount of free storage space available at the time of poll interval (in GB). |
| Total Storage Space | Total amount of storage space allocated for the instance (in GB). |
| Storage Space Utilization | Average storage space utilization at the time of poll interval (in %). |
| I/O REQUESTS |
| IO Requests/min | Number of I/O requests per minute over a specified poll interval. |
| Total IO Requests | Total number of I/O requests over a specified poll interval. |
| AVERAGE I/O STATISTICS |
| Average IO Read | Average amount of I/O read operations performed over a specified poll interval (in KB/min). |
| Average IO Write | Average amount of I/O write operations performed over a specified poll interval (in KB/min). |
| TOTAL I/O STATISTICS |
| Total IO Read | Total amount of I/O read operations performed over a specified poll interval (in MB). |
| Total IO Write | Total amount of I/O write operations performed over a specified poll interval (in MB). |
Databases
| Parameter | Description |
|---|
| Databases |
| Database Name | Name of the SQL Managed Instance database. |
| Database State | Current state of the SQL Managed Instance database. Possible values:- Creating
- Inaccessible
- Offline
- Online
- Restoring
- Shutdown
- Updating
|
| Primary Location | Region where the SQL Managed Instance database resides. |
| Secondary Location | Geo paired region of the SQL Managed Instance database. |
| Database Creation Date | Timestamp at which the SQL Managed Instance database was created. |
| Database Earliest Restore Date | Timestamp at which the SQL Managed Instance database was earlier restored. |
Configuration
| Parameter | Description |
|---|
| CONFIGURATION |
| Name | Name of the SQL Managed Instance. |
| Resource Group Name | Resource group to which the SQL Managed Instance is associated. |
| Instance ID | A unique resource identifier of the SQL Managed Instance. |
| Instance FQDN | The fully qualified domain name of the SQL Managed Instance. |
| Instance Pool ID | The ID of the instance pool this managed server belongs to. |
| Tier | The tier or edition of the particular SKU. Possible values: Basic/Premium. |
| Location | Location on which the SQL Managed Instance resides. |
| Virtual Core Count | The number of vCores. Possible values: 8, 16, 24, 32, 40, 64, 80. |
| TLS Version | Minimal TLS version. Possible values: None, 1.0, 1.1, 1.2 |
