This counter displays the number of rows offered to a destination. The number does not reflect rows written to the destination data store. This counter is polled every fifteen minutes.
This counter displays the number of rows offered to a destination. The number does not reflect rows written to the destination data store. 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.2014.IntegrationServices.Instance |
Category | PerformanceCollection |
Enabled | True |
Instance Name | SQLServer:SSIS Pipeline 12.0 |
Counter Name | Rows written |
Frequency | 900 |
Alert Generate | False |
Remotable | True |
ID | Module Type | TypeId | RunAs |
---|---|---|---|
DS | DataSource | System.Performance.DataProvider | Microsoft.SQLServer.2014.IntegrationServices.RunAs.SQLMonitoringAccount |
CollectPerfData | WriteAction | Microsoft.SystemCenter.CollectPerformanceData | Default |
CollectPerfDataWarehouse | WriteAction | Microsoft.SystemCenter.DataWarehouse.PublishPerformanceData | Default |
<Rule ID="Microsoft.SQLServer.2014.IntegrationServices.PerformanceRule.Instance.PipelineRowsWritten" Target="SQL2014IS!Microsoft.SQLServer.2014.IntegrationServices.Instance" Enabled="true" ConfirmDelivery="false">
<Category>PerformanceCollection</Category>
<DataSources>
<DataSource ID="DS" TypeID="SystemPerf!System.Performance.DataProvider" RunAs="SQL2014IS!Microsoft.SQLServer.2014.IntegrationServices.RunAs.SQLMonitoringAccount">
<ComputerName>$Target/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$</ComputerName>
<CounterName>Rows written</CounterName>
<ObjectName>SQLServer:SSIS Pipeline 12.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>