using AWE for SQL Server 2005

[holdahl]

I have an installed instance of SQL Server 2005 on a 2 noded cluster (Windows Server 2003 Enterprise Edition)

both nodes have 8GB of RAM.

when I monitor the SQL Server, it shows that it only used approx. 1.6GB of RAM.

I do belive I have to enable the PAE in boot.ini and then enable AWE for it to use more of the RAM.

Do you have to do anything special to enable this since it is a cluster, or do you just enable PAE then AWE on both nodes and set min and max memory for the SQL Server to use?

 

[mrdenny]

That should be all you need to do. Are you sure that having AWE enabled is the current running setting in the SQL Server? What does sp_configure show you for AWE?

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[holdahl]

well, it says like this for awe enabled:
--------------------------------------------------------
| minimum | maximum | config_val | run_val |
awe enabled | 0 | 1 | 1 | 0 |
---------------------------------------------------------

I was going to enable PAE and AWE on both nodes, then set the max and min memory usage on the one instance of SQL Server that run on the cluster.


sH

 

[mrdenny]

You've configured SQL to use AWE, but not activeated the configuration. Run this SQL command then check sp_configure.

reconfigure with override

That should change the run_val from 0 to 1 for AWE. If it doesn't schedule a restart of the SQL Service. If the host OS hasn't been rebooted since you changed the boot.ini the OS will need a restart as well before you can use the extra memory.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com