The Distributed Availability Group Dashboard can be downloaded from our GitHub repo. https://github.com/SQLUndercover/UndercoverToolbox/blob/master/DAG%20Dashboard.pbix.

This comes off of the back of my last post looking at using a distributed availability group (DAG) to help facilitate a SQL server migration. SQL Server Migration Using a Distributed Availability Group

One thing that I mentioned in that post was that, although SSMS gives us a nice dashboard to check the health of our regular AGs. There’s nothing there to look at the state that the DAGs are in. The only choice that we’ve got is to tap up and compare results from a couple of DMVs on each side.

That’s not the end of the World but I was thinking that it would be nice if there was something that could give us that information at a quick glance.

So for that reason, let me introduce you to the *queue the drum roll*, SQL Undercover Distributed Availability Group Dashboard.

It’s just a quick PowerBI based dashboard that will do the leg work for us and display the results in a nice, easy to view dashboard.

Keep your eyes peeled, I might build a Windows application to replace the PowerBI report at some point.

Setup – Connect the Data Sources to Your AG Listeners

To get it running, you’ll just need to connect a couple of data sources to your AG listeners.

Do to that is very simple, hit the ‘transform data’ button

That’ll take you over to the Transform Data screen. On the left hand side you’ll see three queries listed, the ones that you’re interested in are ‘Primary’ and ‘Secondary’

Clicking on either of those queries will bring up the connection and query details. From there just change “PrimaryAG” or “SecondaryAG” to your appropriate primary or secondary listener name.

Once you’ve done all that, close the window and apply your changes.

From the main report window, just hit refresh to refresh the dashboard.

If you need a quick way to check on the health of your DAGs, I hope you find this useful.