How to resolve Azure SQL DB CPU Utilization should be monitored
About
Sprinto Check: Azure SQL database CPU utilization should be monitored
Azure SQL Database is a fully managed relational database service that provides high-performance, secure, and scalable database solutions. Monitoring the CPU utilization of your Azure SQL Database is crucial for optimizing performance, identifying potential bottlenecks, and ensuring efficient resource utilization.
Purpose
The purpose of the Sprinto check for Azure SQL Database CPU utilization is to monitor and alert on the percentage of CPU usage actively. This monitoring helps you:
Optimize Performance: Monitor CPU utilization to ensure your SQL Database operates within acceptable performance levels.
Resource Management: Proactively identify and address issues related to high CPU usage, ensuring efficient resource utilization.
Performance Bottleneck Detection: Receive alerts if the CPU utilization deviates from expected values, allowing you to detect and address potential performance bottlenecks.
How to Resolve
To address this check, follow these steps to create a monitoring alert for Azure SQL Database CPU utilization:
Before you Begin
Ensure you have "Admin" access to the Azure account to create monitoring alerts.
Log in to Sprinto as an administrator.
Creating Monitoring Alert
Log in to the Azure portal using your credentials.
Navigate to the Azure SQL Database resource you want to monitor.
In the left-hand menu, under Monitoring, select Metrics.
In the Metrics blade, choose the appropriate namespace for SQL Databases, typically Microsoft.Sql/servers/databases.
Select the metric name as CPU Percentage.
From the top side, click New Alert Rule.
On the Configuration Signal Logic drawer, select an Aggregation type and set a custom environment-specific threshold value. Note: The Aggregation type can be selected based on your environment. You can choose Average as the Aggregation type if you have no preference.
From the Create Alert Rule window, on the Details tab, set an appropriate alert rule name.
Finally, click Review + Create to create the alert.
Once the alert is created, Sprinto retrieves the change and sets the assigned check status to "Passing."
If you need any assistance with the Sprinto check, please get in touch with Sprinto Support.