TASM: AMP Worker Task Columns - Advanced SQL Engine - Teradata Database

Resource Usage Macros and Tables

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
dep1592878989156.ditamap
dita:ditavalPath
dep1592878989156.ditaval
dita:id
B035-1099
lifecycle
previous
Product Category
Teradata Vantageā„¢

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

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