ResNode Macros Output - Advanced SQL Engine - Teradata Database

Resource Usage Macros and Tables

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
dep1592878989156.ditamap
dita:ditavalPath
dep1592878989156.ditaval
dita:id
B035-1099
lifecycle
previous
Product Category
Teradata Vantage™

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