Business intelligence tools, such as Tableau, group multiple SQL statements into a single request. If these large, longer-runnning requests execute concurrently, they can exhaust AWTs and cause shorter requests to collect in the throttle delay queue behind them.
- Isolate multistatement requests into a distinct workload so you can manage them separately from shorter requests
- Prevent multistatement requests from entering a specific workload with the Exclude option, maintaining service-level goals
- Customize the minimum number of SQL statements that qualify as a multistatement request
- You can combine the Multi-Statement Request classification criterion with other classification criteria for more precise workload management control
- You can use the TDWMMSRCount field in DBQLogTbl to log and analyze the frequency and size of multistatement requests
Multi-statement Request classification ignores the following statements in the count of SQL statements in a request: BT, ET, COMMIT, and NULL.
For more information about Multi-statement Request classification, see Teradata Vantage™ Workload Management User Guide, B035-1197.