Examples: Simple Rules - Advanced SQL Engine - Teradata Workload Management

Teradata Vantageā„¢ - Workload Management User Guide

Product
Advanced SQL Engine
Teradata Workload Management
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
nbl1556236178169.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1197
lifecycle
previous
Product Category
Software
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