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

Teradata Vantageā„¢ NewSQL Engine Release Summary

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
created_date
March 2019
category
Release Notes
featnum
B035-1098-162K

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.