Resource Usage Views | ResUsageSvpr Table | Teradata Vantage - Resource Usage Views - 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 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.