Hi Mark,

My client has started to run into timeout / locking problems when his scheduled SSIS packages are executed. There were no problems before migrating to the SSIS catalog in...

Yup - no luck with that one either 🙁

Hi Chris,

Thanks for your suggestion, but unfortunately, adding ivTo to the clustered index, does not alter the execution plan or the performance at all. I also tried creating a separate...

Thanks a lot for the responses so far, everyone.

Using EXISTS does unfortunately not improve the performance. The execution time still exceeds my 10 minute patience limit, and the wait type...

Here you go. Thanks a lot for looking into this 🙂

SELECT * FROM master.dbo.sysprocesses WHERE spid = 54

spid kpid blocked waittype waittime ...

The differences are consistent. Query A never completes within the 10 minutes my patience lasts, while Query B always executes in about 3 seconds.

Estimated execution plan for Query A:

---

Execution plan...