Overview Tab for Teradata Database - Teradata Viewpoint - Teradata Workload Management

Teradata® Viewpoint User Guide

Product
Teradata Viewpoint
Teradata Workload Management
Release Number
16.50
16.20
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
yqb1520516846011.ditamap
dita:ditavalPath
yqb1520516846011.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.

Query Information

Query Information Description
State Query state, such as active, blocked, terminate
Block Time Start Date and time the session became blocked, displayed as mm/dd/yy hh:mm:ss.
Time in State How long the query has been in the current state, displayed as hh:mm:ss
Query Start Time Date and time the query started, displayed as mm/dd/yy 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 (Teradata Database 16.0 and later) Current spool value of the highest spool utilized AMP for the query. If no request is running on the session, no value displays.
Spool Skew (Teradata Database 16.0 and later) Current spool skew for the query. 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. (Teradata Database 15.0 and earlier) Calculated at the snapshot level. (Teradata Database 15.10 and later) Calculated at the request level.
Request I/O Total number of disk I/Os performed
Request CPU Skew (Teradata Database 15.10 and later) CPU skew for the current query
Request I/O Skew (Teradata Database 15.10 and later) I/O skew for the current query
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 (Teradata Database 15.0 and later) Total bytes imported from a remote server for this query
Data Exported Remotely (Teradata Database 15.0 and later) Total bytes exported to a remote server for this query

Snapshot Information

Snapshot Information Description
CPU Use Percent of available CPU seconds on the system used during the last sampling period
Impact CPU (Teradata Database 15.0 and earlier) CPU impact on the system based on the highest utilized AMP
Snapshot CPU Skew CPU skew during the last sample
Snapshot I/O Skew I/O skew during the last sample

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 (Teradata Database 15.0 and later) Name of the proxy user when a trusted session is used
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
Request Admission Time Timestamp when the query was admitted to the system