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 |
|
jmbone
Starting Member
4 Posts |
 Posted - 2009-01-22 : 15:53:04
|
| We are looking into setting up multiple instances in an Active/Active cluster using SQL Server 2008 with 2-4 nodes - each node with one active cluster.I am wondering if many people do this?Also, is this a stable feature to use in SQL Server 2008 with Windows 2008 64-bit?Thank you for any input.Jana |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2009-01-22 : 16:01:10
|
| I would highly recommend using only a 2-node cluster. If you need 4 nodes, then I would suggest 2 2-node clusters. We have a 4-node cluster and will never go above 2 again. The reason behind this is because it takes too much time to apply service packs, security patches, and other maintenance type things on the 4-node cluster. You can only launch the installers on one node at a time. If we had instead used 2 2-node clusters, we could launch two installers. Our 4-node cluster is active/active/active/active with 11 SQL Server 2005 instances.I don't have any experience with SQL Server 2008 yet, but my recommendation would still apply.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
|
|
|
Active/Active (multi-instance) clustering in 2008