Job hanging at CDC stage
Posted: Fri Dec 07, 2012 11:17 am
Hi all,
I have a job that uses the CDC stage to check if the source records are insert, update or copy records. I am looking up to the target table that has about 6.8 million records. In the current run of the job, only one record is looking up to the 6.8 million. For some reason, it has been taking almost 2 hours and the job is hung at the CDC stage. How can I speed this job up?
I have sorted and partitioned on the change keys on both inputs but still no luck. Any tips?
Thanks in advance.
I have a job that uses the CDC stage to check if the source records are insert, update or copy records. I am looking up to the target table that has about 6.8 million records. In the current run of the job, only one record is looking up to the 6.8 million. For some reason, it has been taking almost 2 hours and the job is hung at the CDC stage. How can I speed this job up?
I have sorted and partitioned on the change keys on both inputs but still no luck. Any tips?
Thanks in advance.