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

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 1
0:00 - High-level transactional replication architecture
2:19 - Troubleshooting steps introduction
2:50 - Step 1: Get information about "Big picture"
3:23 - Step 2: Define the latency location with tracer tokens
4:28 - Step 3: Check latency in Log reader agent
10:37 - Step 4: Check latency in Distribution agent

Part 2 (next session)
Troubleshooting steps in Part 2
Step 4.1: Check latency in Log Reader agent's reader thread
Step 4.2: Check latency in Log Reader agent's writer thread
Step 4.3: Check latency in Distribution agent's reader thread
Step 4.3: Check latency in Distribution agent's writer thread

🚀►Part 2:    • [Detailed/Advanced] Effectively troub...  
🚀►Github for queries: https://github.com/Bobirmirzo/replica...
🚀►URLs used in this session:
https://github.com/sqlserver-parikh/S...
📚 ►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