MSSQL AlwaysOn Diagnostics

SSMS

You can tell if a database is a read-only replica in SSMS because it has (Synchronized) appended to the database name in Object Explorer

Quorum Model

To view the quorum model...

SELECT cluster_name,

       quorum_type_desc,

       quorum_state_desc

  FROM sys.dm_hadr_cluster;

To view the node votes...

SELECT member_name,

       number_of_quorum_votes

  FROM sys.dm_hadr_cluster_members;

Bibliography