AGLatency report tool V2.2 introduction
Published Jan 15 2019 06:04 PM 4,683 Views
Microsoft
First published on MSDN on Sep 08, 2018
I wrote an article to discuss about data movement latency between AG groups:

https://blogs.msdn.microsoft.com/psssql/2018/04/05/troubleshooting-data-movement-latency-between-syn...

Now I develop a tool to analyze AG log block movement latency between replicas and create report accordingly (this tool has been updated to Version 2.0).



You can download it here: https://github.com/suyouquan/AGLatency/releases/download/v2.2/AGLatencyV2.2.zip



Video:https://github.com/suyouquan/AGLatency/blob/master/AGLatency_HowTo.mp4

User Manual: https://github.com/suyouquan/AGLatency/blob/master/AGLatencyTool_UserManual_V2.pdf

You capture log block Xevent trace from both primary and secondary replica for 5-10 minutes and then this tool will generate report about the latency of the log block movement.





Regards,
Simon
Version history
Last update:
‎Jan 15 2019 06:04 PM
Updated by: