Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select dns_name as AG_Listener ,
- (select top 1 group_name from sys.dm_hadr_availability_replica_cluster_nodes ) as AG_Gorup,
- synchronization_health_desc as AG_Status
- from sys.dm_hadr_availability_replica_states rs
- INNER JOIN sys.availability_group_listeners gl ON rs.group_id = rs.group_id
Add Comment
Please, Sign In to add comment