Example: Classifying a Workload by Application - 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
Workload classification criteria cannot be manually modified from the Classification tab of the Workload Attributes window. You can, however, add more classification criteria using the Split option.
  1. Right-click the workload in the list on the left side of the Workload Attributes window.
  2. Click Split from the right-click menu.. The Split Workloads dialog box appears. For details on the fields used for splitting workloads, see Splitting Workloads.
  3. Click Add New Classification. The Classification tab appears, similar to the tab of the same name on the Workload Attributes window, however all functionality is enabled.
  4. Select the Choose another selection criteria check box. The --AND-- pane of the tab becomes visible, showing the Criteria #2 drop-down list. The list includes the items shown as check boxes in the Category pane of the Define DBQL Inputs dialog.
  5. Select Application from the Criteria #2 list of the Classification tab. See Defining or Modifying Classification Criteria #2–6 for a WD for more information. The Choose box and button become enabled.
  6. Click Choose. The Classify by Application dialog box appears.
  7. Click Load to display all items that can be used as application attributes.
  8. From the Available list, select the items you want to include as attributes and click Include.
    Use the Shift and Ctrl keys to select multiple consecutive or non-consecutive attributes. To move an attribute back to the Available list, select it and click Remove.
  9. From the Available list, select the attributes to exclude and click Exclude.
  10. When finished, click OK to return to the Classification tab and select additional criteria. Use Cancel to discard classification selections and start over.