Availability Group Latency Check


    How can I check if there is latency between primary and secondary on SQL Server 2016. Are there any scripts available?. What in specific you look for in the availability dashboard. For example, I see all the db's in green ( healthy) however found out that we still had 40 secs latency. Do you look at hardened LSN or something like that? please advise any best practices.

    I am aware if could be due to network latency or amount of data or Performance issues. There could be more reasons,  however I want to be able to tell if there is latency even in secs. please let me know your thoughts!


  • this may help


    My company uses SolarWinds DPA to monitor this and send an email alert if the sync lag is larger than 60 seconds.


Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply