November 3, 2020 at 5:28 pm
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!
Thanks!
November 4, 2020 at 1:50 pm
this may help
https://www.sqlshack.com/measuring-availability-group-synchronization-lag/
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