Avatar of NytroZ
NytroZ
Flag for United States of America asked on

Server doesn't use all memory

I have a Windows 2012  x65 VM running in ESX 5.5.  SQL 2012 is also installed on this vm.  There is 24 GB of memory installed but no matter what is opened the vm will not access more than 4 GB of the 24 GB allocated to it.  Memory was recently upgraded from 4GB to 24GB.  Why is the vm not utilizing the added memory?
Windows Server 2012VMware

Avatar of undefined
Last Comment
Qlemo

8/22/2022 - Mon
Andrew Hancock (VMware vExpert PRO / EE Fellow/British Beekeeper)

What does task manager, and vCenter Server record as Active ?
NytroZ

ASKER
vcenter-memory.png
memory.png
Andrew Hancock (VMware vExpert PRO / EE Fellow/British Beekeeper)

so you mention 24GB, and that VM shows its configured for 16GB ?

3.4GB is in use, if it needs more memory, it will use it.

You can use Prime95

http://www.mersenne.org/download/

and run it, and it will use all your memory.
Your help has saved me hundreds of hours of internet surfing.
fblack61
NytroZ

ASKER
My bad, I was told it had 24Gb but really only has 16Gb.  Sorry for the confusion.
NytroZ

ASKER
It doesn't seem to matter what is running.  The memory does not go over 25% or 4GB.

memory.png
NytroZ

ASKER
primus.png
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
ASKER CERTIFIED SOLUTION
Andrew Hancock (VMware vExpert PRO / EE Fellow/British Beekeeper)

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
NytroZ

ASKER
I used the blended  settings.  Says it uses lots of RAM so I assumed it would use more than 2GB.

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

CUSTOM

and then input Memory to use (in MB) - 8192

be careful with the value here, if you put in e.g. 24GB, you'll lose control of the VM!
NytroZ

ASKER
I used a custom setting and set to 16Gb and its using all of its memory so I guess I don't have a problem.  I don't' understand why SQL is not using the memory like it is usually does.  Normally SQL will use just about all the memory that is available.  Thank you for showing me the app.
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
Andrew Hancock (VMware vExpert PRO / EE Fellow/British Beekeeper)

Depends what SQL requires.

There is 24 GB of memory installed but no matter what is opened the vm will not access more than 4 GB of the 24 GB allocated to it.

I think you've proved this!

I would suggest a post in the SQL zone, and you can discuss with SQL Experts, SQL tweaks etc but your VM is configured and working as it should.
Qlemo

As said by Andrew, if SQL Server doesn't use more memory, it doesn't need more. Unless someone has configured the instance to not use more than x MB, which you can see in Management Studio, Properties of the instance.