Delay Queue Depth and Delay Queue Time - 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
Two workload events can detect when a workload is delayed for a long time because of throttle limits:
  • Delay Queue Time: This event detects how long in seconds, minutes, or hours the longest-waiting request has been in the delay queue. Delay Queue Time can, optionally, include the time a system throttle delays a request.
  • Delay Queue Depth: This event detects how many requests are currently delayed.

An interesting use case follows: Some applications indicate performance levels to users before they submit their requests. This levels system load because users may defer their next request when there are long response times. But even if the users submit their requests anyway, they are more satisfied because they know what to expect. In fact, one customer saw fewer users killing and resubmitting their requests when the customer established user expectations with a response time indicator. Using the response time indicator improved overall system performance because it eliminated the kill and resubmit resource consumption. You can use delay queue events to serve as an application performance indicator when you select the Post to QTable action. This action writes rows to DBC.SystemQTbl. Monitoring applications consume the rows in this table to provide the performance level indicators, as described here.