Resource Usage Data | Resource Usage Macros/Tables | Teradata Vantage - 17.20 - Overview of Resource Usage Data - Analytics Database - Teradata Database

Teradata Vantage™ - Resource Usage Macros and Tables - 17.20

Product
Analytics Database
Teradata Database
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2022-10-17
dita:mapPath
efj1628112349534.ditamap
dita:ditavalPath
qkf1628213546010.ditaval

Resource usage data is stored in system tables and views in the DBC database. Teradata macros generate reports that display the data.

To load the resource usage views and macros, you can run the Database Initialization Program (dip) script, DIPRUM. For more information on DIPRUM, see Teradata Vantage™ - Database Utilities, B035-1102.

You can run DIP scripts one at a time or all at once by running DIPALL. DIP scripts, such as DIPRUM and DIPSYSFNC, can be executed in any order.

As with other database data, you can access resource usage data using SQL if you have the proper privileges. You can also write your own queries or macros on resource usage data.

The following table lists the topics covered by resource usage data.

Resource usage data covers … Which includes …
BYNET traffic on a node point-to-point messaging, broadcast messaging, and merge activities.
client-to-server traffic data for each communication link.
CPU utilization overhead, user service, and time of session execution.
storage device traffic the number of reads/writes and amount of data transferred as seen from the storage driver.
pdisk device traffic pdisk I/O, cylinder allocation, and migration statistics.
vdisk device traffic all the cylinders allocated by an AMP (which can come from any pdisks in the clique).
Priority Scheduler information
  • Data by Priority Scheduler WD.

    Priority Scheduler is managed by TASM and is configured using the Teradata Viewpoint workload management portlets. For more information on those portlets, see Teradata® Viewpoint User Guide, B035-2206.

AMP Worker Task information AMP Worker Task statistics.
memory management activity memory allocation.