16.20 - ReqHotAmpSpool for Monitor Session API - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ NewSQL Engine Release Summary

Teradata Database
Teradata Vantage NewSQL Engine
Release Number
March 2019
Content Type
Release Notes
Publication ID
English (United States)
Last Update

This feature collects and reports spool usage by session. This information is reported in MONITOR SESSION PM/API, and reported in MonitorMySessions and MonitorSession Open APIs, in the following columns: ReqHotAmpSpool and ReqHotAmpSpoolId. ReqHotAmpSpool stores the spool value of the highest utilized AMP and ReqHotAmpSpoolId provides the Vproc ID of the highest spool utilized AMP for the current request.


  • This feature allows users to track skewed spool usage by session.
  • This feature provides the ability to identify the highest shared spool usage for proxy users in trusted sessions.
  • Use this feature from Viewpoint or from a custom PM/API application, or use Open APIs for ad hoc queries.


  • For MONITOR SESSION PM/API requests, you must use monitor software version 13 to report the data described in this feature.

Additional Information

For more information, see Teradata Vantageā„¢ Application Programming Reference, B035-1090.