SQL Server Performance

Configure AWE on Cluster Server

Discussion in 'SQL Server Clustering' started by sahil, Apr 24, 2007.

  1. sahil New Member

    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
  2. MohammedU New Member

    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.
  3. sahil New Member

    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.

Share This Page