locked
How to know the Cluster is active active or Active Passive RRS feed

  • Question

  • Friends 

    A quick and easy Question. I am pretty new to Clustering. How do I know the cluster is whether active active or active passive?

    • Moved by Olaf HelperMVP Friday, November 28, 2014 7:08 PM Moved from "Database Engine" to a more related forum
    Wednesday, October 22, 2014 9:51 PM

Answers

  • There is nothing like Active active(A/A) cluster so you cannot find it.  correct terms for A/A is multi instance cluster so if your cluster has Multiple SQL Server instance it should be Multi instance cluster generally cluster with single instance and two nodes of which one is active and other is passive will be A/P cluster.

    In a multi instance cluster both instances can be on same node. The node on which node resides is owner of the node.


    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My Technet Wiki Article

    MVP

    Wednesday, October 22, 2014 11:03 PM
  • Hi Prasant,

    Simple two-node,  for Active-Passive cluster, only a single SQL Server instance is running. For Active-Active cluster, both SQL Server instances are running on each physical node of the cluster.

    Generally, we can use one of the following options to identify the active node in a SQL Active-Passive Failover Cluster. For more details, please review this blog.
    1. In “Failover Cluster Management” console, you can see the current active node under the label “Current Owner” from summary screen.
    2. Run the following T-SQL in SQL Server Management studio.

    SELECT SERVERPROPERTY('ComputerNamePhysicalNetBIOS')


    There is also a similar thread for your reference.
    https://social.technet.microsoft.com/Forums/en-US/be030e90-f41e-4d42-89e0-ae2a740fbb54/how-to-determine-a-node-is-active-or-passive?forum=sqldisasterrecovery


    Thanks,
    Lydia Zhang



    Thursday, October 23, 2014 10:17 AM

All replies

  • There is nothing like Active active(A/A) cluster so you cannot find it.  correct terms for A/A is multi instance cluster so if your cluster has Multiple SQL Server instance it should be Multi instance cluster generally cluster with single instance and two nodes of which one is active and other is passive will be A/P cluster.

    In a multi instance cluster both instances can be on same node. The node on which node resides is owner of the node.


    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My Technet Wiki Article

    MVP

    Wednesday, October 22, 2014 11:03 PM
  • Hi Prasant,

    Simple two-node,  for Active-Passive cluster, only a single SQL Server instance is running. For Active-Active cluster, both SQL Server instances are running on each physical node of the cluster.

    Generally, we can use one of the following options to identify the active node in a SQL Active-Passive Failover Cluster. For more details, please review this blog.
    1. In “Failover Cluster Management” console, you can see the current active node under the label “Current Owner” from summary screen.
    2. Run the following T-SQL in SQL Server Management studio.

    SELECT SERVERPROPERTY('ComputerNamePhysicalNetBIOS')


    There is also a similar thread for your reference.
    https://social.technet.microsoft.com/Forums/en-US/be030e90-f41e-4d42-89e0-ae2a740fbb54/how-to-determine-a-node-is-active-or-passive?forum=sqldisasterrecovery


    Thanks,
    Lydia Zhang



    Thursday, October 23, 2014 10:17 AM