I have CDC running and it seem to be working.... I however, see lag after a large batch inserted and committed. I did count comparison between oracle and SQL server and see the same number different all day. It seem only to catch up in the evening when there are less transaction.

Is there any reason why CDC seem to not processing this batch right away but see to do it when there is less transaction happen in the evening?