15.10 - TASM: AMP Worker Task Columns - Teradata Database

Teradata Database Resource Usage Macros and Tables

Product
Teradata Database
Release Number
15.10
Published
April 2016
Language
English (United States)
Last Update
2018-05-17
dita:mapPath
Resource_Usage_Macros_15_10.ditamap
dita:ditavalPath
ft:empty

These columns report statistics about the AMP Worker Tasks.

Column Name Mode Description Data Type
Available track Number of unreserved AMP Worker Tasks from the pool that are not being used at the end of the interval.

For example, if 12 of the normally 56 unreserved AMP Worker Tasks are removed from the pool by reserving them for expedited work, there could at most be 44 unreserved AMP Worker Tasks available. If in this log period, 10 unreserved AMP Worker Tasks are taken from the pool to service 10 queries that are still executing, there would be only 34 available at the end of the log period.

FLOAT
AvailableMin min Minimum number of unreserved AMP Worker Tasks available in the pool for each AMP for the logged period.

For example, a zero value means there were no unreserved AMP Worker Tasks available in the pool at some point during the reporting period.

FLOAT
AwtLimit const Current setting for AMP Worker Task (for example, 80, 100, or so on) in the DBS Control MaxLoadAWT field. For more information, see “MaxLoadAWT” in Utilities. FLOAT
FlowControlled track Specifies if an AMP is in flow control. If the value is non-zero, the AMP is in flow control.

Resource usage indicates flow control on work mailbox name 2-11 only. Work mailbox name 2-11 is the incoming mailbox for AMPs, where 2 is the mailbox number and 11 is the AMP Worker Task partition.

However, resource usage indicates flow control on work mailbox name 2-11 for all work types. For example, if any work type is in flow control, the system is in flow control.

FLOAT
FlowCtlCnt count Number of times during the log period that the system entered the flow control state from a non-flow controlled state. FLOAT
FlowCtlTime count Total time, in milliseconds, that an AMP is in flow control. FLOAT
InuseMax max Maximum number of AMP Worker Tasks in use at any one time during the log period. FLOAT
MailBoxDepth track Current depth of the AMP work mailbox at the end of the period. FLOAT
WorkTypeInuse00 -WorkTypeInuse15 track Current number of AMP Worker Tasks in use during the log period for each work type for the VprId vproc.
The WorkTypeInuse04 column value is always at least 1 due to the internal database design for the Control AMP rows in the ResUsageSawt table.
FLOAT
WorkTypeMax00 - WorkTypeMax15 max Maximum number of AMP Worker Tasks in use at one time during the log period for each work type for the VprId vproc.

In Summary Mode, the WorkTypeMax column values are the Max of the values for all the AMPS.

FLOAT