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 .
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 |
|
AMP Worker Task information | AMP Worker Task statistics. |
memory management activity | memory allocation. |