Unless there is a new 2012 feature that hasn't been well advertised, SQL Server does not do active/active clusters. .....
the A/A cluster on SQL Server is possible when we talking about HA and not HP!! the scene designed by Paul, for each instance that is avail on node, you would configure half of resources server to SQL Server, i.e. the server has 8 Gb RAM and 8 cpus, then to SQL this instance would have 4 Gb RAM and 4 CPUs and same configuration for other node!!!
when one node fails the other takes full workload!!!
Now, the load balance of workload, users and databases between sql servers, is a job of DBA!!! where is possible configure A/A cluster for HA!!!
For HP, only Windows 2008 R2 HPC, when we want performance of both servers in specific task!
- SQL Server 2008MCITP | MCTS remember is live or suffer twice!
the period you fastest growing is the most difficult period of your life!