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.

Query Information

Query Information Description
State Query state, such as active, blocked, terminate
Time in State How long the query has been in the current state, displayed as hh:mm:ss
Total Duration Total elapsed time it took for the query to execute once it was submitted
Spool Space Amount of spool space the query is using
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.
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.
Temp Space Amount of temp space the query is using
Request CPU Total CPU seconds needed to run the query, in seconds
Impact CPU CPU impact on the system based on the highest utilized AMP. For Teradata Database 15.0 and earlier, calculated at the snapshot level; for Teradata Database 15.10 and later, calculated at the request level.
Request I/O Total number of disk I/Os performed
Request CPU Skew CPU skew for the current query for Teradata Database 15.10 and later
Request I/O Skew I/O skew for the current query for Teradata Database 15.10 and later
PJI Ratio of the CPU milliseconds per I/O for the query, where a larger Product Join Index number indicates system performance degradation
Unnecessary I/O All AMP I/O divided by all AMP CPU, displayed in milliseconds, to reveal large amounts of I/O occurring over a short period of time
Remote Data Imported Total bytes imported from a remote server for this query for Teradata Database 15.0 and later
Data Exported Remotely Total bytes exported to a remote server for this query for Teradata Database 15.0 and later

Workload Information

Workload Information Description
Name Name of the workload where the query is actively running
Method Name of the workload management method in SLES 11. Available values are:
  • Tactical
  • SLG Tier (not used by IWM systems)
  • Timeshare
CPU Decay Most severe level of CPU resource access restriction for queries in a Timeshare workload in SLES 11
CPU Exception Nodes Number of nodes that exceeded the tactical CPU time exception criteria for the session in a Tactical workload in SLES 11
Classification Mode How a query or session is assigned to a workload. Available values are:
  • Auto - Query is assigned automatically by TASM
  • Request - Query is assigned manually to a workload using Change Workload
  • Session - Queries initiated in that session are assigned manually to a workload using Change Workload

This field is empty if this is not a DBC/SQL session or if Teradata Workload Management Category 3 is disabled.

Virtual Partition Name of the virtual partition in SLES 11
I/O Decay Most severe level of I/O resource access restriction for queries in a Timeshare workload in SLES 11
I/O Exception Nodes Number of nodes that exceeded the tactical I/O usage exception criteria for the session in a Tactical workload in SLES 11

Session Information

Session Information Description
User Name of the user that submitted the query
Proxy Username Name of the proxy user when a trusted session is used for Teradata Database 15.0 and later
Account Account of the user that submitted the query
Source Source details, such as application name, IP address, and host user name
Partition Partition in which the query is running
Requests Number of queries submitted by the session