SQLServerAG

Queries to monitor SQL Server Availability Groups (and distributed AGs)

This repo contains a list of useful queries to monitor and diagnose availability groups in SQL Server

Any queries for distributed AGs apply to SQL2016+

These are free to use as-is, or modify them to suit your specific needs.

Name		Name	Last commit message	Last commit date
Latest commit History 4 Commits
1-FindAG.sql		1-FindAG.sql
2-FineCluster.sql		2-FineCluster.sql
3-FindListener.sql		3-FindListener.sql
4-ListReplicas.sql		4-ListReplicas.sql
5-AGReplicaHealth.sql		5-AGReplicaHealth.sql
6-ListLocalAGDatabases.sql		6-ListLocalAGDatabases.sql
7-ListAGDatabaseStatus.sql		7-ListAGDatabaseStatus.sql
8-MeasureAGLatency.sql		8-MeasureAGLatency.sql
9-AGFailovers.sql		9-AGFailovers.sql
README.md		README.md
SQL Server Availability Groups.pptx		SQL Server Availability Groups.pptx

Provide feedback