You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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.
The text was updated successfully, but these errors were encountered:
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.
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.
The text was updated successfully, but these errors were encountered: