Multistatement Requests | Teradata Vantage - 17.00 - Multistatement Requests - Teradata Workload Management

Teradata Vantageā„¢ - Workload Management User Guide

prodname
Advanced SQL Engine
Teradata Workload Management
vrm_release
17.00
created_date
June 2020
category
Administration
User Guide
featnum
B035-1197-170K
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.