I've noticed our CDC capture job causing blocking for hours on end at a time.
Digging around, I've found the latency using this script to reach 1775
SELECT latency FROM sys.dm_cdc_log_scan_sessions WHERE session_id = 0
I'm hoping that someone can assist me with really figuring out how far behind it actually is. How do I determine the actual last CDC commit.
I'm not at all clued up when it comes to CDC.
Any help will be appreciated.