15.10 - Overview of Resource Usage Data - Teradata Database

Teradata Database Resource Usage Macros and Tables

Teradata Database
Release Number
April 2016
English (United States)
Last Update

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 Utilities.

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
  • On SLES 10 or earlier systems, data by Performance Group (PG) from the Priority Scheduler and the ability to report resource usage data by Teradata Active System Management (TASM) workload definitions (WDs).
  • On SLES 11 or later systems, data by Priority Scheduler WD.

    Priority Scheduler is managed by TASM on SLES 11 systems, and is configured using the Teradata Viewpoint workload management portlets. For more information on those portlets, see Teradata Viewpoint User Guide.

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