SQLservr.exe taking up lots of memory

Question

Windows SQL server memory has been consuming too high by sqlservr.exe

Answer 1

Hello,

Thank you for posting in Q&A forum.

By default, SQL Server can change its memory requirements dynamically based on available system resources. So it is normal that Memory Usage is huge.

If less memory is free, SQL Server releases memory to the OS. If more memory is free, SQL Server may allocate more memory. If you would like to change min server memory and max server memory, please refer to: Server memory configuration options - SQL Server | Microsoft Learn

Best Regards,

Yanhong Liu

============================================

If the Answer is helpful, please click "Accept Answer" and upvote it.

Answer 2

Of course; that's more then quite normal and "by design", see https://learn.microsoft.com/en-us/sql/relational-databases/memory-management-architecture-guide?view=sql-server-ver16

SQL Server takes all memory as it can to serve queries in a performant way; how else could it work?

You can limit the maximum memory usage by SQL Server see,

https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/server-memory-server-configuration-options?view=sql-server-ver16