[Detailed/Advanced] Effectively troubleshoot SQL Server transactional replication latency (Part 2)

In this session, I will share how to troubleshoot SQL Server transactional replication latency issues. This is very much detailed troubleshooting session. If you are facing latency in your replication and do not know how to resolve, you can always rely on this session steps.

Agenda
Part 2
0:00 - Troubleshooting steps in Part 2
0:48 - Step 4.1: Check latency in Log Reader agent's reader thread
6:05 - Step 4.2: Check latency in Log Reader agent's writer thread
8:45 - Step 4.3: Check latency in Distribution agent's reader thread
11:00 - Step 4.3: Check latency in Distribution agent's writer thread

🚀►Part 1:    • [Detailed/Advanced] Effectively troub...  
🚀►Github for queries:
https://github.com/Bobirmirzo/replica...
📚 ►Full course on Troubleshooting sessions:    • Troubleshooting  
📷 ►Follow me on Instagram - https://www.instagram.com/arslanov_bo...
🧑‍💼►Follow me on LinkedIn -   / bobirmirzo-arslanov-548960173  

Watch all my playlists here:
🚀►Full course on Encrypting connections to SQL Server-    • Full course on Encrypting connections...  
🚀 ►SQL Server replication session:    • SQL Server replication  
🚀 ►SQL Server Always On Availability Group:    • SQL Server Always On Availability Gro...  
🚀 ► SQL Server internals:    • SQL Internals  
🚀 ► Course in On-memory OLTP:    • Course on In-Memory OLTP