Home
  •  

MSSQL Integration Services on Windows: Integration Services Rows Read

Microsoft.SQLServer.IS.Windows.PerformanceRule.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

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.

External

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

Overridable 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.IS.Windows.LocalInstance
CategoryPerformanceCollection
EnabledTrue
Instance NameSQLServer:SSIS Pipeline $Target/Property[Type="Microsoft.SQLServer.IS.Windows.LocalInstance"]/MajorVersion$.0
Counter NameRows read
Frequency900
Alert GenerateFalse
RemotableTrue

Member Modules:

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

Source Code:

<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>