How? SQL Cluster with multiple active nodes (not failover)

I'm building a new SQL 2008 R2 (Enterprise) Cluster that is backed by an EqualLogic iSCSI SAN. Instead of building a failover cluster (which I have done), I would instead like to setup several nodes that are all active simultaneously. I want to spread out the CPU/RAM load across the nodes.

Can anyone point me towards a document on this? I'm only finding info on HA/Failover clusters.

You don't get "load balancing" with SQL Server. There are a lot of "High Availability" features including clustering.

That is, you can't have read/write on the same data with multiple SQL Server instances.

You can off load reporting onto a snapshot, or replicate data between Instances, or "shared scalabl" but none is full OLTP on all data on every node.

You scale up, not out, for SQL Sever

• SO: SQL Server load balancing

• SF: How to load-balance SQL Server 2008 for high-usage ASP.NET applications?

StackExchange Database Administrators Q#5351, answer score: 6