SSIS:Profiler:FAQ

From Melissa Data Wiki
Revision as of 23:31, 23 August 2017 by Admin (talk | contribs) (Created page with "← SSIS:Data Quality Components {{CustomTOC}} ==Service Speed== ;What kinds of speeds/throughput can the Profiler component do? Different...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

← SSIS:Data Quality Components


Service Speed

What kinds of speeds/throughput can the Profiler component do?

Different analysis features directly affect component performance. Options with data aggregation and sort analysis have a high impact on speed of the component.

The following are the average speeds for 1 Thread across different combinations of Actions selected:

Action Enabled if checked
Sort Analysis X X X X X X X X
MatchUp Analysis X X X X X X X X
Rightfielder Analysis X X X X X X X X
Data Aggregation X X X X X X X X
Results (records/min) 105,000 115,000 100,000 46,800 105,000 81,000 280 91,000 47,100 34,000 80,500 1,100 310 33,333 130