1

I have a Windows Server 2008 system running IIS 7 and SQL Server 2008 R2 with 64gb of RAM which is showing 100% of the available physical RAM being used at all times.

However, when you look at the memory usage via Task Manager and Process Explorer, all the processes (from all users) add up to less than 6gb of total RAM usage.

I'm trying to figure out what is using the remaining 58gb of RAM and I'm having trouble figuring it out.

Can anybody shed some light on this?

Thanks in advance.

Improve this question
2
  • 1
    32-bit or 64-bit? If you are running 32-bit with AWE then it won't appear as in use by the SQL process. Commented Jan 10, 2014 at 21:50
  • 1
    64-bit but I think I may have found the answer here: dba.stackexchange.com/questions/7060/… Waiting to get access to SQL before I can run the queries but that matches what I found. Commented Jan 10, 2014 at 22:23

1 Answer 1

Reset to default
2

Found the answer over here: https://dba.stackexchange.com/questions/7060/sql-server-2008-r2-ghost-memory

On the same page, there is a link to a blog post with an even great explanation: http://www.brentozar.com/archive/2011/09/sysadmins-guide-microsoft-sql-server-memory/

Improve this answer

You must log in to answer this question.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.