Solved

Server doesn't use all memory

Posted on 2016-08-30
12
54 Views
Last Modified: 2016-08-31
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?
0
Comment
Question by:NytroZ
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 5
12 Comments
 
LVL 120
ID: 41776993
What does task manager, and vCenter Server record as Active ?
0
 

Author Comment

by:NytroZ
ID: 41777074
vcenter-memory.png
memory.png
0
 
LVL 120
ID: 41777154
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.
0
Edgartown IT Case Study

Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!

 

Author Comment

by:NytroZ
ID: 41777169
My bad, I was told it had 24Gb but really only has 16Gb.  Sorry for the confusion.
0
 

Author Comment

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

memory.png
0
 

Author Comment

by:NytroZ
ID: 41777207
primus.png
0
 
LVL 120

Accepted Solution

by:
Andrew Hancock (VMware vExpert / EE MVE^2) earned 500 total points
ID: 41777212
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)
0
 

Author Comment

by:NytroZ
ID: 41777223
I used the blended  settings.  Says it uses lots of RAM so I assumed it would use more than 2GB.

primus.png
0
 
LVL 120
ID: 41777241
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!
0
 

Author Comment

by:NytroZ
ID: 41777255
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.
0
 
LVL 120
ID: 41777260
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.
0
 
LVL 69

Expert Comment

by:Qlemo
ID: 41777629
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.
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this step by step tutorial with screenshots, we will show you HOW TO: Enable SSH Remote Access on a VMware vSphere Hypervisor 6.5 (ESXi 6.5). This is important if you need to enable SSH remote access for additional troubleshooting of the ESXi hos…
Giving access to ESXi shell console is always an issue for IT departments to other Teams, or Projects. We need to find a way so that teams can use ESXTOP for their POCs, or tests without giving them the access to ESXi host shell console with a root …
In this Micro Tutorial viewers will learn how to use Windows Server Backup to create full image of their system. Tutorial shows how to install Windows Server Backup Feature on Windows 2012R2 and how to configure scheduled Bare Metal Recovery backup.…
In this Micro Tutorial viewers will learn how to restore their server from Bare Metal Backup image created with Windows Server Backup feature. As an example Windows 2012R2 is used.

697 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question