Help SQL Server

Azure SQL Server Monitoring Integration

Azure SQL Server is a logical container where you can create and manage databases, elastic pools, and dedicated SQL pools.

With Site24x7's integration, you can now monitor your SQL Server database, configure thresholds, and receive alerts about critical issues.

Table of contents

Setup and configuration

You can add Azure SQL Server while adding a new monitor, or you can add it to an existing Azure monitor. Follow these steps to add the service.

Supported metrics

The following metrics are collected:

Metric nameDescriptionStatisticUnit
DTU Percentage The percentage of total database transaction units (DTUs) used Average Percent
DTU Used The number of DTUs used Average Count
Data Space Used The amount of space used to store database data Average Bytes

Threshold configuration

Global configuration

  1. Go to the Admin section in the left navigation pane.
  2. Select Configuration Profiles from the left pane and choose the Threshold and Availability (+) tab from the drop-down menu. Click Add Threshold Profile from the top-right corner.
  3. Set the monitor type as Azure SQL Server. You can now set the threshold values for all the metrics mentioned above.

Monitor-level configuration

  1. Go to Cloud > Azure and select Azure SQL Server from the drop-down menu.
  2. Choose a resource for which you would like to set a threshold, then click the hamburger icon . Select Edit, which will direct you to the Edit Azure SQL Server Monitor page.
  3. You can set the threshold values for the metrics by selecting Threshold and Availability. You can also configure IT Automation at the attribute level.

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 Configuration Rules

Related links:

How to add an Azure monitor.
How to integrate an Azure App Service monitor.
How to integrate Azure Virtual Machine monitor.
How to configure IT Automations for a monitor.
How to add a Configuration Rule.

Was this document helpful?
Thanks for taking the time to share your feedback. We’ll use your feedback to improve our online help resources.

Help SQL Server