will culstered server support load balancing? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

will culstered server support load balancing?

HI All, Will SQL Server support load balancing supports effectivly with active/passive or active-active/passive-passive. As I know Shared Array won’t allow two instances to write at same time. Then how the 4 node cluster will support if so? Thanks in advance
No. There is really no such a thing as a true 4-node cluster with SQL Server. The only way to do load balancing with multiple DB servers is to design from the ground up. You can segment your data into categories, such as region. You can then have applications pointing at various servers based on region. With replication involved, you could drive and some good monitoring or workload decisioning, you could switch the application load through automated logic. MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.
]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |