Active Requests Metrics - Teradata Viewpoint - Teradata Workload Management

Teradata® Viewpoint User Guide - 23.04

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Viewpoint
Teradata Workload Management
Release Number
23.04
Published
April 2023
Language
English (United States)
Last Update
2023-05-05
dita:mapPath
cxb1678987903668.ditamap
dita:ditavalPath
tky1501004671670.ditaval
dita:id
B035-2206
Product Category
Analytical Ecosystem
The following metrics can be displayed for active requests.
Metric Description
Account Account from which a query was submitted
Blocked Time How long the query has been blocked
Snapshot CPU Skew CPU skew during the last sample
CPU Time The amount of CPU processing time consumed by a query
CPU Use Percent of available CPU seconds on the system used during the last sampling period
Δ CPU Total CPU usage time consumed, in seconds, since the last sample
Duration How long the query has been running
Host ID Host ID or LAN ID associated with the PE that processed the login request for the session
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.
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.
In State How long the query has been in the current state
Snapshot I/O Skew I/O skew during the last sample
Δ I/O I/O count since the last sample
Partition Partition in which the query is running
PJI Ratio of the CPU milliseconds per I/O for the query, where a larger Product Join Index number indicates system performance degradation
Proxy Username (Teradata Database 15.10 and later) Name of the proxy user when a trusted session is used
Request CPU CPU seconds needed to run the query
Request Count Number of queries the session has executed
Request CPU Skew CPU skew for the current query
Request I/O Disk I/Os performed to run the query
Request I/O Skew I/O skew for the current query
Session ID Unique session identifier
Spool Spool space the query requires
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.
Start Time that the query started running on Analytics Database
State Text describing the current state of the query
State Icon Icon representing the current state of the query
Temp Space Temp space used by the query
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
Username Name of the user who submitted the query
Virtual Partition (SLES 11) Name of the virtual partition to which the workload belongs
Workload Workload to which the query belongs