SQL job using SSIS package takes a long time to run especially in the evenings
2
votes
1
answer
4553
views
I have a SQL job that runs an SSIS package and it basically pulls records from staging table and dumps it into the master table. It used to take around 8 hrs. to run but in these last 10 days or so the run duration has increased and I would like to know if there is a way I can find out where the job is spending more time and what it is waiting on either running a profiler trace or running a tsql script inside a job to capture anything useful. It runs every day except Sat at 11p est.
Asked by Feivel
(507 rep)
Jul 20, 2017, 05:07 PM
Last activity: Jul 20, 2017, 09:14 PM
Last activity: Jul 20, 2017, 09:14 PM