What is a Teradata AMP?
An AMP (Access Module Processor) manages its assigned share of data and query work. PI hashing and the table map determine placement; they do not guarantee even distribution. AMP counts, memory and physical storage arrangements are deployment and configuration dependent.
Part of the Teradata Internals and Operations guide.
What are the tasks of a Teradata AMP?
A Teradata AMP is responsible for various tasks related to its data rows, such as reading and storing, aggregating, performing joins, locking, sorting, disk space management, and format conversion when creating a result set.
What is a Teradata AMP Worker Task (AWT)?
AMP worker tasks process plan work within an AMP. Available and reserved AWT counts, task classes and load-operation requirements depend on release and configuration; the historical 80/24 figures are not universal limits. Size workloads using the actual system configuration and resource-usage evidence.
What happens when all AMP Worker Tasks of an AMP are in use?
When worker capacity and message queues are constrained, flow control provides backpressure: messages can be rejected and retried until accepted. This does not necessarily abort the SQL request on all AMPs. Repeated flow control can indicate overload and should be investigated with configured resource-usage logging.
Are all Teradata AMPs always involved in a request?
Requests may use one AMP, a group of AMPs or all participating AMPs. A fully specified PI lookup can be single-AMP. A USI lookup commonly involves two AMPs, or one when the index and base row reside together. The actual query and table maps determine participation.
What happens if an AMP crashes?
Recovery depends on fallback/storage protection and restart or migration configuration. Fallback keeps additional data copies; it does not mean one designated backup AMP universally replaces the failed AMP process. Node and AMP recovery behavior is platform specific and requires the documented recovery procedure.
The components around the AMP are covered separately: how the PE, BYNET and AMP divide the work and a short overview of the architecture.
Get the complete Teradata tuning book, free
Teradata Query Performance Tuning: The DWHPro Guide
By Roland Wenzlofsky & Artemios Vogiatzis
206 pages on statistics and demographics, access paths and indexes, query execution plans, and joins. Get the full PDF and practical Teradata updates from DWHPro.
Confirm your email to receive your download link. Privacy policy. Unsubscribe in any newsletter.
About the free bookDeciding what to change in your data platform?
Compare optimisation, modernisation and migration against your workload and business requirements.
Get the complete Teradata tuning book, free
Teradata Query Performance Tuning: The DWHPro Guide
By Roland Wenzlofsky & Artemios Vogiatzis
206 pages on statistics and demographics, access paths and indexes, query execution plans, and joins. Get the full PDF and practical Teradata updates from DWHPro.
Confirm your email to receive your download link. Privacy policy. Unsubscribe in any newsletter.
About the free book