Thanks John.

ETL works with SP's

I'll take a look at some of your suggestions

Showing up as CXCONSUMER in solar winds

Yet, I have 12 suspended update CXPACET instances in sys.dm_exec_requests / sys.processes / sys.dm_exec_sql_text

It has a partition (not lots) - used for partition switching once that data has been built

See code:

ALTER TABLE [Load].[CreditAccountHeader] 
ADD CONSTRAINT [PK_CreditAccountHeader] PRIMARY KEY CLUSTERED
 (...

Thanks Chris

I will take a look when I am back in the office

In this instance, it ran once

I don't think parallelism shows up in the plan

If it did though, would...

Yes, I looked at the logging level but there doesn't seem to be one for this

I had a look at executable_statistics but this doesn't seperate out DFT unless we implement...

Thanks Jeffrey

The report does show that information but I can't look at a specific task (or type of task) over time

e.g. evidence of a specific dataflow that's getting slower or...

Thanks for your suggestions

I tried a few and it didn't work although useful to know

I'll also take a look at your Query Store SSRS reports @Audrey

I eventually found a resolution...

Thanks for the response

It's developers edition and AutoClose is set to False

Thanks Sue

I'll take a look

Thanks

Does it store these states anywhere though?

I am using unit tests, specifically negative unit tests (trip the catch part of an SP)

The unit test code has been editted to look...

Thanks Steve

In this instance, the table is truncated before been populated and encrypted so it sounds like it should be fine (I will test though).

It is decrypted fairly soon after

I...

Appreciate I could test this but what if i just changed the line WITH ALGORITHM = TRIPLE_DES to WITH ALGORITHM = AES_128

Or is it not that simple?

Thanks, I'll look at AES as I'd like to move this project into 2016

Thanks Tim

Shame really and, as you say XML edits seems to be a way

Really surprised there isn't an easier option

I think in this instance I'm going to do it manually...

ok, very confusing
Looks like select permission on msdb had been revoked earlier today

Confusing, as up until about 30 minutes ago I was able to execute the T-SQL...