Teradata Database System Metrics

Teradata Viewpoint User Guide

brand
Analytical Ecosystem
prodname
Teradata Viewpoint
vrm_release
16.00
category
User Guide
featnum
B035-2206-106K

By Database

The selection menu choice By Database makes the following metrics available.
Column Description Type
Current Perm
  • In the Space Usage view: Amount of total permanent disk space the database is currently using
  • In the details view: Amount of total permanent disk space the object is currently using
Number
Current Perm % Percentage of the total permanent disk space the database is currently using (Current Perm divided by Max Perm) Percent
Current Perm Skew % A measure of perm space data distribution across all AMPs for the selected database
A perfectly distributed database (same amount of data on each AMP) has a skew of 0. A database which has all the data on one AMP has a skew of 100.
Percent
Current Spool Amount of total temporary spool space the database is currently using Number
Current Spool % Percentage of total temporary spool space the database is currently using (Current Spool divided by Max Spool) Percent
Current Temp Amount of total temporary space the database is currently using Number
Current Temp % Percentage of total temporary space the database is currently using (Current Spool divided by Max Spool) Percent
Database Creator Name of the user that submitted the Create Database statement String
Effective Perm Space % Percentage of Perm space used on the highest utilized AMP, accounting for the configured skew limit in Teradata Database 16.0 and later Percent
Effective Spool Space % Percentage of Spool space used on the highest utilized AMP, accounting for the configured skew limit in Teradata Database 16.0 and later Percent
Effective Temp Space % Percentage of Temp space used on the highest utilized AMP, accounting for the configured skew limit in Teradata Database 16.0 and later Percent
Max Perm Total amount of permanent disk space available for the database Number
Max Spool Total amount of temporary spool space available for the database Number
Max Temp Total amount of temporary space available for the database Number
Name Database name String
Parent Database Parent database name String
Peak Perm
  • In the Space Usage view: Greatest amount of permanent disk space the database has used
  • In the details view: Greatest amount of permanent disk space the object has used
Number
Peak Perm % Highest percentage of total permanent disk space the database has used (Peak Perm divided by Max Perm) Percent
Perm Skew Limit Permissible skew limit percent above the per-AMP quota of Perm space for a given user/database Number
Peak Spool Greatest amount of temporary spool space the database has used Number
Peak Spool % Highest percentage of total temporary spool space the database has used (Peak Spool divided by Max Spool) Percent
Peak Temp Greatest amount of temporary space the database has used Number
Peak Temp % Highest percentage of total temporary space the database has used (Peak Temp divided by Max Temp) Percent
Skew % A measure of data distribution among the nodes (details view only) Number
Spool Skew Limit Permissible skew limit percent above the per-AMP quota of spool space for a given user/database Number
Temp Skew Limit Permissible skew limit percent above the per-AMP quota of temp space for a given user/database Number
Unused Perm % Percentage of total permanent disk space currently not being used (100% minus Current Perm %) Percent

By Vproc

The selection menu choice By Vproc makes the following metrics available.
Column Description Type
% In Use Percentage of perm space used by the vproc (Current Perm divided by Max Perm) Percent
Allocated Perm Total perm space currently allocated to AMPs for the user/database in Teradata Database 16.0 and later Number
Available Perm Available perm space for this vproc (Max Perm divided by Current Perm) Number
Current Perm Current perm space used by the user. Current perm space depends on the volume of data already stored in the database. Number
Max Perm Maximum perm space used by the user. Maximum perm space depends on the volume of data to be stored in the database in Teradata Database 15.10 and earlier. Number
Vproc ID Vproc number Number