Examples: Simple Rules - Analytics Database - Teradata Workload Management

Teradata Vantageā„¢ - Workload Management User Guide - 17.20

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Workload Management
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-01-27
dita:mapPath
aji1628112479055.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
B035-1197
Product Category
Teradata Vantage
Rule Name Attributes Current State
Filter Financial_Tbl Non-Finance users are not allowed to access Financial_Tbl Enabled
Throttle DaveFields Session limit on user DaveFields Enabled limit = 3
WD Tactical Classify by Single-AMP into a Workload Definition (WD) Enabled
WD Short Classify by Est Time < 10 seconds into a Workload Definition Enabled
WD Long Classify by Est Time > or equal to 10 seconds into a Workload Definition Enabled
WD Queries Classify by Account = Finance into a Workload Definition

Exception if CPU skew > or equal to 20

Exception action: Change to WD Long

Throttle 10 concurrent

Enabled

Exception Disk Ratio If CPU Disk Ratio > 10

Action: Abort on SELECT

No workloads qualify