Post reply

Increasing memory on 32 bit sql cluster with AWE already enabled

  • January 10, 2013 at 10:12 pm

    #287704

    Hi, we have a 32 bit SQL 2005 cluster running on Windows 2003 cluster. Right now it has 24 GB allocated to SQL, 8 GB to OS. It has the PAE switch enabled and AWE enabled.

    Right now, apparently we need to add more memory. This is inevitable due to certain.. well I guess I'll leave it at that..

    That said, the plan is to add 32 GB to both nodes of the cluster.

    My question is - After server admin completes adding memory, reboots, failover and all - From SQL perspective, is it enough to just change memory setting (using sp_configure 'max server memory') or is there anything else to be done. Since PAE and AWE have already been implemented.

  • January 11, 2013 at 3:35 am

    #1576154

    Setting max memory will do the job.

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • January 11, 2013 at 5:47 am

    #1576227

    Bhuvnesh (1/11/2013)

    Setting max memory will do the job.

    +1

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • January 11, 2013 at 11:11 am

    #1576454

    opc.three (1/11/2013)

    Bhuvnesh (1/11/2013)

    Setting max memory will do the job.

    +1

    i ddint get this..

    Regards
    Durai Nagarajan

  • January 11, 2013 at 1:07 pm

    #1576489

    durai nagarajan (1/11/2013)

    opc.three (1/11/2013)

    Bhuvnesh (1/11/2013)

    Setting max memory will do the job.

    +1

    i ddint get this..

    +1

    It means: I agree with the statement.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • January 12, 2013 at 11:41 am

    #1576621

    Thanks to both of you for the information.

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

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