Monitoring CDC

• SQLSACT

  SSC-Insane

  Points: 21604

  More actions

  July 22, 2020 at 9:21 am

  #3772838

  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

• Site Owners

  SSC Guru

  Points: 80372

  More actions

  July 23, 2020 at 10:10 am

  #3774082

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

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