Workload Management Needs | Teradata Vantage - Determining Workload Management Needs - Analytics Database - Teradata Workload Management

Teradata Vantage™ - Workload Management User Guide - 17.20

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Workload Management
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-01-27
dita:mapPath
aji1628112479055.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
B035-1197
Product Category
Teradata Vantage

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.