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
Last activity: May 17, 2025, 10:08 AM