17.00 - 17.05 - Determining Workload Management Needs - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
17.05
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
rgu1556127906220.ditamap
dita:ditavalPath
lze1555437562152.ditaval

Before defining TASM workload management parameters, you should evaluate how your database is used. The objective is to identify job handling and query limitation needs that cannot be met by performance group assignments and scheduling.

  • Monitor database activity using the Teradata Viewpoint Metric Heatmap portlet to understand overall workload concurrency and possible resource contention. For information on the Metric Heatmap portlet, see Teradata® Viewpoint User Guide, B035-2206.
  • Use the Teradata Viewpoint Query Monitor and Lock Viewer portlets to study resource contention at various times of day, and to understand blocking and wait time patterns.
  • Optionally, use the database query logging (DBQL) logging feature to determine query performance details. For information on tracking processing behavior with DBQL, see BEGIN/REPLACE/END QUERY LOGGING Statements.
  • Optionally, monitor the ResUsageSPS table to determine resource usage by performance group. For information on the ResUsageSPS table, see Teradata Vantage™ - Data Dictionary, B035-1092.