17.05 - ResVdskByNode Macros Output - Teradata Database

Teradata Vantageā„¢ - Resource Usage Macros and Tables

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Administration
User Guide
featnum
B035-1099-170K

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(,,,);