Low SQL 2008 memory usage

Hi guys, I have a Windows 2008 Ent edition 64bit and SQL 2008 Ent 64 bit. Recently the performance is very sluggish. It has got 12gb of physical ram. I looked at the task manager. Memory usage is 97%. However when i look at the sqlservr.exe process, its only using 116,792K of ram. Why is the ram consume so little? This is the production server with high specs. I have a similar testing environment running on VM and it shows the correct amount of ram for sqlservr.exe process. Please advise.
Who is Participating?
SQLserver.exe itself has a small memory foot print as you can see the rest of the memory used should be occupied by primarily data cache (data pages read from the database files and allocated in memory to spedd up the process since memory is factor 1000 faster than disk i/o. In Perfomance monitor add the SQL memory counters and you should  'see' the occupied memory and how it is used. Vmware offers the benefit of an additional abstraction layer which simplifies seeing where your memory is used. You can open a perfmon session in the machine in vmware as well and use the SQL memory counters they should mimick your physical machine.
SQL server memory manager principals explained in this article


SQL server memory management also explained in this link


hope this links helps you...
lcohanDatabase AnalystCommented:
And you could easily find what/how is being used - please see solution at:

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.

totallypatrickAuthor Commented:
But i have set the Max memory in SQL manager that leaves 2GB for OS but i'm still seeing physical memory used is 96 to 97%
There are other processes runnign that will occupy physical memory in the low 2 GB adress space. SQL may have nothing to do with it. On the other DTSrun can occupy memory in the lower 2 GB range. Start Task manager - under processes make sure you check the box to allow to see precesses from all users then under view select columns add the memory commit size to the visible counters (you may have to expand your window to the right to see the newly added counter) this will further help you in tracking down what process is occupying your memory.
lcohanDatabase AnalystCommented:
SQL data(mainly) and code cache will take most of the physical RAM from that box unless you specify that in SQL MEM config: http://support.microsoft.com/kb/321363

"[...]  the Task Manager and Performance Monitor may show that the physical memory available on the computer is steadily decreasing until the available memory is between 4 to 10 MB."
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.