This performance counter monitors the total number of binary large object (BLOB) files in use for spooling by the data flow engine within a given time period. The value of this performance counter fluctuates as BLOB files are used and disposed. The value of this counter is usually high and could be reset back to zero whenever the SSIS service is restarted.
DBAs, Server administrators, ETL developers
- Add temporary storage to increase processing speed
- Add more physical memory to the compute
- Reduce extracting BLOB data such as images in your data flow
Administering SQL Server 2005 Integration Services – Page 3
SSIS: Performance Counter
Introduction to BLOB data types in SSIS: Part 1