Converting Priority Scheduler Settings to Workloads - Teradata Workload Analyzer

Teradata Workload Analyzer User Guide

Product
Teradata Workload Analyzer
Release Number
15.00
Language
English (United States)
Last Update
2018-09-27
dita:id
B035-2514
lifecycle
previous
Product Category
Teradata Tools and Utilities

Converting Priority Scheduler Settings to Workloads

To convert Priority Scheduler settings to workloads

1 In the Existing PSA Setting dialog box, click Convert.

The Migrated TASM Settings tab appears.

Notice that the dialog box provides the following new workload definition information:

  • RP Weight
  • AG Name
  • Enforcement Priority
  • AG Weight
  • Relative Weight
  • Previous Relative
  • Workload Name
  • Classify Criteria
  • By default, the conversion maps the PDSet “as is.” However, if you select Simplified Structure, DWM maps the PDSet such that the default RP is not used for requests even if the original PDSet did so. Instead, DWM creates a new RP for the work from the Default RP, reserving the Default RP for system work. A tactical partition is created for short-running, high-priority tactical queries, and the Standard partition runs the remaining work.

    2 After selecting either Remap As Is or Simplified Structure, click Continue to complete the conversion.

    3 Click Cancel to exit the dialog box.

    4 In the Parameters window, click View CPU Distribution.

    This prompts Teradata WA to group accounts into workloads and displays the PSA to DWM Conversion - CPU Distribution dialog box.

    5 The fields and controls on this dialog box are described in the table below.

     

    Option

    Description

    Log Option

    Select the appropriate log from these options:

  • DBQL (default)
  • External DBQL
  • External DBQL contains DBQL data which has been copied to a database other than DBC. Its table schema can be identical to DBQL, but for improved performance Teradata recommends that DBQL data be copied to a history database defined according to Professional Services guidelines. See Database Administration (B035‑1093).

    Database

    The database being analyzed.

    Date Range

    Enter the starting and ending dates of the range of the data collected. The displayed date format depends on the regional settings of the PC. To select a date from a calendar pop-up window, click the drop-down arrow. The default start date is a month prior to the current system date; the default end date is the current system date.

    Time Window

    Enter the starting and ending times of the range in HH format, using a 24-hour clock. Alternatively, click the drop-down arrow to select an hour from the list. The default Start Hour is 00 (12:00 A.M.) and the default End Hour is 23 (11:00 P.M.).

    Note: Teradata WA includes all of the specified End Hour in its analysis. For example, End Hour 23 means analyze DBQL data up to and including 23:59:59.99.

    OpEnv

    Select the period. Click the ... button to populate the list with all available periods.The default is Always.

    Top N Value

    This value indicates the number of the most resource-intensive workloads to analyze. For example, 3 analyzes the three most resource-intensive workloads running (10 is the default).

    View CPU Distribution

    Calculates CPU distribution of workloads.

    Save Rule Set

    Saves the current rule set.

    6 Select Rule Set > Calculate All WD SLGs.

    A progress bar appears while Teradata WA determines the service level goal recommendations. These appear in the SLG Recommendations pane.