MS SQL server memory usage is high

I have a virtual server with assigned 94GB of memory. from the host level, the performance monitor shows everthing is good with about 18GB average memory usage for this vm.

However, when we log into the server, the memory usage is 93% high and the control of the server is difficult. The mouse is almost freezing.

When we check the resource monitor on the server, it show 94 GB memory is being used and only 970 MB is left free.

From the processes list, we checked the committed memory, it's far below the physical memory, what is wrong with this server's memory?
MS-SQL-Server-Memory-Usage-High.png
MS-SQL-Server-Memory-Usage-High02.png
MS-SQL-Server-Memory-Usage-High03.png
Jason YuAsked:
Who is Participating?
 
Bryant SchaperCommented:
You need to limit how much memory SQL uses or it consumes everything.  

In sql manager right click on the DB engine and choose properties and set the memory, I woudl reserve 8 GB.

Here is a very good article to discuss that.

https://www.simple-talk.com/sql/database-administration/provisioning-a-new-sql-server-instance-%E2%80%93-part-two/
0
 
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
SQL will always use as much memory in the VM, and release it back to the OS and Applications, when requested.

96GB is a lot of memory for a VM, does you SQL database need this much memory?

How much memory is in your host server ?

You've not over committed memory, and the Host is struggling with Host Memory Resource?
0
 
Jason YuAuthor Commented:
It's a Good host with 1.5 TB ram. I will check Sal manager to limit memory usage after I go back home.

Thank you too for replies. Have a wonderful weekend.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Vitor MontalvãoMSSQL Senior EngineerCommented:
There's any thing else installed in the SQL Server VM?
0
 
Jason YuAuthor Commented:
I got it resolved by allocate "reservation memory" and set up "limit memory" for this server inside vmware resources setup.

After I assigned reservation for memory and reboot, it began to work now.
0
 
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
If you have had to set a reservation which ring fences and guarantees memory for the VM, which stops the Hypervisor stealing memory from the VM, that means your Host is suffering memory pressure, and cannot allocate the memory to all VMs, especially this one, otherwise you would not have to set a memory reservation, unless the defaults were not in place.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.