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

Teradata Vantageā„¢ - Workload Management User Guide

Advanced SQL Engine
Teradata Workload Management
Release Number
Release Date
July 2021
Content Type
User Guide
Publication ID
English (United States)

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.