Super Cat - Monday, December 18, 2017 6:36 AM
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.