0

I have 20 ssis packages deployed on SQLSvr1 in the SSIS catalog.

They are invoked via the SQL agent jobs on this server.

Suppose I re-create these agent jobs on another SQL Server (SQLSvr2), then will they on the hardware resources of SQLSvr2 (CPU, memory)?

1 Answer 1

0

The packages are going to execute and consume resources on whichever server they live on, which in this case would be SQLSvr1.

Also, SQL Agent Jobs just execute the steps inside them local to the server they're on (unless the step references a Linked Server, etc). So the Agent Jobs probably would fail on SQLSvr2 if you tried running them without deploying your SSIS packages to SQLSvr2. The SSIS component of SQL Server would need to be installed and enabled on SQLSvr2 as well.

5
  • Even assuming SSIS component is installed on Svr2, and the agent job on Svr2 calls packages located on Svr1, then am I correct that the packages will run only Svr1?
    – variable
    May 10 at 14:11
  • @variable Correct.
    – J.D.
    May 10 at 15:02
  • I'm so surprised as to why the SSIS buffer memory perf mon counter is recording 0! What do you recommend I do to check this?
    – variable
    May 10 at 15:14
  • @variable Wrong post, you asked about that in a different question. Unfortunately I don't much about PerfMon, haven't used it in years, and IMO it's not the best way to monitor stuff.
    – J.D.
    May 10 at 18:05
  • I cannot see dtexec process in my task manager, yet I can see multiple ssis packages are executed as evident on the servers ssis execution report. What am I missing?
    – variable
    May 12 at 12:42

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.