🙂 🙂 🙂 🙂 🙂 :)……………
Here’s an excerpt:
19,000 people fit into the new Barclays Center to see Jay-Z perform. This blog was viewed about 74,000 times in 2012. If it were a concert at the Barclays Center, it would take about 4 sold-out performances for that many people to see it.
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.
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….
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.