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.
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 written |
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.PipelineRowsWritten" 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 written</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>