SSIS:Profiler:FAQ
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 |