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

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.
SatuittechAsked:
Who is Participating?
 
Eugene ZConnect With a Mentor Commented:
one more:
AWE Memory SQL Server Performance Tuning Tips
http://www.sql-server-performance.com/awe_memory.asp
0
 
CragCommented:
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.
0
 
SatuittechAuthor Commented:
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
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Eugene ZCommented:
check please:

Large memory support is available in Windows Server 2003 and in Windows 2000
http://support.microsoft.com/kb/283037

How to configure SQL Server to use more than 2 GB of physical memory
http://support.microsoft.com/kb/274750
0
 
CragConnect With a Mentor Commented:
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.
0
 
SatuittechAuthor Commented:
points split, thanks guys.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.