> For the complete documentation index, see [llms.txt](https://docs.sprinto.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.sprinto.com/monitors/cloud-and-infrastructure-monitoring/azure/how-to-resolve-sprinto-check-for-monitoring-azure-sql-db-memory-utilization.md).
# How to resolve Sprinto check for monitoring Azure SQL DB Memory Utilization
### About
Sprinto Check: Azure SQL database memory utilization monitored
Sprinto raises this check when your **Azure SQL Database** instance does not have an active alert configured to monitor memory utilization.\
Monitoring memory usage ensures database performance, prevents resource exhaustion, and helps identify under- or over-provisioned instances.
This article provides step-by-step instructions to configure a metric-based alert in **Azure Monitor** that tracks SQL Database memory utilization using the correct metric — `SQL instance memory percent`.
***
### Before You Begin
Ensure that you:
* Have **Contributor** or **Owner** access to your Azure subscription.
* Have access to **Azure Monitor** and **Metrics** for the relevant SQL Database.
* Know the **resource group** and **database name** to which the alert applies.
***
### Steps to Resolve
#### Step 1 – Log in to the Azure Portal
1. Go to [portal.azure.com](https://portal.azure.com).
2. Log in with your **Azure credentials**.
***
#### Step 2 – Open the SQL Database Resource
1. Navigate to the **SQL Database** resource you want to monitor.
2. In the left-hand menu, under **Monitoring**, click **Metrics**.
***
#### Step 3 – Select the Correct Metric
1. In the **Metrics** pane, click on the **Metric name** dropdown.
2. From the list, select:\
**Metric Name:** `SQL instance memory percent`
3. This metric measures the percentage of memory used by the SQL instance and accurately represents **memory utilization**.
{% hint style="warning" %}
**Important:**\
Previous documentation referenced **“Data space used percent”**, which measures **storage utilization**, not memory usage. Please ensure you select the **correct metric** to avoid false negatives.
{% endhint %}
***
#### Step 4 – Create a New Alert Rule
1. From the top of the page, click **New alert rule**.
2. On the **Create an alert rule** page:
* Under **Condition**, verify that `SQL instance memory percent` is selected.
* Choose the **Aggregation type** (commonly **Average**).
* Set a **Threshold value** appropriate for your environment (for example, **80%**).
***
#### Step 5 – Define Alert Details
1. Navigate to the **Details** tab.
2. Enter an appropriate **Alert rule name**, for example:\
`Azure SQL DB Memory Utilization`.
3. Add an optional description if desired.
4. Click **Review + Create** → **Create** to finalise the alert.
***
### Evidence Requirements
Provide one or more of the following as compliance evidence:
* Screenshot of the alert rule showing `SQL instance memory percent` as the metric.
* Alert notification screenshot or log event.
* Sprinto monitor screenshot showing *Passing* status.
***
### Evidence Requirements
As part of your compliance workflow, retain one or more of the following:
* Screenshot of the created alert rule (showing metric name and threshold).
* Copy of Azure Monitor notification email or alert log.
* Screenshot of the Sprinto monitor showing the *Passing* status.
{% hint style="info" %}
#### Updated Metric Information
This article previously referenced the metric **“Data space used percent”**, which measures **storage utilization** rather than **memory usage**.
The correct metric for memory utilization is **`SQL instance memory percent`**. Sprinto’s backend logic has been updated to recognise this metric.
If your check does not pass immediately after creating the alert, this is expected. Sprinto’s monitors update after the next **re-evaluation cycle**. You can also manually trigger a **re-eval** from the Sprinto Monitor UI to refresh the status.
For backward compatibility, Sprinto continues to accept the previous metric temporarily, but new configurations should use **`SQL instance memory percent`** exclusively.
{% endhint %}
***
### Need Help?
If you face issues configuring the alert or your check does not pass after setup, contact **Sprinto Support** at .
---
# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.
## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter:
```
GET https://docs.sprinto.com/monitors/cloud-and-infrastructure-monitoring/azure/how-to-resolve-sprinto-check-for-monitoring-azure-sql-db-memory-utilization.md?ask=
```
The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.
Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.