Sample Header Ad - 728x90

How can i get AG dashboard values via SQL Query across all supported versions of SQL server

0 votes
1 answer
423 views
I am trying to ease the monitoring of availability groups across multiple SQL servers. Came across few dmvs which got me the data. But cannot figure out some important columns which i am seeing in SSMS AG Dashboard report. How can i get this data via SQL query. We cannot use PS unfortunately as its blocked to get data remotely Columns in SSMS dashboard which i cannot find in dmv are below. Do we know from where these metrics are getting populated? > Estimate Data Loss (seconds) > > Estimated Recovery Time (seconds) > > Synchronization Performance (seconds) > > Issues: > > Connection state > > Last connection error no:
Asked by Newbie-DBA (804 rep)
Jul 15, 2021, 01:27 AM
Last activity: May 17, 2025, 10:08 AM