Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

...

As of version 3.1.0 of Pentaho Data Integration, we are introducing a way to track the performance of individual steps in a transformation.  This is an important tool that allows you to fine-tune performance of transformation because that performance is determined by the slowest step in the transformation.

A check list for PDI performance tuning can be found here.

Enabling monitoring

You can enable the step performance monitoring in the transformation settings dialog:

...

 As you can see, this option is NOT enabled by default as it may cause memory consumption problems for long running transformations.  By default, every second a performance snapshot is taken for all the running steps.  This is not a CPU intensive operation and it should not have any big impact on performance.  However, if you have a lot of steps or if you take a lot of snapshots (several per second for example), there is obviously going to be some negative impact on performance that you should be aware off.

Also be aware that if you run in Spoon you will consume a fair amount of CPU power just by updating the JFreeChart graphics in the performance tab.  Running headless (Kitchen, Pan, Carte, Pentaho platform, ...) does not have that drawback and should give you fairly accurate performance numbers without too much of a penalty (if any at all).

Saving step performance logging

...