Help Docs

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

  1. Log in to your Site24x7 account.
  2. Click Admin in the left navigation pane.
  3. Select Configuration Profiles from the left pane and click the Threshold and Availability (+) tab from the drop-down menu.
  4. Click Add Threshold Profile from the top-right corner of the page.
  5. 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

  1. Log in to your Site24x7 account.
  2. Navigate to Cloud > Azure and select Azure SQL Managed Instance from the drop-down menu.
  3. Hover over the resource for which you would like to set a threshold, then click the hamburger icon next to it.
  4. Click Edit, which will direct you to the Edit Azure SQL Managed Instance Monitor page.
  5. You can set the threshold values for the metrics by selecting Threshold and Availability.

    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

Related links:

Was this document helpful?

Would you like to help us improve our documents? Tell us what you think we could do better.

We're sorry to hear that you're not satisfied with the document. We'd love to learn what we could do to improve the experience.

Thanks for taking the time to share your feedback. We'll use your feedback to improve our online help resources.

Shortlink has been copied!