Troubleshoot Azure SQL DB memory usage

Vijay Kumar 2,036 Reputation points
2022-03-30T17:24:49.283+00:00

Hi Team,

How to troubleshoot Azure SQL DB memory usage.
Currently some of our PROD DB are showing 80% memory usage (Observed under Metrics)

Azure SQL Database
0 comments No comments
{count} vote

Accepted answer
  1. Alberto Morillo 34,051 Reputation points MVP
    2022-03-30T17:27:24.277+00:00

    That is quite normal on Azure SQL Database. "The database memory is always used completely. Unlike other resources (CPU, workers, storage), reaching the memory limit does not negatively impact query performance, and does not cause errors and failures. As described in detail in Memory Management Architecture Guide, the database engine often uses all available memory, by design. Memory is used primarily for caching data, to avoid slower storage access. Thus, higher memory utilization usually improves query performance due to faster reads from memory, rather than slower reads from storage" Please read more here.

    However, if you start to see error messages related to the database engine failing to assign memory to queries, in that case please read this documentation to troubleshoot the issue.


0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.