Beauty, cheers Michael

Pardon my slow reply.

The storage key is used to autenticate the SSIS Azure Components with the Storage Accout. We have files (text files, csv, etc) on these accounts which we...

So I've (sort of) solved this. I'll post my steps in the hopes it saves someone else some expletives.

DBCC Loginfo led me to the status of each VLF being stuck...

Evening All, thanks for youre replies so far.

I dont think my original question was clear.

The AG is configured correctly for it use. People can connect direct to the instance and...

Cheers Guys.

I agree wholeheartedly with Jumpin.

I've yet to work with a DBA that isn't or hasn't been at some point a programmer, network admin, etc. Furthermore, most folks that I've worked...

I edited my original question at the same time you wrote your reply. We must be on the same clock.

I don’t think my edits have messed up your reply.

Thanks! This is a great reply. Ive wondered if those in the system tables were derived from the actual performance counters or were different type only within SQL.

Edit: I am...

• This reply was modified 3 years, 12 months ago by  alex.sqldba. Reason: Refactored for clarity :)

Hmm, looks like it gets compiled to binary and stored in the binary column of SSISDB.internal.object_versions

Annoying! Nevermind.

Ah, yes good point! Cheers Steve!

Ah, looks like sys.sysaltfiles is what I needed.

Quick update on this as I've now resolved it. I was initially confused by the instance name of POWERPIVOT and made an assumption that it was a very specific installed...

Sorry for wasting your time all, turns out this package has never been scheduled! There are very similar named packages in the same project, one letter difference! My eyes glossed...

Execution history is what is missing. Not version history.

Execution history is configured for 90 days, whilst Version history is configured for 3 iterations.

We keep 3 iterations of the project version.

I didn't think you lost the history on deployment but I can't see any reason for this history to have vanished. It's quite...