SQL Server Performance Forum – Threads Archive

Right Step to enable AWE on Cluster

We have a SQL Cluster box, passive/active. Recently, we plan to upgrade memory to 8G and enable AWE. What’s the right procedure to enable AWE? Can I just run following scripts against virtual sever, and all change will be populate the each node SP_CONFIGURE ‘show advanced options’, 1
RECONFIGURE
GO SP_CONFIGURE ‘awe enabled’, 1
RECONFIGURE
GO SP_CONFIGURE ‘max server memory’, 7144
RECONFIGURE
GO OR since it is a cluster server, I need to run scripts against each instance. Any suggestion?

If you are active passive I assume you only have one SQL instance installed. You are correct to run the above. You need only do it once. You do not need to run it on each idividual node. Rememeber you can always run it, failover the cluster and the run sp_configure and view the settings. You will see it still has AWE enabled. Simon

thanks. This is what I want to know.

quote:Originally posted by simondm If you are active passive I assume you only have one SQL instance installed. You are correct to run the above. You need only do it once. You do not need to run it on each idividual node. Rememeber you can always run it, failover the cluster and the run sp_configure and view the settings. You will see it still has AWE enabled. Simon

Simon, What about running cluster with active/active and 2 instance? Thanks both to Lanlan and Simon for the subject and answer.

You enable it once for each instance. If you are running active/active and want one node to be able to handle the load from both during a failover then configure the memory so there is enough for both running on a single node.

Thank you Argyle!

]]>