How to resolve Sprinto check for monitoring Azure SQL DB Memory Utilization
About
Sprinto Check: Azure SQL database memory utilization monitored
Azure SQL Database is a fully managed relational database service providing high-performance, secure, scalable solutions. Monitoring the memory 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 memory utilization is to monitor and alert on the percentage of memory usage actively. This monitoring helps you:
Optimize Performance: Monitor memory utilization to ensure your SQL Database operates within acceptable performance levels.
Resource Management: Proactively identify and address issues related to high memory usage, ensuring efficient resource utilization.
Performance Bottleneck Detection: Receive alerts if the memory 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 memory 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.
Select the metric name as Data space used percent.
From the top side, click New Alert Rule.
On the Create an alert rule page, select an Aggregation type and set a custom environment-specific threshold value. Note: The Aggregation type can be selected based on your environment.
On 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.