SQL Server "sqlservr.exe" using 80-90 % of Memory, Please suggest for the solution.
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.
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.
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.
16 people are following this question.