ReplTip – Measuring Latency in Change Data Capture (CDC)

By Sateesh Yele, Microsoft SQL Escalation Services This DMV sys.dm_cdc_log_scan_sessions is very useful in determining the latency with Change Data Capture (CDC). I inserted one record in the database and started the CDC capture job after around 2 minutes. It showed the latency as 165 seconds. It is difference in seconds, between end_time and last_commit_cdc_time
Read More »