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?