Session View Metrics

Teradata® Viewpoint User Guide

brand
Analytical Ecosystem
prodname
Teradata Viewpoint
Teradata Workload Management
vrm_release
16.20
category
User Guide
featnum
B035-2206-107K
Metrics available for monitoring and display are listed below. For a list of metric sources for some of the metrics listed below, see Metric Sources Overview.
Metric Description Type
Account Account from which a query was submitted String
Blocked Time How long the query has been blocked Number
CPU Use Available CPU seconds on the system used during the last sampling period Percent
Δ CPU Total CPU usage time consumed, in seconds, since the last sample Number
Δ I/O I/O count since the last sample Number
Duration How long the query has been running Number
Host Host ID or LAN ID associated with the PE that processed the login request for the session Number
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. Number
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. Number
In State How long the query has been in the current state Number
Partition Partition in which the query is running String
PJI Ratio of the CPU milliseconds per I/O for the query, where a larger Product Join Index number indicates system performance degradation Number
Proxy Username (Teradata Database 15.0 and later) Name of the proxy user when a trusted session is used String
Query Band Set of name-value pairs for the session or transaction String
Request CPU CPU seconds needed to run the query Number
Request I/O Disk I/Os performed to run the query Number
Request Count Queries the session has executed Number
Request CPU Skew (Teradata Database 15.10 and later) CPU skew for the current query Percent
Request I/O Skew (Teradata Database 15.10 and later) I/O skew for the current query Percent
Session ID Unique session identifier Number
Snapshot CPU Skew CPU skew during the last sample Percent
Snapshot I/O Skew I/O skew during the last sample Percent
Spool Spool space the query requires, using a 1024 byte kilobyte as the base Number
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. Percent
Start Time that the query started running on Teradata Database Number
State Text describing the current state of the query String
State Icon Icon representing the current state of the query Icon
System Full name of the system running the query String
Temp Space Temp space used by the query, using a 1024 byte kilobyte as the base Number
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 Number
Username Name of the user who submitted the query String
Workload Workload in which the query is running String