search

trimble-oss / dba-dash

DBA Dash - SQL Server Monitoring Tool
MIT License
265 stars 63 forks source link

Availability Groups - Historical Failover Data #860

Open thedwindlingdba opened 6 months ago

thedwindlingdba commented 6 months ago

Hi

I was wondering. I know DBA-Dash collects many data points that aren't necessarily available in the GUI, and I love some of the correlation capabilities. Recently, an issue has come up where I need to be able to plot out the dates and times Availability Group failovers have occurred, preferably for the last month, and then correlation those data points with other pieces of information like Running jobs at the time of the failover, Latency at the time of failover, etc.,

In their TigerTool box repo, Microsoft's Tiger Team has a failover power BI dashboard that uses the SQLDIAG extended event. I was wondering if it would be possible to pull that type of data using DBA-Dash or if I could pull the above data points. Time of Failover, Running Jobs At the Time of Failover, IO stats at the time of failover, and currently executing queries from already existing data with the database.

I know you track AG info but I cannot find out when a failover occurred and without that data point, it makes all other data points difficult to ascertain.

DavidWiseman commented 6 months ago

Hi,

Thanks for the suggestion. There isn't a history tracked in DBA Dash for availability group failovers. I'm not looking to include this at the moment but I might consider it in the future.

You might be able to use the custom collections and custom reports features to capture this information.

Hope this helps,

David