SQL Server Performance

Adding memory in a SQL Cluster

Discussion in 'SQL Server Clustering' started by Vinny, Jun 1, 2005.

  1. Vinny New Member

    Hi!

    I have SQL active/passive cluster with 2 GB RAM. I want to add 2GB more memory in each node. What is the best practice to add memory in a live cluster?

    Thanks in advance

    Vinny
  2. Argyle New Member

    Failover to one node, take down other node and add memory, start it up and failover to it, take down the first node and add memory and start it back up then failover to the node where you want to have things running. If you have max sql memory fixed to a number be sure to increase it after the upgrade.
  3. Vinny New Member

    Thanks for you response and it helps. The max sql memory was a nice tip.

    But I have a question. Based on above procedure, there will be a time when two machines will not be identical in terms of memory size and will that be a problem?

    For example, active node is with memory 2GB and I increased memory on passive node to 4 GB. Now, if I failover to machine with 4GB will that be OKAY or not?

    Please let me know as i don't have any past exeperince of changing memory in a cluster

    Thanks,


  4. Argyle New Member

    There is no issue having more memory in the passive node during the upgrade. The nodes don't share memory or anything.

Share This Page