Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
farrokhp
Starting Member
15 Posts |
 Posted - 2012-09-13 : 19:05:29
|
| 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
38200 Posts |
|
|
farrokhp
Starting Member
15 Posts |
Posted - 2012-09-13 : 19:11:44
|
| 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? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2012-09-13 : 19:23:45
|
| 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 |
|
|
|
|
|
|
Cluster change