The Buffers Spooled counter is important because it is a good indicator of when your machine runs out of physical memory or runs out of virtual memory during data flow processing. Buffers Spooled: Specifies the number of buffers used to handle the data flow processes.Buffers in Use: Details the number of pipeline buffers (memory pools) in use throughout the package pipeline.Rows Read: Provides the number of rows read from all data sources during package execution.Specifically, the logging encompasses event-resource usage, whereas packages perform the Data Flow Tasks.īegin by focusing on some of the more insightful counters, including the following (at a server-level): These counters enable you to view and understand the use of resources consumed during the execution of SSIS packages. Part of the performance monitoring of the Integration Services service includes configuring the logging of performance counters.
0 Comments
Leave a Reply. |