question

Mohan Kumar avatar image
Mohan Kumar asked

CDC - Delay in insert

Hi I'm using CDC for a table dbo.tblProducts. I had noticed that the CDC table `cdc_dbo_tblProduct_CT` is updated slowly. For example, if I insert a record in `tblProducts`, immediately it is not affected in the `cdc_dbo_tblProduct_CT` table. After 1 or two seconds delay only I could see the changes. Kindly suggest remedy steps. Regards Mohan Kumar
sql-server-2008change-data-capture
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Usman Butt avatar image
Usman Butt answered
It is pretty normal. The job for capturing the data change process a maximum of 1000 transactions per scan cycle with a wait of 5 seconds between cycles in default configuration.
3 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Mohan Kumar avatar image Mohan Kumar commented ·
Thanks.... Is there any possibility to reduce the wait time?
0 Likes 0 ·
Usman Butt avatar image Usman Butt commented ·
sys.sp_cdc_change_job is the procedure that can be used to modify the configuration of a change data capture cleanup or capture job. But why you want the time interval to be reduced? If losing the data change is your concern, the the chances are minimal. More often than not, people wanted to increase the polling interval, so that the load of log scanning is reduced.
0 Likes 0 ·
Mohan Kumar avatar image Mohan Kumar commented ·
Thanks... It is required for an internal purpose...
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.