Resource Usage Views | ResUsageSvpr Table | Teradata Vantage - 17.05 - Resource Usage Views Overview - 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 provides information for accessing the resource usage views.

Views are the recommended method to access the resource usage table data.

To see the view definitions, execute SHOW VIEW viewname, where viewname is the name of the view whose most recent SQL create text is to be reported. For details on using the SHOW VIEW statement, see Teradata Vantage™ - SQL Data Definition Language Detailed Topics , B035-1184 .

The following views report the table column, GroupId. A homogeneous system requires no changes to use this macro because all the nodes will be assigned to group A. For a coexisting system, however, the values need to be set up when the system is installed or reconfigured so that each type of node is assigned to a specific group ID.

Since each of the views include all the columns for the represented table, the views will be changed whenever the base table columns are changed.

Do not change or delete columns in these views. If the columns are modified, the resource usage macros that use these views may not work properly. You can, however, safely add columns.
View Description
ResCPUUsageByAMPView Describes CPU usage per AMP
ResCPUUsageByPEView Describes CPU usage by each PE
ResSawtView Based on the ResUsageSawt table
ResScpuView Based on the ResUsageScpu table
ResShstView Based on the ResUsageShst table
ResSldvView Based on the ResUsageSldv table
ResSmhmView Based on the ResUsageSmhm table. Reserved for future use.
ResSpdskView Based on the ResUsageSpdsk table
ResSpmaView Based on the ResUsageSpma table
ResSpsView Based on the ResUsageSps table
ResSvdskView Based on the ResUsageSvdsk table
ResSvprView Based on the ResUsageSvpr table.