Server doesn't use all memory

NytroZ
NytroZ used Ask the Experts™
on
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?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Andrew Hancock (VMware vExpert / EE Fellow)VMware and Virtualization Consultant
Fellow 2018
Expert of the Year 2017

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

Author

Commented:
vcenter-memory.png
memory.png
Andrew Hancock (VMware vExpert / EE Fellow)VMware and Virtualization Consultant
Fellow 2018
Expert of the Year 2017

Commented:
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.
Angular Fundamentals

Learn the fundamentals of Angular 2, a JavaScript framework for developing dynamic single page applications.

Author

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

Author

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

memory.png

Author

Commented:
primus.png
VMware and Virtualization Consultant
Fellow 2018
Expert of the Year 2017
Commented:
Download Prime95, run it, select how much memory to use, and let it run....

you will see the memory increase as it uses it!

and what did you specify in Prime95 ?

Select Custom, and put in Amount of Memory to use 2GB is default. Put in e.g. 8192 (8GB)

Author

Commented:
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 / EE Fellow)VMware and Virtualization Consultant
Fellow 2018
Expert of the Year 2017

Commented:
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!

Author

Commented:
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.
Andrew Hancock (VMware vExpert / EE Fellow)VMware and Virtualization Consultant
Fellow 2018
Expert of the Year 2017

Commented:
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"Batchelor", Developer and EE Topic Advisor
Top Expert 2015

Commented:
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.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial