http://wiki.melissadata.com/index.php?action=history&feed=atom&title=SSIS%3AProfiler%3AFAQ
SSIS:Profiler:FAQ - Revision history
2026-05-03T01:09:31Z
Revision history for this page on the wiki
MediaWiki 1.43.1
http://wiki.melissadata.com/index.php?title=SSIS:Profiler:FAQ&diff=13255&oldid=prev
Admin at 23:39, 23 August 2017
2017-08-23T23:39:43Z
<p></p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 23:39, 23 August 2017</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1">Line 1:</td>
<td colspan="2" class="diff-lineno">Line 1:</td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>[[SSIS:<del style="font-weight: bold; text-decoration: none;">Data Quality Components</del>|&larr; SSIS:<del style="font-weight: bold; text-decoration: none;">Data Quality Components</del>]]</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>[[SSIS:<ins style="font-weight: bold; text-decoration: none;">Profiler</ins>|&larr; SSIS:<ins style="font-weight: bold; text-decoration: none;">Profiler</ins>]]</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>{{CustomTOC}}</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>{{CustomTOC}}</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>==Service Speed==</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>==Service Speed==</div></td></tr>
</table>
Admin
http://wiki.melissadata.com/index.php?title=SSIS:Profiler:FAQ&diff=13252&oldid=prev
Admin: Created page with "← SSIS:Data Quality Components {{CustomTOC}} ==Service Speed== ;What kinds of speeds/throughput can the Profiler component do? Different..."
2017-08-23T23:31:56Z
<p>Created page with "<a href="/index.php?title=SSIS:Data_Quality_Components" title="SSIS:Data Quality Components">← SSIS:Data Quality Components</a> {{CustomTOC}} ==Service Speed== ;What kinds of speeds/throughput can the Profiler component do? Different..."</p>
<p><b>New page</b></p><div>[[SSIS:Data Quality Components|&larr; SSIS:Data Quality Components]]<br />
{{CustomTOC}}<br />
==Service Speed==<br />
;What kinds of speeds/throughput can the Profiler component do?<br />
<br />
Different analysis features directly affect component performance. Options with data aggregation and sort analysis have a high impact on speed of the component.<br />
<br />
The following are the average speeds for 1 Thread across different combinations of Actions selected:<br />
<br />
{|class="alternate01" cellspacing="0"<br />
!Action!!colspan="15"|Enabled if checked<br />
|-<br />
|Sort Analysis||style="text-align:center;"|X|| || || ||style="text-align:center;"|X||style="text-align:center;"|X||style="text-align:center;"|X|| || || ||style="text-align:center;"|X||style="text-align:center;"|X||style="text-align:center;"|X|| ||style="text-align:center;"|X<br />
|-<br />
|MatchUp Analysis|| ||style="text-align:center;"|X|| || ||style="text-align:center;"|X|| || ||style="text-align:center;"|X||style="text-align:center;"|X|| ||style="text-align:center;"|X||style="text-align:center;"|X|| ||style="text-align:center;"|X||style="text-align:center;"|X<br />
|-<br />
|Rightfielder Analysis|| || ||style="text-align:center;"|X|| || ||style="text-align:center;"|X|| ||style="text-align:center;"|X|| ||style="text-align:center;"|X||style="text-align:center;"|X|| ||style="text-align:center;"|X||style="text-align:center;"|X||style="text-align:center;"|X<br />
|-<br />
|Data Aggregation|| || || ||style="text-align:center;"|X|| || ||style="text-align:center;"|X|| ||style="text-align:center;"|X||style="text-align:center;"|X|| ||style="text-align:center;"|X||style="text-align:center;"|X||style="text-align:center;"|X||style="text-align:center;"|X<br />
|-<br />
|Results (records/min)||105,000||115,000||100,000||46,800||105,000||81,000||style="background-color:Pink;"|280||91,000||47,100||34,000||80,500||style="background-color:Pink;"|1,100||style="background-color:Pink;"|310||33,333||style="background-color:Pink;"|130<br />
|}<br />
<br />
<br />
[[Category:FAQ]]<br />
[[Category:Profiler]]</div>
Admin