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.
The number of buffers currently written to the disk. If the data flow engine runs low on physical memory, buffers not currently used are written to disk and then reloaded when needed. This counter is polled every fifteen minutes.
For more information, see the Book Online topic "Monitoring Performance of the Data Flow Engine."
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.IS.Windows.LocalInstance |
Category | PerformanceCollection |
Enabled | True |
Instance Name | SQLServer:SSIS Pipeline $Target/Property[Type="Microsoft.SQLServer.IS.Windows.LocalInstance"]/MajorVersion$.0 |
Counter Name | Rows read |
Frequency | 900 |
Alert Generate | False |
Remotable | True |
ID | Module Type | TypeId | RunAs |
---|---|---|---|
DS | DataSource | System.Performance.DataProvider | Microsoft.SQLServer.Core.RunAs.Monitoring |
CollectPerfData | WriteAction | Microsoft.SystemCenter.CollectPerformanceData | Default |
CollectPerfDataWarehouse | WriteAction | Microsoft.SystemCenter.DataWarehouse.PublishPerformanceData | Default |
<Rule ID="Microsoft.SQLServer.IS.Windows.PerformanceRule.PipelineRowsRead" Target="Microsoft.SQLServer.IS.Windows.LocalInstance" Enabled="true" ConfirmDelivery="false">
<Category>PerformanceCollection</Category>
<DataSources>
<DataSource ID="DS" TypeID="SystemPerf!System.Performance.DataProvider" RunAs="SqlCoreLib!Microsoft.SQLServer.Core.RunAs.Monitoring">
<ComputerName>$Target/Property[Type="Microsoft.SQLServer.IS.Windows.LocalInstance"]/NetBiosComputerName$</ComputerName>
<CounterName>Rows read</CounterName>
<ObjectName>SQLServer:SSIS Pipeline $Target/Property[Type="Microsoft.SQLServer.IS.Windows.LocalInstance"]/MajorVersion$.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>