Home
  •  

SSIS 2012: Pipeline: Buffers Spooled

Microsoft.SQLServer.2012.SQLServer_SSIS_Pipeline_Buffers_Spooled_15.0_minutes_2_Rule (Rule)

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.

Note that all SQL Express editions support only SQL Server Import and Export Wizard, along with Built-in data source connectors.

External

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

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.2012.IntegrationServices
CategoryPerformanceCollection
EnabledTrue
Instance NameSQLServer:SSIS Pipeline 11.0
Counter NameBuffers spooled
Frequency900
Alert GenerateFalse
RemotableTrue
CommentMom2012ID='{6AF47DF1-32E5-4216-BF79-F46349F53A4E}';MOM2012GroupID={1F778D67-2E2C-4970-B2D1-FED33A1E440B}

Member Modules:

ID Module Type TypeId RunAs 
_C6F49224_9358_47DB_A53A_552E8F1D9700_ 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.2012.SQLServer_SSIS_Pipeline_Buffers_Spooled_15.0_minutes_2_Rule" Target="SQL2012Core!Microsoft.SQLServer.2012.IntegrationServices" Enabled="true" ConfirmDelivery="false" Comment="Mom2012ID='{6AF47DF1-32E5-4216-BF79-F46349F53A4E}';MOM2012GroupID={1F778D67-2E2C-4970-B2D1-FED33A1E440B}">

  <Category>PerformanceCollection</Category>

  <DataSources>

    <DataSource ID="_C6F49224_9358_47DB_A53A_552E8F1D9700_" Comment="{C6F49224-9358-47DB-A53A-552E8F1D9700}" TypeID="SystemPerf!System.Performance.DataProvider" RunAs="SQL!Microsoft.SQLServer.SQLProbeAccount">

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

      <CounterName>Buffers spooled</CounterName>

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