BI performance counter: BLOB bytes written

Applies to

SSIS

Description

This performance counter monitors the total number of bytes within the data flow engine that are written out as binary large object (BLOB) into all target data sources. This is usually represented as a high bytes value which is reset back to zero bytes whenever the Integration Service server is restarted. This counter may indicate a need for additional RAM and temporary storage.

Resolved by

DBAs, Server administrators, ETL developers

Suggested solutions

  1. Use dm_execution_performance_counters function to retrieve statistics for a running execution
  2. Add more physical memory to the computer
  3. Reduce extracting BLOB data such as images in your data flow

Additional research

Something about SSIS Performance Counters
SSIS Pipeline performance counters guide
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