SQL Server Performance

How do I check the Cluster Configuration: Active/Active or Active/Passive?

Discussion in 'SQL Server Clustering' started by Trev256, Feb 19, 2008.

  1. Trev256 New Member

    1) How do I check the Cluster Configuration: Active/Active or Active/Passive - without trying to failover databases and running them - is this information stored as a property on in the registry somewhere?
    2) Also I have noticed someone has created 2 servers or instances named 'DBA' and 'DBARREPORTS' - is this just 2 instances? I'm not sure but can they create a named instance with a slightly different virtual server name - such as DBAR and not DBA???
    Thanks
  2. MohammedU New Member

    In cluster you should have different virtual names for two instances...
    In your case it is active/active, you check Service Management where you can see two SQL instances.
    Now it not called active/active or active/passive anymore...it is called single/mulit node cluster....

Share This Page