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

Teradata Viewpoint User Guide

Teradata Viewpoint
Release Number
June 2017
English (United States)
Last Update
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 Database 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, meaning the response time goal should be 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, mouse over the Store Rewards workload in the workload pane. An information balloon appears, showing the percentage of requests that missed the SLG.

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