SQL Sever 2008 Memory usage

Dear All,
I have SQL Server 2008 that is running on VMware VM installed with windows server 2003 R2 64 bit.

8 GRAM are assigned to this VM and the vsphere performance for this VM shows that the memory usage is 16%

But inside the OS ( with monitoring tool) the memory usage is 98 % and sqlserver.exe process is using high memory (which is normal for SQL structure).

I need to know the actual memory usage in the server, I can not decide if i need to assign more memory to the server or no.


Kindly advice.
mostabdoAsked:
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.

Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
That SQL process (sqlserver.exe) will ALWAYS grab all the memory in the computer, and when applications ask for memory, the SQL process (sqlserver.exe), will return the memory to the system.
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
Aneesh RetnakaranDatabase AdministratorCommented:
You need to check the memory pressure on your server, use performance counter to determine

http://blogs.msdn.com/b/rafidl/archive/2010/06/07/check-if-you-have-sql-memory-pressure-using-perfmon.aspx
0
mostabdoAuthor Commented:
Yes i know this from my researches on internet but how i can decide of the computer memory is sufficient?and what is exactly used from all grapped memory?
0
Newly released Acronis True Image 2019

In announcing the release of the 15th Anniversary Edition of Acronis True Image 2019, the company revealed that its artificial intelligence-based anti-ransomware technology – stopped more than 200,000 ransomware attacks on 150,000 customers last year.

Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
what is the Active Guest Memory reported in vSphere.
0
mostabdoAuthor Commented:
The average of active memory is 2582087.3 KB
0
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
Unless you are experiencing any performance issues, which are memory related and not CPU or Disk bound, I would think your currently memory allocated is okay.

keep checking performance graphs in vCenter Server/ESXi.
0
mostabdoAuthor Commented:
Can you help with the recommended memory for the SQL server2008 in order to set minumum and maximum memory for the SQL
0
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
What application, and how many user access the SQL database.
0
mostabdoAuthor Commented:
ETMS application (inhouse application) and aroud 350 user cn access the DB
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
Microsoft SQL Server 2008

From novice to tech pro — start learning today.