17.05 - ResPs 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 in the following sections are sample output reports from the ResPsByNode and ResPsByGroup macros.

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

Statistics columns Description
1 Node ID.
2 pWDId.
3 through 12 Summary of the Priority Scheduler statistics.

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

Statistics columns Description
1 Node type.
2 through 11 Summary of the Priority Scheduler statistics.

The following table describes the statistics columns in all output reports (with the exception of ResSpsByNode, which reports by NodeID columns, and ResSpsByGroup, which reports by NodeType column).

Column... Reports the...
CPU Bsy % percent of time the CPUs are busy, based on average CPU usage per node.
IO Blks Sec number of logical data blocks read or written.
Num Procs average number of tasks of online nodes.
Num Requests number of AMP Worker Task messages or requests that got assigned AMP Worker Tasks to them.
Avg QWait Time average time in milliseconds that work requests waited on an input queue before being serviced.
Max QWait Time maximum time in milliseconds that work requests waited on an input queue before being serviced.
Q Length average number of messages queued for output to the host.
Q Len Max maximum number of messages queued for output to the host.
Avg Svc Time average time in milliseconds that work requests required for service
Max Svc Time maximum time in milliseconds that work requests required for service.

For a complete description of the above columns, see ResUsageSps Table.

ResPs Examples

exec resPsByNode(,,,,,);

exec resPsByGroup(,,,);