question

sakuraime avatar image
0 Votes"
sakuraime asked SeeyaXi-msft commented

How to monitor Always-on DAG performance

suppose I have a DAG , for simple AG , we have the dashboard to monitor . But for DAG we don't have a dashboard , how can we monitor the time lag between primary AG and 2nd AG ( suppose 2nd AG is on async mode)
thanks

sql-server-general
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @sakuraime ,

We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

Best regards,
Seeya

0 Votes 0 ·

1 Answer

SeeyaXi-msft avatar image
0 Votes"
SeeyaXi-msft answered SeeyaXi-msft edited

Hi @sakuraime,

You can use dynamic management views to monitor distributed availability groups:
Sys.dm_hadr_availabilty_replica_states
Sys.availabilty_replica
sys.availability_groups
For more information, please refer to this article: https://www.sqlshack.com/monitor-and-failover-a-distributed-sql-server-always-on-availability-group/
And this is a view (DMV) method for measuring synchronization lag: https://www.sqlshack.com/measuring-availability-group-synchronization-lag/

Best regards,
Seeya


If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.