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.
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 |
| Yes |
Frequency | The recurring interval of time in seconds in which to run the workflow. | 900 |
Generates Alerts |
| No |
Target | Microsoft.SQLServer.2014.IntegrationServices.Instance |
Category | PerformanceCollection |
Enabled | True |
Instance Name | SQLServer:SSIS Pipeline 12.0 |
Counter Name | Buffers spooled |
Frequency | 900 |
Alert Generate | False |
Remotable | True |
ID | Module Type | TypeId | RunAs |
---|---|---|---|
DS | DataSource | System.Performance.DataProvider | Microsoft.SQLServer.2014.IntegrationServices.RunAs.SQLMonitoringAccount |
CollectPerfData | WriteAction | Microsoft.SystemCenter.CollectPerformanceData | Default |
CollectPerfDataWarehouse | WriteAction | Microsoft.SystemCenter.DataWarehouse.PublishPerformanceData | Default |
<Rule ID="Microsoft.SQLServer.2014.IntegrationServices.PerformanceRule.Instance.PipelineBuffersSpooled" Target="SQL2014IS!Microsoft.SQLServer.2014.IntegrationServices.Instance" Enabled="true" ConfirmDelivery="false">
<Category>PerformanceCollection</Category>
<DataSources>
<DataSource ID="DS" TypeID="SystemPerf!System.Performance.DataProvider" RunAs="SQL2014IS!Microsoft.SQLServer.2014.IntegrationServices.RunAs.SQLMonitoringAccount">
<ComputerName>$Target/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$</ComputerName>
<CounterName>Buffers spooled</CounterName>
<ObjectName>SQLServer:SSIS Pipeline 12.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>