question

kshaz-7610 avatar image
0 Votes"
kshaz-7610 asked YitzhakKhabinsky-0887 commented

SSIS package takes longer as time passes

SSIS package/job normally takes less than a minute to complete. This job syncs data between our SQL Server and our backend system .
We have noticed that after rebooting the server the job runs in less than a minute, but as time goes on the job takes longer and longer.

after i restart sql server jobs start running less than a minute.

Please advise where should i start looking into.

what could be the potential issue.

sql-server-integration-services
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@kshaz-7610,

Please add to your question SQL Server version for the SSIS run-time server.

 SELECT @@VERSION;
0 Votes 0 ·

1 Answer

ZoeHui-MSFT avatar image
0 Votes"
ZoeHui-MSFT answered

Hi @kshaz-7610,

The issue is a little strange.

You may refer below links to see if it could give you some idea.

  1. SSIS Service performance counter guide

  2. SQL Server Job Performance – Tracking

Regards,

Zoe


If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.