Wednesday, January 6, 2016

Useful always on AG queries to find status

SELECT * from sys.dm_hadr_auto_page_repair
SELECT * from  sys.dm_hadr_cluster_networks
SELECT * from  sys.dm_hadr_availability_group_states
SELECT * from  sys.dm_hadr_database_replica_cluster_states
SELECT * from  sys.dm_hadr_availability_replica_cluster_nodes
SELECT * from  sys.dm_hadr_database_replica_states
SELECT * from  sys.dm_hadr_availability_replica_cluster_states
SELECT * from  sys.dm_hadr_instance_node_map
SELECT * from  sys.dm_hadr_availability_replica_states
SELECT * from  sys.dm_hadr_name_id_map
SELECT * from  sys.dm_hadr_cluster
SELECT * from  sys.dm_tcp_listener_states
--where type_desc like '%DATABASE_MIRRORING%'
SELECT * from  sys.dm_hadr_cluster_members



SELECT * from  sys.availability_databases_cluster
SELECT * from  sys.availability_groups_cluster
SELECT * from  sys.availability_group_listener_ip_addresses
SELECT * from  sys.availability_read_only_routing_lists
SELECT * from  sys.availability_group_listeners
SELECT * from  sys.availability_replicas
SELECT * from  sys.availability_groups

No comments:

Post a Comment

https://blog.sqlauthority.com/2009/06/27/sql-server-fix-error-17892-logon-failed-for-login-due-to-trigger-execution-changed-database-context...