SQL Server Performance Forum – Threads Archive

Configure AWE on Cluster Server

All, In past i have configured AWE on cluster server but now i am bit confused.
Do i need to configure these values on both active and passive nodes or only on virtual server.
Can you please advise. Thanks All.
-S

---

AWE configuration is sql configuration…you should use sp_configure procedure to enable it… Memory configuration is depends on total memory and setting max server memory…
and number of sql instances. To use > 2GB memory… 1. Lock in memory pages configured on both nodes.
2. AWE enabled using sp_configure procedure
3. Set max server memory using sp_configure procedure
4. Restart sql server services. Use Total Server Memory and Targe Server memory perfmon counters to check the memory… http://www.microsoft.com/technet/prodtechnol/sql/2000/reskit/part4/c1261.mspx?mfr=true
http://support.microsoft.com/kb/274750
http://www.sql-server-performance.com/awe_memory.asp
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.

---

Thanks Mohammed.
Provided info was helpfull.

---

]]>