fn_syscollector_get_execution_stats (Transact-SQL)

THIS TOPIC APPLIES TO: yesSQL Server (starting with 2012)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Returns detailed statistics about the collection set or package, including the number of error rows that are logged by a package data flow task. A data flow task is an Integration Services component that processes data. This data is in relational format, so it has an input and an output dataset consisting of rows.

The statistics are calculated from entries in the syscollector_execution_stats view.

Topic link icon Transact-SQL Syntax Conventions

Syntax


fn_syscollector_get_execution_stats ( log_id )  

Arguments

log_id
The local unique identifier for the execution log. log_id is int.

Table Returned

Column name Data type Description
avg_row_count_in int Average number of rows that entered the data flow tasks of the package.

Note: A data flow task is an Integration Services component that processes data. This data is in relational format, so it has an input dataset that consists of rows. This is the number of rows that entered the task. After the data is transformed, it is output as a result set consisting of rows. The data flow task transforms the data and outputs a result set consisting of rows. This output is the number of rows that exited the task.
min_row_count_in int Minimum number of rows that entered the data flow tasks of the package.
max_row_count_in int Maximum number of rows that entered the data flow tasks of the package.
avg_row_count_out int Average number of rows that exited the data flow tasks of the package.
min_row_count_out int Minimum number of rows that exited the data flow tasks of the package.
max_row_count_out int Maximum number of rows that exited the data flow tasks of the package.
avg_duration int Average time, in milliseconds, spent in the data flow component of the package.
min_duration int Minimum time, in milliseconds, spent in the data flow component of the package.
max_duration int Maximum time, in milliseconds, spent in the data flow component of the package.

Permissions

Requires SELECT for dc_operator.

See Also

syscollector_execution_stats (Transact-SQL)
Data Collection