dm_hadr_database_replica_states


Columns

Column Type Size Nulls Auto Default Children Parents Comments
database_id int 4 null
group_id uniqueidentifier 16 null
replica_id uniqueidentifier 16 null
group_database_id uniqueidentifier 16 null
is_local bit 1 √ null
is_primary_replica bit 1 √ null
synchronization_state tinyint 1 √ null
synchronization_state_desc nvarchar 120 √ null
is_commit_participant bit 1 √ null
synchronization_health tinyint 1 √ null
synchronization_health_desc nvarchar 120 √ null
database_state tinyint 1 √ null
database_state_desc nvarchar 120 √ null
is_suspended bit 1 √ null
suspend_reason tinyint 1 √ null
suspend_reason_desc nvarchar 120 √ null
recovery_lsn numeric 27 √ null
truncation_lsn numeric 27 √ null
last_sent_lsn numeric 27 √ null
last_sent_time datetime 16,3 √ null
last_received_lsn numeric 27 √ null
last_received_time datetime 16,3 √ null
last_hardened_lsn numeric 27 √ null
last_hardened_time datetime 16,3 √ null
last_redone_lsn numeric 27 √ null
last_redone_time datetime 16,3 √ null
log_send_queue_size bigint 8 √ null
log_send_rate bigint 8 √ null
redo_queue_size bigint 8 √ null
redo_rate bigint 8 √ null
filestream_send_rate bigint 8 √ null
end_of_log_lsn numeric 27 √ null
last_commit_lsn numeric 27 √ null
last_commit_time datetime 16,3 √ null
low_water_mark_for_ghosts bigint 8 √ null
secondary_lag_seconds bigint 8 √ null
quorum_commit_lsn numeric 27 √ null
quorum_commit_time datetime 16,3 √ null

Relationships

Close relationships within degrees of separation