CPU Usage by SSIS

Karunakaran

In my quest of writing a generic SSIS package programatically, I have another block. Sad

When I execute the exe seperately it consumes more than half of the CPU, some times its more than 90%. Is there any way where I can say how much of CPU to be used

Thanks & Regards,
Karunakaran

MatthewRoche

Karunakaran wrote:

In my quest of writing a generic SSIS package programatically, I have another block.

When I execute the exe seperately it consumes more than half of the CPU, some times its more than 90%. Is there any way where I can say how much of CPU to be used

Thanks & Regards,
Karunakaran

No. There is no "resource governor" functionality in SSIS.

Karunakaran

Looks like I have no other option.

Thanks

Phil Brammer

Using the CPU is a good thing, generally. That means you're actually using your machine. Now if it's as a result of an I/O or memory problem, then well, that's a whole other story and you should look at hardware solutions.

An idle CPU is a waste, in my opinion.

jwelch

One option for limiting the resources is to set the MaxConcurrentExecutables property of the Package to 1, which limits the runtime to using a single thread. Note that this does not necessarily mean that your CPU utilization will be reduced, but if you are running on a dual core machine, you should see only one of the CPUs maxed out. Also, this will only have an impact if your package is set up so that tasks can be executed in parallel. If everything is linked sequentially, it won't matter.

Karunakaran

My only concern is that I dont want the SSIS package execution to take most of the CPU and bring down other processes. I'm not sure how I can test this scenario in my development box. Probably once I move the application to the TEST environment (which has many other jobs running through a third party scheduler), I'll come to know.

Thanks for the inputs.

Thanks

CPU Usage by SSIS

Re: CPU Usage by SSIS

Re: CPU Usage by SSIS

Re: CPU Usage by SSIS

Re: CPU Usage by SSIS

Re: CPU Usage by SSIS