troubleshooting Question

SQL Server 2005 on Windows 2008 Memory Usage/Monitoring in Task Manager

Avatar of dbeutler
dbeutler asked on
Microsoft SQL Server 2005Windows Server 2008
5 Comments1 Solution2075 ViewsLast Modified:
We have a couple of fairly new HP C-Class Blade servers running 32-bit Windows Server 2008 Enterprise Edition with a Failover Cluster for SQL Server 2005.  Each server has 6GB of Memory.  In the System Properties, each server shows 6GB of Memory.  However, in task manager the server only shows 3.3GB of memory and SQL Server only using 1.7GB.  
From what I understand, PAE is enabled by default on 32-bit Windows 2008 server if the server supports hardware DEP.  DEP is enabled on these servers and they are fairly new(support hardware DEP) so I assume that PAE is enabled.
So here are my questions:
Shouldn't Task Manager show 6GB or is this the whole, "You have 6GB but since you are running 32-bit we will only show you 4GB(minus the "system" areas which leaves you with 3.3GB)" issue?
Is PAE really enabled?
Does AWE need to be enabled on the SQL Server instance in order for it to use all of the system memory?  (Lock Pages in memory for the SQL Process has already been enabled)
If awe is enabled, how can I tell if it is really utilizing the memory since I think all that is shown in Task manager is the "Application Memory" portion? (I use "Application Memory", for lack of a better term, to describe the memory utilized by SQL server which is not part of the extended memory utilized by AWE)
Daniel Beutler
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 5 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros