16.20.16.20 - 16.20 - Distributing Workload Resources - Teradata Workload Management

Teradata® Viewpoint User Guide

prodname
Teradata Viewpoint
Teradata Workload Management
vrm_release
16.20
category
User Guide
featnum
B035-2206-107K
In SLES 11, you can allocate resources to workloads for each planned environment.
  1. Edit or create a ruleset.
  2. From the ruleset toolbar, click Workloads.
  3. Click the Workload Distribution tab.
  4. [Optional] If multiple planned environments or virtual partitions exist, click to select the area you want to manage.


  5. [Optional] Drag a workload from one management method to another to change resource allocation across planned environments.
    Direction Results
    Tactical to SLG Tier
    • You can select the SLG Tier in the current planned environment. The workload is assigned to the lowest SLG Tier in all other planned environments.
    • Minimum allocation percentage (5%) is assigned to the workload. The allocation comes from unallocated resources remaining for the tier, or from the workload with the highest allocation in the tier.
    • Tactical exception is deleted for the workload.
    Tactical to Timeshare
    • You can select the access level for the workload in the current environment. The access level is changed to medium in all other planned environments.
    • Tactical exception is deleted for the workload.
    SLG Tier to Tactical
    • Tactical exception is created for both Tactical CPU Time and Tactical I/O Physical Byte thresholds in the workload.
    • Hard limits are removed for a workload if they were enabled.
    SLG Tier to Timeshare
    • You can select the access level for the workload in the current environment. The access level is changed to medium in all other planned environments.
    • Hard limits are removed for a workload if they were enabled.
    Timeshare to Tactical Tactical exception is created for both Tactical CPU Time and Tactical I/O Physical Byte thresholds in the workload.
    Timeshare to SLG Tier
    • You can select the SLG Tier in the current planned environment. The workload is assigned to the lowest SLG Tier in all other planned environments.
    • Minimum allocation percentage (5%) is assigned to the workload. The allocation comes from unallocated resources remaining for the tier, or from the workload with the highest allocation in the tier.
  6. [Optional] Under SLG Tier, do any of the following:
    Option Description
    Add a tier Next to SLG Tiers, click .
    Change tier for a workload
    • If multiple tiers exist, drag workloads from one tier to another.
    • (Teradata Database 14.10 and later) If you drag a workload from Tier 1 to a lower tier, SLG expedite is removed if it was enabled.
    Change resource allocation for a workload Drag the border of a workload horizontally.
    Edit workload resource allocation for the tier

    (Teradata Database 14.10 and later)

    • Next to a tier name, click .
    • Enable SLG expedite for Tier 1 workloads.
    • Enable Hard limits for workloads in all tiers.
    It is recommended that hard limits be set no lower than 3% if only a single workload has a limit or no lower than 5% if multiple workloads have limits.
    Delete the tier
    • Next to the lowest tier name, click .

      Tier 1 can never be deleted. Only tiers that do not contain workloads can be deleted. Only the lowest tier can be deleted. If the lowest tier does not contain workloads, the tier is automatically deleted when you save the tab settings.

  7. [Optional] Under Timeshare, drag a workload from one access level to another to assign the priority of resource allocation for queries in the workload.
  8. Click Save.