ResVdskByNode Macros Output - Advanced SQL Engine - Teradata Database

Resource Usage Macros and Tables

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
fwg1557098454552.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1099
lifecycle
previous
Product Category
Teradata Vantageā„¢

The following table describes the statistics columns in all output reports (with the exception of ResVdskByNode, which has the NodeID column, and ResVdskByGroup, which has the NodeType column).

Column... Reports the...
Read Cnt / Sec average number of logical device reads per second.
Write Cnt / Sec average number of logical device writes per second.
Rd KB / I/O average number of KB per logical device read.
Wrt KB / I/O average number of KB per logical device write.
Avg I/O Resp average response time for a logical device read or write in seconds.
Out Rqst Time % percent of time there are outstanding requests.
Max Concur Rqsts maximum number of concurrent requests during the log period.

ResVdskByNode Examples

exec resVdskByNode(,,,,,);

exec resVdskOneNode(,,,,);

exec resVdskByGroup(,,,);