Estimated Memory Usage | Teradata Vantage - 17.10 - Estimated Memory Usage - Advanced SQL Engine - Teradata Workload Management

Teradata Vantageā„¢ - Workload Management User Guide

Product
Advanced SQL Engine
Teradata Workload Management
Release Number
17.10
Release Date
July 2021
Content Type
Administration
User Guide
Publication ID
B035-1197-171K
Language
English (United States)

Vantage logs estimated and actual memory use for each request step in DBQLogTbl. Use TASM to identify requests that use large amounts of memory, then classify or throttle these requests appropriately. XML functions, some aggregations, hash joins, and queries that reference Native Object Store tables consume unusually high levels of memory.

Teradata recommends that you use Memory Usage primarily for throttles.

You can specify Memory Usage as a criterion for a throttle in the Throttles view, Classification tab, Query Characteristics classification criteria. The choices for Memory Usage are:
  • Increased
  • Large
  • Very large

The range of memory associated with each category is defined in the default memory usage thresholds for your platform configuration. To see the defaults, look under System Settings in Viewpoint Workload Designer.

The request memory estimate represents peak use, typically by the largest step.