SQL Server Performance

awe enable on cluster box

Discussion in 'SQL Server Clustering' started by purimn, Mar 22, 2007.

  1. purimn New Member

    Hi,

    I am Planning to enable awe for a particular Sql server instance on two node cluster box with 4 instances, here are few questions:

    1) Grant the SQL service account, the ability to ‘lock pages in memory#%92 - should this be done on both the NOdes (1 and 2)?

    2) The request is to enable awe for 12 GB usage :

    sp_configure 'max server memory', 12000
    RECONFIGURE
    GO

    ( should I specific 12000 or some other number, as per other
    samples, which is always a higher number. if the requirement is 6GB, they use 6144MB as the parameter.)

    3) Stop and restart SQLE instance - this has to be done through the
    Cluster adminstrator ?

    4) After implementing, how do we verify that sql server instance is using 12 GB RAM. Hints or links to articles, will be help.



    Thanks.

    Windows 2003 DataCenter Server
    Memory 16223 (on both the nodes)
    SQL SERVER 2k ENTERPRISE
  2. purimn New Member

    Hi,

    I am Planning to enable awe for a particular Sql server instance on two node cluster box with 4 instances, here are few questions:

    1) Grant the SQL service account, the ability to ‘lock pages in memory#%92 - should this be done on both the NOdes (1 and 2)?



    2) Stop and restart SQLE instance - this has to be done through the
    Cluster adminstrator ?

    3) After implementing, how do we verify that sql server instance is using 12 GB RAM. Hints or links to articles, will be help.



    Thanks.

    Windows 2003 DataCenter Server
    Memory 16223 (on both the nodes)
    SQL SERVER 2k ENTERPRISE
  3. phanigk New Member

    if this is a active/passive cluster and both nodes have the same 16gb memory on them then

    - set the max server memory to 15gb with the same options you gave
    - apart from that donot forget to set /3gb and /PAE switches in BOOT.INI file on both the nodes.
    - reboot the nodes

    You still need to give "lock pages in memory" on the nodes for the sql server service account.

    if this is a active/active cluster and both nodes have the same 16gb memory on them then
    specify less than 8GB for each instance. This is because in this case if the instances failover to one node then each instance will take the configured amount of memory per instance and the sum total is greater than the physical memory on the node then one of the instances may not come up at all.
  4. MohammedU New Member

    If it is active/passive (one instance) donot use /3GB if your server has >12 GB free memory...and leave the 2 GB to OS and rest can be configured to SQL...

    Yes, you need to do Lock pages in memory on both nodes...

    When AWE is enabled memory is not dynamic, you are correct you need to start the sql services but it can't be done through cluster admin or EM...

    You can use SQLServer:Memory Manager: Total Server Memory (KB) and SQLServer:Memory Manager: Target Server Memory (KB) counters to check the memory usage...

    Read the following articles for more info...

    How to configure SQL Server to use more than 2 GB of physical memory
    http://support.microsoft.com/kb/274750

    SQL Server for Developers
    Inside SQL Server 2000's Memory Management Facilities
    http://msdn2.microsoft.com/en-us/library/aa175282(SQL.80).aspx


    MohammedU.
    Moderator
    SQL-Server-Performance.com

Share This Page