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?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
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
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

Paul SolovyovskySenior IT AdvisorCommented:
What version of ESX are you running and list which update.  Also provide the CPU version (nehalem, etc..)
0
C_ParlatoAuthor 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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
VMware

From novice to tech pro — start learning today.