Overview Tab - Teradata Viewpoint

Teradata Viewpoint User Guide

Product
Teradata Viewpoint
Release Number
16.00
Published
October 2016
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
fey1467302953244.ditamap
dita:ditavalPath
2206_User_vp_1600_NEW.ditaval.ditaval
dita:id
B035-2206
lifecycle
previous
Product Category
Analytical Ecosystem
The Overview tab provides detailed information about key metrics for the selected session and its queries. The metric values provide a view of the query status on the system. Metrics that exceed defined thresholds are highlighted.
Metric Description Type
Total Duration How long the query has run, displayed as hh :mm :ss Number
User Name of the user that submitted the query Character
Account Account of the user that submitted the query Character
Req Number Number of I/O operations the query performed Number
Hot AMP Spool Current spool value of the highest spool utilized AMP for the query for Teradata Database 16.0 and later. If no request is running on the session, no value displays. Number
Spool Skew Current spool skew for the query for Teradata Database 16.0 and later. If no request is running on the session, no value displays. Percentage
Req CPU Total CPU usage time, in seconds, consumed by the query Number
Impact CPU CPU impact on the system based on the highest utilized AMP for Teradata Database 15.10 and later. Calculated at the request level. Number
Req I/O Number of I/O operations the query performed Number
Req CPU Skew CPU skew for the current query for Teradata Database 15.10 and later Percentage
Req I/O Skew I/O skew for the current query for Teradata Database 15.10 and later Percentage
Req Max Spool Amount of spool space the query requires Number
Source Source details, such as application name, IP address, and host user name Character