MSSQLTREK

3 responses to “SQLBuzz – 2012 in Review.”

1. 

   Satish Alahari

   January 7, 2013

   I would like to see any document of yours if you have done for SQL Active- Active Cluster, this will be really useful, Most of the times we get A-P document but any document with your kind of Explination having screenshots on A-A SQL cluster will be of great use, Thank You so much.

   Reply
   1. 

      sreekanth bandarla

      January 8, 2013

      Satish – Let me suggest you to forget about A-P and A-A SQL cluster for a moment. Think about Single Instance Cluster and Multi Instance Cluster. Go ahead and Install one more Clustered SQL Instance on the same failover cluster, that’s it, It becomes your A-A cluster. It’s really that simple!!! It’s not really that hard, once you get the concept of installing a clustered SQL Instance. That’s the reason, you won’t be seeing many documents explaining A-A(Multi Instance) configuration. Eventually we’ve to write up something which will be nothing but a duplicate effort! Let me know if you still have any questions….

      Reply
2. 

   Wayne

   April 25, 2013

   Absolutely! If you’ve got to use a buzzword, try “N+1” to refer to the preferred configuration of having one more node that you have ‘active’ applications. If I have four SQL instances and an Analysis Services instance all running on the cluster it would ideally be a six node failover cluster. Of course, Availability Groups changes the math a bit, but for traditional failover clusters “N+1” is still ideal.

   Reply