Grouping Accounts, Applications, Users, or Profiles into a Workload - Teradata Workload Analyzer

Teradata Workload Analyzer User Guide

Product
Teradata Workload Analyzer
Release Number
16.20
Published
October 2018
Language
English (United States)
Last Update
2018-10-12
dita:mapPath
sef1527114222310.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2514
lifecycle
previous
Product Category
Teradata Tools and Utilities
  1. Select Rule Set > Workloads > New Workload. See the following table for more information about the Rule Set menu.
    Menu option Sub menu option Description
    Save to Database Saves the rule set to the TDWM database.
    The TDWM database is locked as a rule set is saved.
    Workloads New Workload Adds a new workload to the Candidate Workload Report window.
    Merge Workloads Merges selected workloads into a single workload.
    Split workload Splits the selected workload into one or more workloads.
    Calculate SLGs Calculates the service level goals for the selected workload.
    Delete Workload Deletes a workload from the Candidate Workload Report window.
    Workload to AG Mapping Performs the workload definition to allocation group mapping
    Calculate All WDs SLGs Calculates service level goals for all defined workloads.
    The Rule Set menu is available when the Candidate Workload Report window is open.
  2. From the Add Workload dialog box, complete the options as appropriate for the new workload.


    Option Description
    Name The name of the workload.
    Description A description of the workload.
    Enforcement Priority
    • Tactical – Short queries with a fixed response-time requirement.
    • Priority – Important queries that should get extra resources.
    • Normal – Normal queries; this is the default.
    • Background – Low-priority queries with no response time requirement.
  3. Click OK.

    The newly created workload now displays in the Workloads Report section of the Candidate Workload Report window.