question

DevendraSahu-0306 avatar image
0 Votes"
DevendraSahu-0306 asked TomPhillips-1744 edited

SQL Memory Uses

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-general
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered

Right, is by design that SQL Server holds the allocated memory, you can read about in article Memory Management Architecture Guide

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

TomPhillips-1744 avatar image
0 Votes"
TomPhillips-1744 answered TomPhillips-1744 edited

That is completely normal, expected and desired behavior and does not indicate a problem in any way.

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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.

0 Votes 0 ·

See:
https://docs.microsoft.com/en-us/sql/relational-databases/memory-management-architecture-guide?view=sql-server-ver15#dynamic-memory-management

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.

1 Vote 1 ·