Grouping Unassigned Requests into a New Workload - Teradata Workload Analyzer

Teradata Workload Analyzer User Guide

Product
Teradata Workload Analyzer
Release Number
17.00
Published
September 2019
Language
English (United States)
Restricted Access
TTU-17.00-EAP
Last Update
2019-06-07
dita:mapPath
vjd1544831946946.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2514
Product Category
Teradata Tools and Utilities
  1. From the Unassigned Requests report panel, press Ctrl and click the rows to be grouped into a workload.
  2. Right-click to display a shortcut menu.

    The following table describes the options for the Unassigned Requests report shortcut menu.

    Option Submenu option Description
    Add To New Workload Select a single row or block of rows from the Unassigned Requests report and select this option to create a new workload and add all the selected unassigned accounts, applications, or users to the workload.
    Add To Existing Workload Select a single row or block of rows from the Unassigned Requests report and click this option to assign these clusters to an already defined workload.
    Auto-Generate Workloads   Automatically generates single, new workloads from the rows in the Unassigned Requests report that contain the “who” criteria.
    Add Workload Using WildCard   Click this option to open the Select WildCard dialog box to assign these clusters with wild card filters.
    Save Report As   Saves the Unassigned Requests report to a file in .xml, .txt, or .html format.
    Print Report   Prints the Unassigned Requests report.
    Show/Hide Details   Hides or displays all unassigned requests under OTHERS row, in case the Top N value selected is greater than the N requests found in the database. If not, this option is unavailable.
  3. Click Add To, then click New Workload.
  4. Complete the Add Workload dialog box options as appropriate for the new workload. See the following table.
    If there are more than 250 workloads, the Add Workload dialog box becomes unavailable.
    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.
  5. Click OK. The newly created workload now displays in the Workloads Report section of the Candidate Workload Report window.