Creating a Workload with Exception from Analyzed Values - 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 window with the previously analyzed workload with exceptions, click the Distribution Parameter option in the View By box.
  2. Right-click over the bucket row to analyze. The Workloads Report shortcut menu for the Distribution Parameter view appears. See the following table for descriptions.
    Option Description
    Split to New Workload with (selected Distribution Parameter) as Exception Select this option to add a new workload with the selected distribution parameter as the Exception.

    This shortcut menu option displays when CPU Time, Response Time, IO Count, or Spool Usage (bytes) is selected from the Distribution Parameter list on the Analyze Workloads tab.

    Add (selected Distribution Parameter) as Exception to workload Select this option to add the selected distribution parameter as a user-defined exception criterion for the highlighted workload.

    This shortcut menu option displays when CPU Time, Response Time, IO Count, or Spool Usage (bytes) is selected from the Distribution Parameter list on the Analyze Workloads tab.

    Zoom In Select this option to change the granularity of the graph view.
    Zoom Out Select this option to change the granularity of the graph view.
    Save Report As Saves the workloads report to a file (in .xml, .txt, or .html formats).
  3. Select Split to New Workload with (selected Distribution Parameter) as Exception. The Add New workload With Exception dialog box appears.
  4. Select the options as described in the following table:
    Option Definition
    Workload Name Name of the workload.
    Preview Classification Click to view the classification of the workload to be created. A read-only Classification window displays with the classification criterion of the workload.
    Workload Description Description of the workload.
    Exception Type Displays the Exception parameter to be used for the exception.
    Exception Name Name of the Exception parameter.
    WD 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.

    Exception Actions No Exception Monitoring – Only log the exception.

    Continue and Log – Logs the exception and choose another action.

    Abort and Log – Log the exception and abort the request.

    Abort On Select and Log – Log the exception and abort the request only if it was a select that did not modify tables.

    Change Workload – Log the exception and move the request to the specified workload.

    Raise Alert – Log the exception and raise the specified alert through Teradata Viewpoint Alert Setup. For more information, see the Teradata® Viewpoint User Guide, B035-2206.

    Teradata Viewpoint Data Collection Service (DCS) monitors database tables and sends alerts to Teradata Viewpoint Alert Viewer for processing. Teradata Viewpoint Alert Viewer allows users to view and manage alerts.

    Run Program – Log the exception and run the specified program using Viewpoint Workload Monitor.

    For more information, see the Teradata® Viewpoint User Guide, B035-2206.

  5. Click OK. The newly created workload with exception appears in the Candidate Workloads tree.