AGLatency report tool V2.2 introduction

Published Jan 15 2019 06:04 PM 2,482 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
%3CLINGO-SUB%20id%3D%22lingo-sub-319186%22%20slang%3D%22en-US%22%3EAGLatency%20report%20tool%20V2.2%20introduction%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-319186%22%20slang%3D%22en-US%22%3E%0A%20%26lt%3Bmeta%20http-equiv%3D%22Content-Type%22%20content%3D%22text%2Fhtml%3B%20charset%3DUTF-8%22%20%2F%26gt%3B%3CSTRONG%3EFirst%20published%20on%20MSDN%20on%20Sep%2008%2C%202018%20%3C%2FSTRONG%3E%20%3CBR%20%2F%3E%20I%20wrote%20an%20article%20to%20discuss%20about%20data%20movement%20latency%20between%20AG%20groups%3A%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%3CA%20href%3D%22https%3A%2F%2Fblogs.msdn.microsoft.com%2Fpsssql%2F2018%2F04%2F05%2Ftroubleshooting-data-movement-latency-between-synchronous-commit-always-on-availability-groups%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fblogs.msdn.microsoft.com%2Fpsssql%2F2018%2F04%2F05%2Ftroubleshooting-data-movement-latency-between-synchronous-commit-always-on-availability-groups%2F%3C%2FA%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20Now%20I%20develop%20a%20tool%20to%20analyze%20AG%20log%20block%20movement%20latency%20between%20replicas%20and%20create%20report%20accordingly%20(this%20tool%20has%20been%20updated%20to%20Version%202.0).%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F68736i5A3535FFF45AF450%22%20%2F%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20You%20can%20download%20it%20here%3A%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fsuyouquan%2FAGLatency%2Freleases%2Fdownload%2FV2.2%2FAGLatencyV2.2.zip%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%20https%3A%2F%2Fgithub.com%2Fsuyouquan%2FAGLatency%2Freleases%2Fdownload%2Fv2.2%2FAGLatencyV2.2.zip%20%3C%2FA%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20Video%3A%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fsuyouquan%2FAGLatency%2Fblob%2Fmaster%2FAGLatency_HowTo.mp4%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fgithub.com%2Fsuyouquan%2FAGLatency%2Fblob%2Fmaster%2FAGLatency_HowTo.mp4%3C%2FA%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20User%20Manual%3A%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fsuyouquan%2FAGLatency%2Fblob%2Fmaster%2FAGLatencyTool_UserManual_V2.pdf%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%20https%3A%2F%2Fgithub.com%2Fsuyouquan%2FAGLatency%2Fblob%2Fmaster%2FAGLatencyTool_UserManual_V2.pdf%20%3C%2FA%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20You%20capture%20log%20block%20Xevent%20trace%20from%20both%20primary%20and%20secondary%20replica%20for%205-10%20minutes%20and%20then%20this%20tool%20will%20generate%20report%20about%20the%20latency%20of%20the%20log%20block%20movement.%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F68737i5FE482153934257B%22%20%2F%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20Regards%2C%20%3CBR%20%2F%3E%20Simon%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-319186%22%20slang%3D%22en-US%22%3EFirst%20published%20on%20MSDN%20on%20Sep%2008%2C%202018%20I%20wrote%20an%20article%20to%20discuss%20about%20data%20movement%20latency%20between%20AG%20groups%3Ahttps%3A%2F%2Fblogs.%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-319186%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EHigh%20Availability%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EUtilities%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Version history
Last update:
‎Jan 15 2019 06:04 PM
Updated by: