Add Hard Limits to a Workload | Teradata Vantage - Add Hard Limits to a Workload - Advanced SQL Engine - Teradata Workload Management

Teradata Vantageā„¢ - Workload Management User Guide

Product
Advanced SQL Engine
Teradata Workload Management
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-28
dita:mapPath
pzr1600284001549.ditamap
dita:ditavalPath
pzr1600284001549.ditaval
dita:id
B035-1197
lifecycle
previous
Product Category
Software
Teradata Vantage

You can, optionally, apply hard limits to SLG tier workloads. A hard limit is a percentage of system resources (CPU and I/O) that the workload can consume. This limit is independent from the share of tier resources the workload has. You cannot apply hard limits to Tactical or Timeshare tier workloads.

The system enforces workload hard limits exactly as you define them in the Workload Designer portlet. You do not need to multiply a workload hard limit by the workload management capacity on demand (WM COD) percent, unlike virtual partition hard limits that do factor in the WM COD system limit. This makes it easy to monitor any workload with a hard limit.

If both virtual partition and workload hard limits exist, each is enforced independently. However, the workload hard limit is not enforced if that workload is under a virtual partition with a fixed allocation that is less than the workload hard limit.

Use hard limits with caution. Overuse of hard limits can cause system resources to be unused.