SQL batch capture

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

SQL batch capture controls whether Adaptive Server collects SQL text. If both SQL batch capture and max SQL text monitored are enabled, Adaptive Server collects the SQL text for each batch for each user task.