Home
  •  

SSIS 2008: Pipeline: Rows Written

Microsoft.SQLServer.2008.SQLServer_SSIS_Pipeline_Rows_Written_15.0_minutes_2_Rule (Rule)

Knowledge Base article:

Summary

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.

External

For more information, see the Book Online topic "Monitoring Performance of the Data Flow Engine."

Element properties:

TargetMicrosoft.SQLServer.2008.IntegrationServices
CategoryPerformanceCollection
EnabledTrue
Instance NameSQLServer:SSIS Pipeline 10.0
Counter NameRows written
Frequency900
Alert GenerateFalse
RemotableTrue
CommentMom2008ID='{88787309-771E-4C50-ABF1-0C7B962BAC00}';MOM2008GroupID={1F778D67-2E2C-4970-B2D1-FED33A1E440B}

Member Modules:

ID Module Type TypeId RunAs 
_26BA0776_C8F2_4D2A_9427_30FD70A9B909_ DataSource System.Performance.DataProvider Microsoft.SQLServer.SQLProbeAccount
CollectPerfData WriteAction Microsoft.SystemCenter.CollectPerformanceData Default
CollectPerfDataWarehouse WriteAction Microsoft.SystemCenter.DataWarehouse.PublishPerformanceData Default

Source Code:

<Rule ID="Microsoft.SQLServer.2008.SQLServer_SSIS_Pipeline_Rows_Written_15.0_minutes_2_Rule" Target="SQL2008Core!Microsoft.SQLServer.2008.IntegrationServices" Enabled="true" ConfirmDelivery="false" Comment="Mom2008ID='{88787309-771E-4C50-ABF1-0C7B962BAC00}';MOM2008GroupID={1F778D67-2E2C-4970-B2D1-FED33A1E440B}">

  <Category>PerformanceCollection</Category>

  <DataSources>

    <DataSource ID="_26BA0776_C8F2_4D2A_9427_30FD70A9B909_" Comment="{26BA0776-C8F2-4D2A-9427-30FD70A9B909}" TypeID="SystemPerf!System.Performance.DataProvider" RunAs="SQL!Microsoft.SQLServer.SQLProbeAccount">

      <ComputerName>$Target/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$</ComputerName>

      <CounterName>Rows written</CounterName>

      <ObjectName>SQLServer:SSIS Pipeline 10.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>