SSIS:Profiler:FAQ: Difference between revisions
Jump to navigation
Jump to search
Created page with "← SSIS:Data Quality Components {{CustomTOC}} ==Service Speed== ;What kinds of speeds/throughput can the Profiler component do? Different..." |
No edit summary |
||
| Line 1: | Line 1: | ||
[[SSIS: | [[SSIS:Profiler|← SSIS:Profiler]] | ||
{{CustomTOC}} | {{CustomTOC}} | ||
==Service Speed== | ==Service Speed== | ||
Latest revision as of 23:39, 23 August 2017
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 |