17.05 - Usage Notes - Teradata Database

Teradata Vantageā„¢ - Resource Usage Macros and Tables

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Administration
User Guide
featnum
B035-1099-170K

You must have logging enabled on the ResUsageSvpr table.

If parallel efficiency, as shown in the ResUsageSpma table, is not approaching 100% look for the reasons for the imbalance; use this macro to find AMP-level CPU skew.