Business intelligence tools, such as Tableau, group multiple SQL statements into one request. The Multi-Statement Request classification criterion lets you identify, isolate, and manage multistatement requests using the following options:
|Exclude||Prevents multistatement requests from being included in a specific workload.|
|Include||Splits multistatement requests into a distinct workload so you can manage them separately from shorter requests.|
|Threshold statement count||Enter a value to define the minimum number of SQL statements that qualify as a multistatement request. The default is 2.|
This classification criterion applies to workload, filter, and throttle rules and can be combined with all existing classifications.
TASM ignores the following special statements when counting the statements in a request:
- BEGIN TRANSACTION (BT)
- END TRANSACTION (ET)
The TDWMMSRCount field in DBC.QryLogV view shows the statement count in a multistatement request.