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.
The Multi-Statement Request classification criterion in Teradata Viewpoint Workload Designer lets you identify, isolate, and manage multistatement requests. This classification criterion allows you to do the following:
- 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
Benefits
- 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
Considerations
Multi-statement Request classification ignores the following statements in the count of SQL statements in a request: BT, ET, COMMIT, and NULL.
Additional Information
For more information about Multi-statement Request classification, see Teradata Vantage™ Workload Management User Guide, B035-1197.