Is there any comparision whitepaper to describe to use a/a mode or a/p mode for SQL Cluster
I was told that Microsoft suggested to use a/p mode, so during the failover to a/a mode server would have less chance to get trouble. Is this true? Any good reason to use A/A mode

Both of my SQL cluster servers got 4 CPUs and they are good enough to handle in either a/a mode or a/p mode
Thanks a lot.

Active/active is to have 2 sql instances running at the same time in a cluster on different nodes.
when the 2 sql instances are running on seperate node, the benefit is all the cluster machine resources are fully used
while with active/passive, 1 node will be idle.
but the disadvantage of Active/active is when one sql instance fails over to the other node, that node has to have enough resource to provide acceptable performance for 2 sql instances running on the same node. If you use Active/active , take this into consideration. This concern can be resolved with failback feature or using better machine for the cluster node

I don't believe Microsoft suggests to use the a/p mode
over the a/a mode or the a/a mode over the a/p mode. Each
is useful for certain scenarios, and neither is
necessarily better than the other.

Check out the whitepaper "Microsoft SQL Server 2000
Failover Clustering"
http://www.microsoft.com/technet/pro...sql/deploy/con
feat/failclus.asp

Also the SQL Resource kit Chapter 12 - Failover Clustering
in SQL Server 2000.
http://www.microsoft.com/technet/pro...sql/reskit/sql
2000/part4/c1261.asp

Linchi

chance to get trouble. Is this true? Any good reason to
use A/A mode?