statement pipe active

statement pipe active controls whether SAP ASE collects statement-level statistics.

Summary Information

Default value

0 (off)

Range of values

0 (off), 1 (on)

Status

Dynamic

Display level

Comprehensive

Required role

System administrator

Configuration group

Monitoring

If both statement pipe active and statement pipe max messages are enabled, SAP ASE collects the statement statistics for each query. Use monSysStatement to retrieve the statistics for all executed statements.