Workload Management Needs | Teradata Vantage - 17.10 - Determining Workload Management Needs - Advanced SQL Engine - Teradata Workload Management

Teradata Vantage™ - Workload Management User Guide

Advanced SQL Engine
Teradata Workload Management
Release Number
Release Date
July 2021
Content Type
User Guide
Publication ID
English (United States)

Take the following actions before implementing workload management.

Action Additional Information
Monitor single system metrics and resource usage trends within specified time frames with the Viewpoint Metric Heatmap portlet. For information on the Metric Heatmap portlet, see Teradata® Viewpoint User Guide, B035-2206.
Study resource contention at various times of day and to understand blocking and wait time patterns with the Viewpoint Query Monitor and Lock Viewer portlets. For more information on the Query Monitor and Lock Viewer portlets, see Teradata® Viewpoint User Guide, B035-2206.
Enable DBQL detailed logging for at least 3 weeks to understand request performance.
  • Capture DBQLogTbl, DBQLSQLTbl, and DBQLObjTbl data.
  • After detailed logging captures enough information, use the LIMIT THRESHOLD or LIMIT SUMMARY options for highly-tuned short work.
Enable ResUsage. ResSPMA, ResSPS, and ResSAWT are extremely helpful with system, scheduler, and AMP Worker Task (AWT) analysis.

The ResUsageSPS table can help you determine resource usage by workload.

Identify workload types, such as ad hoc, ETL, and short highly-tuned requests:
  • Determine how these workloads are identified on the system; for example, by account strings, profiles, and groups of users.
  • Identify different processing periods, such as day, night, weekday, and weekend.
  • Determine the priorities given to different workload types during different processing periods.
Document all Service Level Goals.  
Document the exceptional conditions that now require the DBA to intervene, such as long request runtime, high request CPU use, high skew, and too many sessions or requests.  
Document current operational limits, such as optimal concurrency levels for load utility jobs and all application groups.  
Ensure the Viewpoint server software is current.  

Everyone involved with the Teradata system needs to understand and agree about business priorities. Many workload management performance issues are caused by user disagreements about the relative importance of the workloads.