[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

🚀►URLs used in this session:

Watch all my playlists here: