BI performance counter: BLOB files in use

Applies to

SSIS

Description

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.

Resolved by

DBAs, Server administrators, ETL developers

Suggested solutions

  1. Add temporary storage to increase processing speed
  2. Add more physical memory to the compute
  3. Reduce extracting BLOB data such as images in your data flow

Additional research

Administering SQL Server 2005 Integration Services – Page 3
SSIS: Performance Counter
Introduction to BLOB data types in SSIS: Part 1

 

To track BI performance metrics – consider using ApexSQL BI Monitor, a web application that monitors system, SSAS, SSIS and SSRS performance in real time.

⇐ Back to index