High Memory Utilization of SQL Server "sqlservr.exe"

Sanjeev Kr Chauhan 21 Reputation points
2021-10-10T09:39:50.483+00:00

SQL Server "sqlservr.exe" using 80-90 % of Memory, Please suggest for the solution.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,714 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,453 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,244 questions
Accepted answer
  1. Erland Sommarskog 101K Reputation points MVP
    2021-10-10T21:32:11.537+00:00

    The solution is in most cases to sit on your hands and do nothing. This is perfectly normal and desirable. SQL Server reads data into cache and let it stay there, for the simple reason that it faster to access data from RAM than from disk.

    If there other applicaitons running on the machine - and that includes SSMS, SSIS, SSRS and SSAS, you may want to limit how much memory SQL Server can get by setting the configuration option "max server memory", tio, say 80% of the total RAM, all depending on what the other applications need. If SQL Server is alone on the machine, you can head for 90%. The less memory you allow for SQL Server, the more disk reads you will get and your performance will degrade.

    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. CarrinWu-MSFT 6,851 Reputation points
    2021-10-11T06:08:04.12+00:00

    Hi @Sanjeev Kr Chauhan ,

    Thanks for your posting.

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

    In addition, 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. If you would like to change min server memory and max server memory, please refer to Server memory configuration options.

    Best regards,
    Carrin

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments