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:
| Option | Description |
|---|---|
| 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)
- COMMIT
- NULL
The TDWMMSRCount field in DBC.QryLogV view shows the statement count in a multistatement request.