17.00 - TASM: AMP Worker Task Columns - Teradata Database

Teradata Vantageā„¢ - Resource Usage Macros and Tables

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

These columns report statistics about the AMP Worker Tasks. For more information about the ResUsageSawt table and columns, see ResUsageSawt Table Overview.

The data is reporting the contribution of the respective WD to the column and the values are not the same as the values reported in the ResUsageSawt table. The ResUsageSps table values should add up to the ResUsageSawt table for columns like WorkTypeInuse. The Max columns will not be able to be correlated to the ResUsageSawt table Max values in such a direct way since the ResUsageSps Max columns report the Max value of the ResUsageSps table InUse column for the WD and not the Max value of the ResUsageSawt table for all the WDs combined.

Column Name Mode Description Data Type
AwtReleases count Number of AMP Worker Tasks released (that is, completed requests) while the NumRequests column reports the number of AMP Worker Task requests that arrived. For details, see NumRequests. FLOAT
WorkTypeInuse00 -WorkTypeInuse15 track Current number of AMP Worker Tasks in use for each work type. FLOAT
WorkTypeMax00 - WorkTypeMax15 max Maximum of the WorkTypeInuse values reported during the logging period. When multiple data samples occur during the reporting period the value is the maximum of the sampled values.

The true maximum number of in-use AMP Worker Tasks of a WorkType may occur at a different time during the reporting period and not be seen and, therefore, not be reported.

FLOAT
WorkTypeAWTExhausted00 - WorkTypeAWTExhausted15 count Number of times a work message cannot be assigned to an AWT.

This could be caused by no AWTs available in the available pool, or by the number of AWTS in use for the work type reaching its limits.

FLOAT