I'm migrating a 2014 SSIS server to 2016. After the upgrade one of the packages we test with is taking around double the amount of time to run on the new server. Around 400 seconds as oppose to 200 seconds.
Something I can see in the profiler traces is an sp_ssis_getpackage call, then a 3 second pause and a exec sp_reset_connection
These are consecutive rows in profiler and it happens around 30 times in the profiler trace. I do not see this behaviour in the old 2014 server.
Is this my smoking gun? Can anyone shed any light on it?