Andy Brownsword digs into SSISDB:
I’ve recently been reviewing SSIS packages to make some performance fixes and needed a way to validate the results of those changes. I thought I’d share the scripts as they may be useful for others.
Rather than relying on run times from the SQL Agent running the packages I wanted to dive deeper into the packages so took another approach.
Read on for a query that gets the information. You can also eyeball it in the SSIS reports if you have a small or consistent set of packages to run.