active/active vs active/passive cluster question
Posted on 2006-11-20
In my current situation, I have a active/passive situation, but I'm being pressured to turn it into a active/active under the perception that it will improve crunching power.
As I understood, Microsoft Clustering; it is a high-availability solution, not a load balancing one.
So with a active/active cluster, what are the benefits in a SQL environment? It's not as if 2-nodes can share a single virtual SQL instance, so what would be the point of building a active/active cluster?