Post reply

CDC capture job waiting for worker thread

  • August 1, 2017 at 9:56 am

    #339145

    I have enabled CDC in a database and the capture job and clean up jobs are created but the state is in waiting for maximum worker thread. I think this is causing all the changes not being captured. How do I fix this thanks

    SQL server 2012

  • August 1, 2017 at 11:51 am

    #1953645

    how are you determining that CDC is not capturing changes?
    CDC reads the log asynchronously, but it reads the log, so it cannot really miss any changes, right?
    are you seeing a delay betwen an update and CDC's history tables?

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • August 4, 2017 at 3:34 pm

    #1954204

    Lowell - Tuesday, August 1, 2017 11:51 AM

    how are you determining that CDC is not capturing changes?
    CDC reads the log asynchronously, but it reads the log, so it cannot really miss any changes, right?
    are you seeing a delay betwen an update and CDC's history tables?

    This is resolved by expanding the max_worker_threads in the msdb.dbo.subsystems table  for  subsystem TSQL .

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

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