Teradata Database 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, and hash joins consume unusually high levels of memory.
Teradata recommends that you use Memory Usage primarily for throttles.
- 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.