BI performance counter: Rows written

Applies to

SSIS

Description

This performance counter keeps track of total number of output rows that have been written into destination adapters.

This counter will give you an indication of the overall execution progress of your data flow tasks. Because this counter tracks all rows read since the counter was started, you should expect the value of this counter to be very high.

Resolved by

DBAs, Server administrators, ETL developers

Suggested solutions

  1. Disable constraints check prior to writing into target table
  2. Increase the size of your database log file
  3. Consider storing file used by target adapters on a SAN
  4. Use partitioning on your target table
  5. Try to perform your data flows in bulk mode instead of row by row
  6. Add more physical memory to the computer

Additional research

SSIS: Performance Counter
SSIS Pipeline Performance Counters Guide

 

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