BI performance counter: SSIS Package Instances

Applies to

SSIS

Description

This performance counter monitors a total number of SQL Server Integration Services (SSIS) packages that are currently running.

The value is expressed in a numeric number that is usually low.

Resolved by

DBAs, Server administrators, ETL developers

Suggested solutions

  1. On Integration Services Catalog, go through the All Executions built-in report
  2. If your packages are triggered by a SQL Agent, go through currently executing job steps
  3. When dealing with multiple packages, execute main packages prior to dependent packages

Additional research

Something about SSIS Performance Counters
Perfmon Counters for the Integration Services Data Flow Engine
SSIS Pipeline performance counters

 

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