SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 High Availability (2008)
 Cluster change
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

farrokhp
Starting Member

15 Posts

Posted - 09/13/2012 :  19:05:29  Show Profile  Reply with Quote
We have A/P node on 2008 want to convert it to A/A because management want to utilize the spare server as well? Questions:

1- What is the best practice to doing that?
2- what are the major things need to change? Same servers?
3- What will be happen if Failover occurred?

tkizer
Almighty SQL Goddess

USA
35940 Posts

Posted - 09/13/2012 :  19:08:07  Show Profile  Visit tkizer's Homepage  Reply with Quote
1. Best practice is don't. But if you must, you need to install another instance.
2. Min/max memory for each SQL instance; ensure you have adequate hardware for both instances to run on one node in case you lose the other node
3. You'll want to fix whatever issue occurred and failback to balance the cluster again.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Edited by - tkizer on 09/13/2012 19:08:31
Go to Top of Page

farrokhp
Starting Member

15 Posts

Posted - 09/13/2012 :  19:11:44  Show Profile  Reply with Quote
Thanks may I ask more:

1- Do I need to install sqlserver again on the newly active node? Or just add new App to this Node?
2- Each server has 32GB RAM? what do u mean min/max setting?
3- What change should be done in Windows Cluster Admin?
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
35940 Posts

Posted - 09/13/2012 :  19:20:36  Show Profile  Visit tkizer's Homepage  Reply with Quote
1. It's just another install, same as you did the first time.
2. Well you need to set these in case of a failover. Min/max memory in sp_configure for each instance.
3. It depends why the failover occurred. There are probably hundreds of reasons.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

chadmat
The Chadinator

USA
1974 Posts

Posted - 09/13/2012 :  19:23:45  Show Profile  Visit chadmat's Homepage  Reply with Quote
1. You need to install a new Failover Cluster Instance, and add a node.
2. There are 2 routs you can go, you can set each instance's Max Server Memory to something like 14GB so in the case when they are both running on the same node, there is enough memory. You could also set them both to somethng like 24GB. Obviously there is not enough memory on a single node to be able to give each instance 24GB if there is a failover and they are both running on a single node, but there would be enough for both instances to start and run. This would be ok if you have good monitoring, and can get in and quickly reconfigure memory in the case of a failover.
3. No changes required in Windows Cluster Admin. You will need another set of Shared storage for the 2nd instance though.

-Chad
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000