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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.