Post reply

AWE on A/A cluster

  • June 25, 2009 at 3:12 am

    #135397

    Hi

    I have one A/A cluster setup. On one of the node I see as AWE enabled but on the other node its not.

    just wanted to understand does it required to enable it on the other node too?

    If not enabling it on the other node, will SQL Server be able to provide more than 4GB of memory (win 2k3 Enterprise sp2)?

    Any indepth suggestion on this topic will be much appreciated.

    -Forum Etiquette: How to post Performance Problems[/url]

    -Forum Etiquette: How to post data/code to get the best help [/url]

  • June 25, 2009 at 3:26 am

    #1015156

    You don't enable AWE on a "node", you enable it on a SQL "instance".

    It sounds as though one of your instances has AWE enabled, and the other doesn't.

    It's up to you whether you enable it on both (depending on your application requirements).

    Don't forget, if one of your nodes is unavailable, both instances will be running on the same node, and if you are allocating the maximum amount of memory to each instance, then one is likely to be starved of memory.

  • June 25, 2009 at 3:34 am

    #1015160

    Understood.

    But Lets say if I am enabling it on one SQL instance which is A/A, will it automatically consider the same on its cluster counterpart?

    -Forum Etiquette: How to post Performance Problems[/url]

    -Forum Etiquette: How to post data/code to get the best help [/url]

  • June 25, 2009 at 4:15 am

    #1015176

    The answer is yes.

    Clustering just allows you to have 2 (or more) physical boxes that are capable of hosting your SQL instance and its resources.

    All the SQL configuration is done to the instance in exactly the same way you would if it was running standalone (i.e. not in a clustered environemt). So if you enable AWE while the instance is running on node 1, if you fail it over to node 2, AWE will be enabled.

  • June 25, 2009 at 5:00 am

    #1015200

    Ian is correct .

    The reason behind it is :

    When you make any changes in sp_configure , the updates are recorded in sys.configurations view (actual table is in mssqlresource which you cannot see as its readonly database and hidden).Now, the cluster nodes only have the binaries .The actual data and log files are shared among the nodes.

    So whether you are on node 1 or 2 the setting will persist since nodes are using the same datafiles of a particular instance .

    HTH

    Abhay Chaudhary
    Sr.DBA (MCITP/MCTS :SQL Server 2005/2008 ,OCP 9i)

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply