Creating New Workloads by Grouping Existing Workloads - 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 Analyze Workload tab, select the Correlation Parameter option in the View By box.
  2. Select one or more rows in the Analyze Workloads report with the attributes to be flagged, for example, “high CPU usage.”
  3. Right-click to display the shortcut-menu. The Analyze Workloads report shortcut-menu displays the options described in the following table.
    Option Description
    Split to New Workload After selecting a single row or block of rows in the Analyze Workload report, choose this option to create a new workload with all the selected classifications. The selected row is removed from the report and the graph is updated with the remaining unassigned clusters.
    Add clusters for Deeper analysis Click to add selected clusters to the current workload for deeper analysis. The selected cluster is removed from the report and the graph is updated.
    This option is disabled for original workloads. The Split Workload option allows for a new workload to be created. See the shortcut menu options in Analyzing Workloads Based On “Who” Parameters. The Add To option is then enabled for further workload classification.
    This option is disabled for original workloads. The Split Workload option allows for a new workload to be created. The Add To option is then enabled for further workload classification.
    Auto-generate Workloads Select this option to automatically generate a new workload for each selected row.
    Update Graph and Distribution Report Select this option to update the report and redraw the graph to include changes.
    Save Report As Select this option to save report in .txt, .html, or .xls format.
  4. Select Split to New Workload. The Add Workload dialog box appears.
  5. Fill in the Add Workload dialog box to describe the new workload.
  6. Click Preview Classification to view the classification of the workload to be created. A read-only Classification window displays with the classification criterion of the workload.
  7. Click OK. Teradata WA creates a new workload containing both the Criteria #1 and Criteria #2 attributes.