We have an issue when we apply new OS patches and for some reason SSIS catalog jobs fail.

I was researching on it as well. These are some initial steps..let me...

Thanks for the reply. This was SSISDB so not sure why tlog where setup initially. I feel there is no need to apply .trn's as this is not transaction server...

Thanks for sharing.

• This reply was modified 2 years, 9 months ago by  DBA.

It was an error while creating the temp tbl. this is resolved after I removed the [AccountKey] from insert.

Temp tbl improved the performance in my scenario.

How can I check if stats are update to date..is it by going to table ( expand) statistics folder and see properties? or can I use sample below query? if...

I plan on sharing query so that it helps you advise. Thanks

I looked at it again it seems query was the issue. The CTE was selecting DISTINCT values and joining on TABLE A

In the same query we were doing UPDATE TABLE...

A cte query which joins couple of tables and then updates is in suspended state. Is it possible it is blocking itself?

SP who is active shows NULL in the blocking...

• This reply was modified 2 years, 10 months ago by  DBA.