November 16, 2016 at 3:50 pm
We have recently built a couple of CDC SSIS solutions to load our Warehouse using parallel processing of the various packages. One major issue we have recently come up against is deadlocks on the cdc_states table.
It turns out that this is a result of the SSIS CDC Control Task using a Select * to read in the cdc_states values and hence locking the entire table instead of just the single row required. This means every once in a while we get a deadlock which we currently have to manually fix.
Has anyone come up against this problem and resolved it without having to run all of their packages sequentially? Any ideas gratefully received.
May 15, 2018 at 10:08 am
This happened to us last night, and was curious if you found any solution to this? We also do not want to run all of our packages sequentially as we would expect to take a severe run time hit by doing so.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply