question

SanjeevKrChauhan-4271 avatar image
0 Votes"
SanjeevKrChauhan-4271 asked CarrinWu-MSFT commented

High Memory Utilization of SQL Server "sqlservr.exe"

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

sql-server-generalsql-server-integration-servicessql-server-analysis-services
· 1
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.

Hi @SanjeevKrChauhan-4271, we have not get a reply from you. Could below answers help you? If yes, please do "Accept Answer". By doing so, it will benefit for community members who have this similar issue. Your contribution is highly appreciated. Thank you!

0 Votes 0 ·
ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered

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.

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.

CarrinWu-MSFT avatar image
0 Votes"
CarrinWu-MSFT answered CarrinWu-MSFT edited

Hi @SanjeevKrChauhan-4271,

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.

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.