Change Max Memory in SQL 2008 cluster


  • Hi,

    Currently we have 2-node SQL 2008 R2 cluster.

    Each node is Fujitsu Blade with 36GB RAM.

    On each node we allowed SQL server 28672 MB of RAM. Now on one of servers we need to allocate more RAM (for the start I think 30720MB if need I guess we can go with 32768 MB???).

    Will ther be any kind of downtime? Can I change setting on one node, and then on another? What is the right way to do this?

    Any kind of advice, since this is first time, I 'm doing this on cluster...

    Thanks in advance

    Tuesday, June 12, 2012 1:51 PM

All replies