Home Forums SQL Server 2016 SQL Server 2016 - Administration FCI + Always On RE: FCI + Always On

  • December 18, 2017 at 9:38 am

    #1972542

    Super Cat - Monday, December 18, 2017 6:36 AM

    select * from sys.dm_hadr_availability_replica_cluster_states

    I would expect to see Joined_FCI  for NODE A and B in column Join State Desc
    and 
    Joined_STANDALONE for NODE C

    select * from sys.dm_tcp_listener_states

    Does the Dashboard show any errors.?

    select * from sys.dm_hadr_availability_replica_cluster_states

    28C14CED-0282-44B1-8111-12D10A53E5C4    CLSQL2K16REP\AONCLSPRO    8E3CAF1B-AFC7-444F-B76C-A76EFA37D11E    1    JOINED_STANDALONE
    D650F444-FF2A-4070-A9D1-2C3A52191644    CLSQL2K16S2\PROINTERNA    8E3CAF1B-AFC7-444F-B76C-A76EFA37D11E    2    JOINED_FCI

    select * from sys.dm_tcp_listener_states (I have another AG with another listener)

    6    ::    0    5022    2    DATABASE_MIRRORING    0    ONLINE    2017-12-14 10:19:50.807
    7    0.0.0.0    1    5022    2    DATABASE_MIRRORING    0    ONLINE    2017-12-14 10:19:50.807
    3    ::1    0    53433    0    TSQL    0    ONLINE    2017-12-14 10:19:50.020
    4    127.0.0.1    1    53433    0    TSQL    0    ONLINE    2017-12-14 10:19:50.020
    1    ::    0    53432    0    TSQL    0    ONLINE    2017-12-14 10:19:50.013
    2    0.0.0.0    1    53432    0    TSQL    0    ONLINE    2017-12-14 10:19:50.017

    Dashboard says:
    This secondary replica is not connected to the primary replica. The connected state is DISCONNECTED.