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

Teradata Vantageā„¢ NewSQL Engine Release Summary

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Content Type
Release Notes
Publication ID
B035-1098-162K
Language
English (United States)
Last Update
2019-05-03

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.

Benefits

  • 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.

Considerations

  • 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.