• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 173
  • Last Modified:

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.
0
Satuittech
Asked:
Satuittech
  • 2
  • 2
  • 2
2 Solutions
 
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
 
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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
Eugene ZCommented:
one more:
AWE Memory SQL Server Performance Tuning Tips
http://www.sql-server-performance.com/awe_memory.asp
0
 
CragCommented:
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

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

  • 2
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now