dbeutler
asked on
SQL Server 2005 on Windows 2008 Memory Usage/Monitoring in Task Manager
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)
Thanks,
Daniel Beutler
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)
Thanks,
Daniel Beutler
ASKER
It seems odd to me that you disabled DEP(nx) before enabling PAE. What were your reasons for this? How do you know it worked?
Sorry something went wrong here. Please see http://www.petri.co.il/forums/showthread.php?t=25018 for yourself. You are right, why disable DEP, leave it on.
ASKER
Although that doesn't answer my initial question of "Is PAE really enabled?", It does tell me how to enable it. Anyone feel like taking on the other questions?
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
http://www.thegeeksweek.com/blog/ena...ows-vista.html
So, what we did was diable the NX and enable the PAE with these command lines:
1. BCDEdit /set nx AlwaysOff
2. BCDEdit /set PAE forceenable
3. Reboot
Not sure how important it was that we do these in this order, but it worked.