System Throttles and Stored Procedures - Teradata Workload Management - Database Engine 20

Workload Management User Guide - 20.00

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Database Engine 20
Teradata Workload Management
Release Number
20.00
Published
June 2025
ft:locale
en-US
ft:lastEdition
2025-11-20
dita:mapPath
gew1747088853217.ditamap
dita:ditavalPath
jlp1749501702948.ditaval
dita:id
icm1467243640567
Product Category
Teradata Vantage

You must explicitly include a stored procedure name in the classification criteria if you want it to be covered by a system throttle. Otherwise, TASM ignores the stored procedure CALL statements and throttles only the SQL within the stored procedure.

TASM counts each time code calls a stored procedure. However, if a stored procedure calls itself, TASM does not count that. Consider the following example:
CALL ABC
											ABC calls DEF
											DEF calls DEF (recursive)

A throttle of 1 on stored procedure DEF will not impact this example.