SQLservr.exe taking up lots of memory

Hein Thant Oo 20 Reputation points
2024-06-12T04:22:55.5533333+00:00

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

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,323 questions
0 comments No comments
{count} votes

Accepted answer
  1. Yanhong Liu 4,970 Reputation points Microsoft Vendor
    2024-06-12T05:52:08.1633333+00:00

    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.

    1 person found this answer helpful.
    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Olaf Helper 43,166 Reputation points
    2024-06-12T05:30:34.8533333+00:00

    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

    1 person found this answer helpful.
    0 comments No comments