Home
  •  

MSSQL 2016: SSIS 2016 Pipeline: Rows Read

Microsoft.SQLServer.2016.IntegrationServices.PerformanceRule.Instance.PipelineRowsRead (Rule)

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.

Knowledge Base article:

Summary

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.

External

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

Overrideable Parameters

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

Element properties:

TargetMicrosoft.SQLServer.2016.IntegrationServices.Instance
CategoryPerformanceCollection
EnabledTrue
Instance NameSQLServer:SSIS Pipeline 13.0
Counter NameRows read
Frequency900
Alert GenerateFalse
RemotableTrue

Member Modules:

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

Source Code:

<Rule ID="Microsoft.SQLServer.2016.IntegrationServices.PerformanceRule.Instance.PipelineRowsRead" Target="SQL2016IS!Microsoft.SQLServer.2016.IntegrationServices.Instance" Enabled="true" ConfirmDelivery="false">

  <Category>PerformanceCollection</Category>

  <DataSources>

    <DataSource ID="DS" TypeID="SystemPerf!System.Performance.DataProvider" RunAs="GPMP!Microsoft.SQLServer.MonitoringAccount">

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

      <CounterName>Rows read</CounterName>

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