Database Reference
In-Depth Information
Finding the target bottleneck
Always consider checking the bottlenecks at the target side first. There can be various reas-
ons for bottlenecks in the target. First, we need to learn to find the target bottleneck.
Using thread statistics
Thread statistics are a part of the session log. When you run the workflow, the session log
also generates the thread statistics that can provide you with information about the bottle-
necks present in the source, target, or transformations. Thread statistics give you informa-
tion about the total runtime, idle time, and busy percentage of the source, target, and trans-
formations.
Thread statistics consist of the Reader thread, Writer thread, and Transformation thread.
The Reader thread gives you information related to the total runtime, idle time, and busy
percentage of the sources in the mapping. The Writer thread gives you information about
the total runtime, idle time, and busy percentage of targets in the mapping. Similarly, the
Transformation thread gives you information related to transformations in the mapping, as
indicated in the following sample thread statistics:
***** RUN INFO FOR TGT LOAD ORDER GROUP [1] *****
Thread [ READER_1_1_1 ] created for [ the read stage ] of
partition point [ SQ_EMPLOYEES ] has completed.
Total Run Time = [ 100.11 ] Secs
Total Idle Time = [ 90.101 ] Secs
Busy Percentage = [ 10.888141628 ]
Thread [ TRANSFORMATION_1_1_1 ] created for [ the
transformation stage ] of partition point [ SQ_EMPLOYEES ]
has completed.
Total Run Time = [ 123.11 ] Secs
Total Idle Time = [ 100.23 ] Secs
Busy Percentage = [ 18.585005278 ]
Thread [ WRITER_1_1_1 ] created for [ the target stage ] of
partition point [ TGT_EMPLOYEES ] has completed.
Total Run Time = [ 130.11 ] Secs
Total Idle Time = [ 1.23 ] Secs
Busy Percentage = [ 99.054646069 ]
