SQL Server Performance Forum – Threads Archive

Active/Active vs Active/Passive

What 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

---

Check: http://www.sql-server-performance.com/wndows2000_clustering_install_step1.asp
Luis Martin
Moderator
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
Webmaster
SQL-Server-Performance.Com

---

]]>