Example: Prioritizing Tactical Queries and Defining Their SLGs - Teradata Viewpoint - Teradata Workload Management

Teradata® Viewpoint User Guide - 24.04

Teradata Viewpoint
Teradata Workload Management
Release Number
April 2024
English (United States)
Last Update
Product Category
Analytical Ecosystem
Suppose a grocery store chain wants to give personalized coupons. At checkout, the customers slide their rewards cards. The database is queried for suitable coupons, and the results need to return within one second. You want to set the SLG to have a response time of no more than one second, 98 percent of the time.
  1. Select a ruleset to edit.
    1. Open the Workload Designer portlet and the Workload Designer view.
    2. From the For System list, select PROD1.
    3. In the local Working section, click the ruleset name, SLG.
  2. Create a workload.
    1. From the ruleset toolbar, click Workloads.
    2. Next to Workloads, click .
    3. In the General tab, enter a name for the workload, in this case Store Rewards.
    4. Under Workload Management Method, select Tactical.
    5. Click Save.
  3. Add classification criteria to limit the rule to the Store Rewards application, that submits the queries to the Teradata system.
    1. Click the Classification tab.
    2. From the Add Classification Criteria list, select Request Source.
    3. Click Add.
      The Edit Request Source Criteria dialog box appears.
    4. From the Source Type list, select Application.
    5. Under Application, enter the name of the application that queries the database: StoreRewards_Application
    6. Click Include.
    7. Click OK.
    8. Click Save.
  4. Define the service-level goals.
    1. Click the Service Level Goals tab.
    2. Under Default Settings, select Response Time Goal.
    3. In the Response Time field, enter 1 for a response time goal of maximum 1 second.
    4. In the Service Percent field, enter 98.
      This means the response time goal is met at least 98% of the time.
    5. Click Save.
  5. Activate the ruleset.
    1. Go back to the Workload Designer view.
    2. For the SLG ruleset, click "" and select Make Active.
  6. [Optional] Review requests that missed the SLG criteria you defined.
    1. Open the Workload Monitor portlet.
    2. In the Dynamic Pipes View, hover over the Store Rewards workload in the workload pane.
      An information balloon appears, showing the percentage of requests that missed the SLG.

      Percentage of requests that missed SLG
    3. For more details, click the name of the workload.
      The Workload Details View appears, providing details about, for example, request arrivals and completions.