16 node failover clustering in SQL Server 2008
Failover Clustering nodes, SQL Server 2008, SQL Server 2008 administration, SQL Server 2008 performance
How can 16 node failover clustering be achieved in Microsft SQL 2008 enterprise edition? Are all nodes in active state? How many nodes can remain active?
Software/Hardware used:
Software/Hardware used:
ASKED:
April 13, 2010 9:31 AM
UPDATED:
April 13, 2010 6:22 PM
Answer Wiki:
The SQL instance will only be active on any one node at a time. If you have a 16 node cluster you can install 16 instances on it and each one could be active on its own node. You however can't spread the load across multiple physical servers.
SQL Server 2008 R2 will support scaleout across multiple nodes for data warehouses only using the Parallel Data Warehouse Edition, however this requires buying specific hardware, and is something like $2M to get started.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
