I am planning to double the memory on a MSW2003 Ent, SQL2000 2 node cluster -

Posted on 2007-10-10
Last Modified: 2007-10-15
I plan to start with the passive node, any tips or web site resources that would provide tips on the process. My concern is the impact clustering has on what normally would be a fairly simple process of add ram, adjust page file, make sure sql can use all available ram.
Question by:Satuittech
    LVL 5

    Expert Comment

    I believe that the steps would be:

    1. Power down system
    2. Add RAM
    3. Power up
    4. Resize page file - if required
    5. Restart to confirm new page file
    6. Fail over cluster
    7. Change SQL Server memory settings - no restart required
    repeat process on other server.

    Author Comment

    Have you actually performed a memory upgrade on a SQL cluster ? I concure on the steps but I am just curiouse with respect to the cluster part of the process. This is in a 24/7 environment with pretty much zero tollerance for down time. Thanks
    LVL 42

    Expert Comment

    check please:

    Large memory support is available in Windows Server 2003 and in Windows 2000

    How to configure SQL Server to use more than 2 GB of physical memory
    LVL 42

    Accepted Solution

    one more:
    AWE Memory SQL Server Performance Tuning Tips
    LVL 5

    Assisted Solution

    okay I confess - not seeing any numbers of sizes I wasn't thinking about the switches that might be required. thse changes would be made between steps 3 and 4 above.

    As for the 24/7 shop there are two aspects to this
    1. You will need to fail the cluster over so incur some down time. whether to you this twice to get back to the same node will depend.
    2. Always always always test this kind of process before you try it.

    Author Comment

    points split, thanks guys.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Why do Marketing keep bothering you?

    Is your marketing department constantly asking for new email signature updates? Are they requesting a different design for every department? Do they need yet another banner added? Don’t let it get you down! There is an easy way to manage all of these requests...

    Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
    Introduction In my previous article ( I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
    Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now