VERIFIED SOLUTION i
X

Performance Tuning of Sagent plan.

UPDATED: March 31, 2017


While analysing the performance of a plan, sometimes recommended to split and tuning of the plans. 

During this analysis, you can look for three ‘S’.

Sources
  • Use a terminal sink to look at source transform performance.
  • Use multiple source transforms to read data in parts.
  • Disabling date format checking in many transforms can enhance performance.
  • Avoid string to number conversion as much as possible in the flow.
Sinks
  • Use batch loaders where appropriate.
  • Parallelize the sinks wherever possible using the round robin splitter
Sorts
  • Try and push sorts back to the source wherever possible.
  • Use the “Data is Presorted” feature to override Sagent disk sorts.

Environment Details

Product Feature: Performance Tuning.

Downloads

  • No Downloads