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. quote:Originally posted by MohammedU 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.
