Virtual Partitions | Teradata Vantage - 17.10 - Virtual Partitions - 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)
Only one virtual partition is available on systems with TIWM.
In the priority hierarchy, the first level that an administrator can interact with is the virtual partition. A virtual partition represents a collection of workloads. The default is one virtual partition, but you can define up to 10. One virtual partition is adequate to cover the needs of most systems, and is a good starting point. Multiple virtual partitions are intended for platforms that support distinct business units or geographic entities that need to be kept separated.

Each virtual partition offers Tactical tier, SLG tiers, and Timeshare tier for workload placement within the virtual partition.

There is one set of health conditions and planned environments that span all virtual partitions. Only the workloads are placed into different virtual partitions.