Monitoring CDC

  • Hi All

    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.

     

    Thanks

  • Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply