17.05 - ResNode 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 reports generated by the ResNode, the ResOneNode, the ResNodebyNode, and the ResNodeByGroup macros, output the following.

The following table describes the statistics columns, after the Date and Time columns, in the ResNode output report.

Statistics columns Description
1 through 3 CPU usage.
4 through 8 Logical device interface.
9 through 14 Memory interface.
15 through 17 Net interface.
18 and 19 General node process scheduling.

The following table describes the statistics columns, after the Date and Time columns, in the ResOneNode output report.

Statistics columns Description
1 and 2 CPU usage.
3 through 6 Logical device interface.
7 through 11 Memory interface.
12 through 14 Net interface.
15 and 16 General node process scheduling.

The following table describes the statistics columns, after the Date and Time columns, in the ResNodebyNode output report.

Statistics columns Description
1 and 2 CPU usage.
3 through 6 Logical device interface.
7 through 12 Memory interface.
13 through 15 Net interface.
16 and 17 General node process scheduling.

The following table describes the statistics columns, after the Date and Time columns, in the ResNodeByGroup output report.

Statistics columns Description
1 GroupId as defined in the associated view as a grouping of one or more nodes.
2 and 3 CPU usage.
4 through 7 Logical device interface.
8 through 12 Memory interface.
13 through 15 Net interface.
16 and 17 General node process scheduling.

The following table describes the statistics columns in all output reports (with the exception of ResNodeByNode, which has a NodeID column, and ResNodeByGroup, which has a GroupId column).

Column… Reports the…
CPU Bsy % percent of time the CPUs are busy, based on average CPU usage per node.
CPU Eff % (ResNode report) parallel efficiency of node CPU usage.

Parallel efficiency is the total percent of time nodes are busy. It is the average for all nodes of total busy divided by the total busy time of the busiest node.

WIO % percent of time the CPUs are idle and waiting for completion of an I/O operation.
Ldv IO KBs /Sec average number of logical device read and write KB per second.
Ldv Eff % (ResNode report) parallel efficiency of the logical device (disk) I/Os. It is the average number of I/Os per node divided by the number of I/Os performed by the node with the most I/Os.
P+S % of IO KBs percent of logical device read and write KB that are for paging purposes.
Read % of IO KBs percent of logical device read and write KB that are reads.
Ldv KB / IO average size of a non-swap/page logical device read or write.
Fre Mem % percent of memory that is unused.
TPtP IOs /Sec total point-to-point net reads and writes per second, per node.
TMlt IOs /Sec total multicast (broadcast or merge) net reads and writes per second, per node.
Net Rtry % percent of transmission attempts that resulted in retries.
Prc Blks / Sec number of times per second, per node, that processes other than message and timer waits are blocked.
ms /Blk average time, in milliseconds, spent waiting for a blocked process other than message and timer waits.
Net Rx % Bsy percent of time the network was busy either receiving.
Net Tx % Bsy % percent of time the network was busy transmitting.

ResNode Examples

exec resNode(,,,);

exec resOneNode(,,,,);

exec resNodeByNode(,,,,,);

exec resNodeByGroup(,,,);