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

Teradata Vantage™ - Resource Usage Macros and Tables

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
June 2020
category
Administration
User Guide
featnum
B035-1099-170K

Resource usage data is stored in system tables and views in the DBC database. Macros installed with Teradata Database 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.