SQL Server Performance Forum – Threads Archive
Adding memory in a SQL ClusterHi! 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
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.
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,
There is no issue having more memory in the passive node during the upgrade. The nodes don’t share memory or anything.