SQLDBA-How to identify indvidual SQL statements with in a batch or store procedure.
DBA - Check health and status of Always On or Availability Group using DMVs
-- Health and status of WSFC cluster. These two queries work only if the WSFC has quorum SELECT * FROM sys.dm_hadr_cluster SELECT * FROM sys.dm_hadr_cluster_members -- Health of the AGs SELECT ag.name agname, ags.* FROM sys.dm_hadr_availability_group_states ags INNER JOIN sys.availability_groups ag ON ag.group_id = ags.group_id -- Health and status of AG replics from the WsFC perspective SELECT ar.replica_server_name,harc.* FROM sys.dm_hadr_availability_replica_cluster_states harc INNER JOIN sys.availability_replicas ar ON ar.replica_id = harc.replica_id -- Health and status of AG replicas, run this on the primary replica. -- On secondary this will only show info for that instance SELECT * FROM sys.dm_hadr_availability_replica_states -- Health and status of AG databases from the WSFC perspective SELECT * FROM sys.dm_hadr_database_replica_cluster_states -- Health and status of AG databases, run this on the primary replica. -- On secondary this wi...
Comments
Post a Comment