This counter indicates the number of rows that a source produces. The number does not include rows read from reference tables by the Lookup transformation. This counter is polled every fifteen minutes.
Note that all SQL Express editions support only SQL Server Import and Export Wizard, along with Built-in data source connectors.
For more information, see “Monitoring Performance of the Data Flow Engine” Book Online topic.
Name | Description | Default Value |
Enabled | Enables or disables the workflow. | Yes |
Frequency (seconds) | The recurring interval of time in seconds in which to run the workflow. | 900 |
Target | Microsoft.SQLServer.2012.IntegrationServices |
Category | PerformanceCollection |
Enabled | True |
Instance Name | SQLServer:SSIS Pipeline 11.0 |
Counter Name | Rows read |
Frequency | 900 |
Alert Generate | False |
Remotable | True |
Comment | Mom2012ID='{593A7F7E-3AAA-4705-8BB0-352C394569B8}';MOM2012GroupID={1F778D67-2E2C-4970-B2D1-FED33A1E440B} |
ID | Module Type | TypeId | RunAs |
---|---|---|---|
_88D6ADD1_FD12_4CB1_AE07_D14F4CB57D17_ | DataSource | System.Performance.DataProvider | Microsoft.SQLServer.SQLProbeAccount |
CollectPerfData | WriteAction | Microsoft.SystemCenter.CollectPerformanceData | Default |
CollectPerfDataWarehouse | WriteAction | Microsoft.SystemCenter.DataWarehouse.PublishPerformanceData | Default |
<Rule ID="Microsoft.SQLServer.2012.SQLServer_SSIS_Pipeline_Rows_Read_15.0_minutes_2_Rule" Target="SQL2012Core!Microsoft.SQLServer.2012.IntegrationServices" Enabled="true" ConfirmDelivery="false" Comment="Mom2012ID='{593A7F7E-3AAA-4705-8BB0-352C394569B8}';MOM2012GroupID={1F778D67-2E2C-4970-B2D1-FED33A1E440B}">
<Category>PerformanceCollection</Category>
<DataSources>
<DataSource ID="_88D6ADD1_FD12_4CB1_AE07_D14F4CB57D17_" Comment="{88D6ADD1-FD12-4CB1-AE07-D14F4CB57D17}" TypeID="SystemPerf!System.Performance.DataProvider" RunAs="SQL!Microsoft.SQLServer.SQLProbeAccount">
<ComputerName>$Target/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$</ComputerName>
<CounterName>Rows read</CounterName>
<ObjectName>SQLServer:SSIS Pipeline 11.0</ObjectName>
<Frequency>900</Frequency>
</DataSource>
</DataSources>
<WriteActions>
<WriteAction ID="CollectPerfData" TypeID="SC!Microsoft.SystemCenter.CollectPerformanceData"/>
<WriteAction ID="CollectPerfDataWarehouse" TypeID="SCDW!Microsoft.SystemCenter.DataWarehouse.PublishPerformanceData"/>
</WriteActions>
</Rule>