CPU Utilization

[Minas Papageorgiou]

I have an SSIS 2008 package that takes ~1.5h to run
on a 2 x Quad core Opteron server with 16Gb ram.

The issue is whether there are some settings so that SSIS
takes better advantage of the CPUs since the current utilization is always
less tan 30%, while most of the data reside on the memory (disk usage is low)

[Todd C]

Hello,

Have you identified what element in the package is causing a possible
bottleneck? Maybe insufficient indexes on the source, or something else?

You might look inside an individual package at any of the Data Flow
elements. Look for the following properties:
*DefaultBufferMaxRows
*DefaultBufferSize
*EngineThreads

I suggest you read BOL for how each of these might affect package
performance. I also suggest that, should you decide to tweak them, you only
touch one at a time and test it through several package cycles under
identical conditions.

Keep us posted. I have never messed with those properties and am curious to
know what they might do for you.

HTH
=====
Todd C

Post by Minas Papageorgiou
I have an SSIS 2008 package that takes ~1.5h to run
on a 2 x Quad core Opteron server with 16Gb ram.
The issue is whether there are some settings so that SSIS
takes better advantage of the CPUs since the current utilization is always
less tan 30%, while most of the data reside on the memory (disk usage is low)