SQL Server Performance Forum – Threads Archive
Active/Active vs Active/PassiveWhat are the pros and con of configuring clusters as Active/Passive vs Active/Active? What are the maintenance, setup, performance, failover differences? Everywhere I’ve read that Active/Passive is preferred method but I haven’t found reason why. Thanks
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.
To put it briefly, there are two main advantages of active/passive over active/active: 1) Easier to maintain.
2) The second node will be able to take over the full load of node 1, not shared like in an active/active setup. —————————–
Brad M. McGehee, MVP