How to find the cluster that an AG database sits on

This explains how to find the name of the cluster that a SQL AG db sits on. This is always confusing because you need to sift through virtual names in Windows and SQL so I'm noting down for future reference:

  1. Go to Microsoft SQL Server > SQL Server Database Engines > Always On High Availability > Database Replicas
  2. Search for the db. You will get duplicates because that's how AG dbs work, there's multiple copies! 
  3. Select any db. Down below copy the Availability Group Name value. Note you can also get the SQL instance name from the Primary Replica field
  4. Go up to Availability Groups and search for the AG name
  5. Select the AG name. Down below, copy the Cluster Name value
  6. Go to Microsoft Windows Cluster > Cluster Service State and search for the cluster name
Done. This is the cluster the AG db sits on. You can also can see the cluster nodes.

Comments