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.
Best Answer
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