Azure SQL Managed Instance Monitoring Integration
Azure SQL Managed Instance is a fully managed, scalable cloud database service that provides 100% compatibility for online migrations.
With Site24x7's integration, you can monitor your SQL Managed Instance database, configure thresholds, and receive alerts about critical issues.
Setup and configuration
You can add Azure SQL Managed Instance while adding a new Azure monitor, or you can add it to an existing Azure monitor by following these steps.
Supported metrics
The following metrics can be monitored with Site24x7:
| Metric name | Description | Statistic | Unit |
|---|---|---|---|
| Average CPU Percentage | The amount of processing power of CPU utilized | Average | Percent |
| IO Bytes Read | The number of bytes read in input/output (IO) operations | Average | Bytes |
| IO Bytes Written | The number of bytes written in input/output (IO) operations | Average | Bytes |
| IO Requests Count | The average count of input/output (IO) requests | Average | Count |
| Storage Space Reserved | The amount of storage space reserved for the managed instance | Average | Bytes |
| Storage Space Used | The amount of storage space used | Average | Bytes |
| Virtual Core Count | The number of virtual cores | Average | Count |
| Storage Space Used Percent | The percentage of storage space used up | Average | Percent |
Threshold configuration
Global configuration
- Log in to your Site24x7 account.
- Click Admin in the left navigation pane.
- Select Configuration Profiles from the left pane and click the Threshold and Availability (+) tab from the drop-down menu.
- Click Add Threshold Profile from the top-right corner of the page.
- Set the monitor type as Azure SQL Managed Instance. You can now set the threshold values for all the metrics mentioned above.
Monitor-level configuration
- Log in to your Site24x7 account.
- Navigate to Cloud > Azure and select Azure SQL Managed Instance from the drop-down menu.
- Hover over the resource for which you would like to set a threshold, then click the hamburger icon
next to it. - Click Edit, which will direct you to the Edit Azure SQL Managed Instance Monitor page.
- You can set the threshold values for the metrics by selecting Threshold and Availability.
Note
Changing the threshold metrics in one profile will change the threshold metrics of all resources associated to that Threshold and Availability profile.
IT Automation
Site24x7 offers a set of exclusive IT Automation tools to auto-resolve performance degradation issues. These tools react to events proactively rather than waiting for manual intervention.
How to configure IT Automation for a monitor
Configuration Rules
With Site24x7's Configuration Rules, you can set parameters like Threshold Profile, Notification Profile, Tags, and Monitor Group for multiple monitors.
How to add a Configuration Rule