Advertisement
Guest User

Untitled

a guest
Oct 1st, 2016
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.04 KB | None | 0 0
  1. SELECT ag.name AS ag_name, ars.role_desc, ar.replica_server_name, adc.database_name,
  2. d.log_reuse_wait_desc, drs.database_state_desc, ar.availability_mode_desc, drs.synchronization_state_desc,
  3. drs.synchronization_health_desc, drs.redo_queue_size, ars.connected_state_desc,
  4. ars.operational_state_desc, ars.recovery_health_desc, drs.last_commit_time,
  5. datediff(s,last_hardened_time,getdate()) as 'sec behind primary'
  6. FROM sys.databases d
  7. JOIN sys.dm_hadr_database_replica_states AS drs WITH (NOLOCK) ON d.database_id=drs.database_id
  8. JOIN sys.availability_databases_cluster AS adc WITH (NOLOCK) ON drs.group_id = adc.group_id AND drs.group_database_id = adc.group_database_id
  9. JOIN sys.availability_groups AS ag WITH (NOLOCK) ON ag.group_id = drs.group_id
  10. JOIN sys.availability_replicas AS ar WITH (NOLOCK) ON drs.group_id = ar.group_id AND drs.replica_id = ar.replica_id
  11. JOIN sys.dm_hadr_availability_replica_states ars WITH (NOLOCK) ON ar.replica_id = ars.replica_id
  12. ORDER BY ars.role_desc ASC, ag.name ASC, ar.replica_server_name ASC, adc.database_name ASC;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement