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)