Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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.

share|improve this question
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. –  phoebus Jan 10 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. –  Windows Ninja Jan 10 at 22:23

1 Answer 1

up vote 1 down vote accepted

Found the answer over here: http://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/

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.