How to use "track plan execution" for performance optimization in Sagent

UPDATED: March 23, 2017

When track plan execution is selected only the Source and Sink Transforms steps are logged into SARP_TRACK_STEP and SARP_TRACK_TABLE. There are no settings to include other transforms.

For performance optimization, you can use Status Monitor Transform. Using this transform, you can retrieve number of records processed as well as processing time. Also a summary statistics in this transform can provide you with information such as average processing time/average records processed, min/max processing time, etc.

Environment Details

Product Feature: Logging (Sainlge, etc.)
Operating System: Windows 2008 64bit


  • No Downloads