locked
CDC capture job running for long time with waittype 'WAITFOR'. n the background it's running the stored procedure 'sp_MScdc_capture_job Any idea why this is happening. RRS feed

  • Question

  • CDC capture job running for long time with waittype 'WAITFOR'. n the background it's running the stored procedure 'sp_MScdc_capture_job Any idea why this is happening.

    

    Tuesday, March 3, 2020 3:32 AM

All replies

  • Hi DJ_DBA,

    WAITFOR is executed when a scan cycle drains the log completely or when maxscans scan cycles are completed.
    Try to change the parameter of sys.sp_cdc_scan to test.

    More information please refrence:  sys-sp-cdc-scan-transact-sql ,Configuration of sys.sp_cdc_enable_table Parameters



    Best Regards.
    yuxi


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Tuesday, March 3, 2020 10:26 AM
  • Hi DJ_DBA,

    Is the reply helpful?

    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread.

    Best Regards.

    yuxi


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Wednesday, March 4, 2020 8:19 AM
  • Hi DJ_DBA,

    If the reply is helpful for you, thanks for remembering to click "Mark as Answer".

    Best Regards.

    yuxi


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Saturday, March 14, 2020 2:25 AM