Delayed Requests Metrics - 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 following metrics can be displayed for delayed requests. The metrics are listed by the tabs on which they appear.

By Workload

This tab displays all queries that are currently delayed.

Metric Description
Account Account from which a query was submitted
Blocked Time How long the query has been blocked
Blocking Count Number of consecutive times a session has blocked at least one other session
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
Delay Time Average time requests spends in the delay queue
Duration How long the query has been running
Host ID Host identifier or LAN identifier associated with the PE that processed the login request for the session
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.
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.
In State How long the query has been in the current state
Δ 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 Name of the proxy user when a trusted session is used. Displayed only for Teradata Database 15.10 and later systems.
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 Session identifier in which the query is running
Snapshot CPU Skew CPU skew during the last sample
Snapshot I/O Skew I/O skew during the last sample
Spool Spool space the query requires
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.
Start Time that the query started running on Teradata Database
State Text describing the current state of the query
State Icon Icon representing the current state of the query
System Throttle Delay Indicates whether any requests were delayed due to a system throttle
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
Utility Throttle Delay Indicates whether any requests were delayed due to a utility throttle
Virtual Partition Name of the virtual partition to which the workload belongs, for a SLES 11 system
Workload Workload to which the query belongs
Workload Throttle Delay Indicates whether any requests were delayed due to a workload throttle

By Throttle

This tab displays all queries currently included in a throttle counter. A query that is included in a throttle counter might still be executing; it is delayed only if the throttle limit is exceeded.

Metric Description
Blocking Count Number of consecutive times a session has blocked at least one other session
Flex Throttle Eligible Indicates that the query is running in a workload that has flex throttles enabled for the current state. Only applicable to Teradata Database 16.0 and later and a SLES EDW system.
Host ID Host identifier or LAN identifier associated with the PE that processed the login request for the session
IFP ID Identifier of the parsing engine vproc that initiated the request
Overridable Indicates whether the query can be aborted or released
Request Request number associated with the delayed request or session
Throttle Name Name of the throttle managing the query
Session ID Session identifier in which the query is running
Throttle Type Type of throttle impacting the query
Time Held The total number of seconds the request has been held
Username Name of the user who submitted the query

Throttle Counts

This tab lists all currently active throttles and their concurrency limits. A throttle might report queries as delayed even if its own concurrency limit is not met; this could occur due to the presence of other applicable throttles rather than because the throttle has placed queries in the delay queue itself.

Metric Description
Active Query Count Number of active requests
Delayed Query Count Number of delay requests
Limit Concurrency limit set by the throttle
Throttle Name Name of the active throttle
Throttle Type Type of throttle impacting the query