SQL Server Performance

Adding RAM to SQL Cluster Nodes - Procedure

Discussion in 'SQL Server 2005 Clustering' started by subflux, Oct 6, 2009.

  1. subflux New Member

    Hi,
    My Sql Server 2k5 cluster has two nodes, both only have 2GB ram.I want to upgrade the ram of each host, and keep the cluster on-line.Is it safe to take one host offlince, uprgade it's ram, then bring it back up as part of the cluster, then repeat the process for the second host?
    Does SQL Server need to be reconfigured to take advantage of this new ram?Can anyone point me in the direction of documentation for this procedure?
    Many thanks,
    Kenny
  2. melvinlusk Member

    I've done something similar in the past when replacing faulty RAM in a single node.
    You should be able to do something like this:
    1) Bring down the inactive node (node 1)
    2) Upgrade the RAM in node 1
    3) Bring node 1 back online
    4) Fail node 2 over to node 1
    5) Bring down node 2, upgrade the RAM, bring it back online
    SQL should see the increased amount of RAM, unless you're total amount of RAM will be in excess of 4 GB....in which case you'll have to enable PAE and AWE if you're using a 32-bit version of Windows/SQL.

Share This Page