Right, is by design that SQL Server holds the allocated memory, you can read about in article Memory Management Architecture Guide
SQL Memory Uses
Devendra Kumar Sahu
246
Reputation points
I have SQL Server 2016 SE Version. I have Physical Memory 154GB and i assign to SQL 124GB. After few day i Consume 121GB memory in SQL Server. i know that It allocates memory for buffer pool (=cache) and hold it for it's work.
is there any written in Microsoft please let me know.
SQL Server | Other
Answer accepted by question author
Answer accepted by question author
1 additional answer
Sort by: Most helpful
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 1%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETP%3C/text%3E%3C/svg%3E)
Tom Phillips 17,786 Reputation points2021-09-24T12:10:23.167+00:00 That is completely normal, expected and desired behavior and does not indicate a problem in any way.
-
Devendra Kumar Sahu 246 Reputation points
2021-09-24T12:26:34.053+00:00 Yes i know it is normal behavior and i m not any problem facing but client need to prof from Microsoft side.
this i complete normal behavior. -
Tom Phillips 17,786 Reputation points
2021-09-24T14:43:45.133+00:00 When SQL Server is using memory dynamically, it queries the system periodically to determine the amount of free memory. Maintaining this free memory prevents the operating system (OS) from paging. If less memory is free, SQL Server releases memory to the OS. If more memory is free, SQL Server may allocate more memory. SQL Server adds memory only when its workload requires more memory; a server at rest does not increase the size of its virtual address space.
...
The instance then continues to acquire memory as needed to support the workload. As more users connect and run queries, SQL Server acquires the additional physical memory on demand. A SQL Server instance continues to acquire physical memory until it either reaches its max server memory allocation target or the OS indicates there is no longer an excess of free memory; it frees memory when it has more than the min server memory setting, and the OS indicates that there is a shortage of free memory.
Sign in to comment -