ESX 4 Running SQL 2008 on Win 2008 Memory Leak

I'm running a Dell 710 with 32 GB Ram and 2 Quad Procs.   ESX 4

The VM in question appears to have memory warning constantly.   I'm running SQL 2008 on Win 2008 with 8GB Ram.   Task manager shows the correct amount of RAM and the SQL max and min (1GB and 6GB)  memory is configured.   AWE is disabled as well as Page Locks.    

Task manger is showing around 3.9GB used with another 3.4 or so available.  However, the VI Client is saying that 99% of the memory is being utilized.   That doesn't seem right.  

It's possible that I've simply configured everything wrong.   But not sure where to check first.

LVL 2
C_ParlatoAsked:
Who is Participating?
 
C_ParlatoConnect With a Mentor Author Commented:
This issue was resolved by patching the host with the following patch.

http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=1013206

This processor was a 5500 series and ESX 4.0 had an issue with the i7 and E5500 series.
0
 
Matthew EnglandTechnology ConsultantCommented:
How long has the VM been in operation in the configured state?
Are there reservations or limits configured for the VM? (VM Properties > Resources tab)
Do you have VMWare tools installed on the VM?
Under Resource Allocation for the HOST system, what is the Reserved & Available capacity indicated for Memory?

0
 
C_ParlatoAuthor Commented:
How long has the VM been in operation in the configured state?
86 Days

Are there reservations or limits configured for the VM? (VM Properties > Resources tab)
Shares > Normal
0 Reserved
Unlimited.

Do you have VMWare tools installed on the VM?
Yes

Under Resource Allocation for the HOST system, what is the Reserved & Available capacity indicated for Memory?
Reserved 1580.25MB
Available 27839.76MB
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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.

 
C_ParlatoAuthor Commented:
This is a SS of the Task Manager from the VM and the Performance Tab in the VI Client
TaskMan.jpg
MemoryChart.JPG
0
 
Paul SolovyovskySenior IT AdvisorCommented:
What version of ESX are you running and list which update.  Also provide the CPU version (nehalem, etc..)
0
 
Paul SolovyovskySenior IT AdvisorCommented:
That's what I thought..that's why I asked about the CPU..good find

These patches fix an issue where a guest operating system shows high memory usage on Nehalem based systems
0
All Courses

From novice to tech pro — start learning today.