asked on

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

ASKER CERTIFIED SOLUTION

Bryant Schaper

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Andrew Hancock (VMware vExpert PRO / EE Fellow/British Beekeeper)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Jason Yu

ASKER

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.

Vitor Montalvão

There's any thing else installed in the SQL Server VM?

Jason Yu

ASKER

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.

Andrew Hancock (VMware vExpert PRO / EE Fellow/British Beekeeper)

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.