This article is half-done without your Comment! *** Please share your thoughts via Comment ***
In this post, I am sharing a list of outstanding views to monitor the AlwaysOn Availability Groups of SQL Server 2012.
Please find your useful one and control the AlwaysOn of SQL Server.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 |
SELECT * FROM sys.availability_groups; SELECT * FROM sys.availability_replicas; SELECT * FROM sys.availability_groups_cluster; SELECT * FROM sys.availability_group_listeners; SELECT * FROM sys.availability_group_listener_ip_addresses; SELECT * FROM sys.dm_hadr_availability_replica_cluster_nodes; SELECT * FROM sys.dm_hadr_availability_group_states; SELECT * FROM sys.dm_hadr_availability_replica_cluster_states; SELECT * FROM sys.dm_hadr_availability_replica_states; SELECT * FROM sys.dm_hadr_auto_page_repair; SELECT * FROM sys.dm_hadr_cluster; SELECT * FROM sys.dm_hadr_cluster_members; SELECT * FROM sys.dm_hadr_cluster_networks; SELECT * FROM sys.dm_hadr_database_replica_states; SELECT * FROM sys.dm_hadr_database_replica_cluster_states; SELECT * FROM sys.dm_tcp_listener_states; |
Leave a Reply