16.20 - TASM: Multi-Statement Request Classification - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ NewSQL Engine Release Summary

Teradata Database
Teradata Vantage NewSQL Engine
Release Number
March 2019
Content Type
Release Notes
Publication ID
English (United States)
Last Update

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


  • 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.

Additional Information

For more information about Multi-statement Request classification, see Teradata Vantageā„¢ Workload Management User Guide, B035-1197.