Identify Space Problems Using Viewpoint | Teradata Vantage - 17.00 - 17.05 - Identifying Space Problems Using Viewpoint Space Usage Portlet - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
17.05
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
rgu1556127906220.ditamap
dita:ditavalPath
lze1555437562152.ditaval

Use the Space Usage portlet to track detailed space usage parameters, including available space, current usage, and peak usage for each space type, by database or user.

  1. Select the system you want to investigate and click Next.
  2. In the selection menu, select Database: By most space and click Next.
  3. Use the Database Total view to display perm space usage for all databases that have assigned perm space. The following columns may indicate perm space problems.
    Parameter Description Actions
    Current Perm% Percentage of available perm space currently being used by each user and database. Consider allocating additional perm space to any user or database when it reaches 90% perm space usage. See Reallocating Perm Space to Resolve Space Issues.
    Peak Perm% The highest percentage of total available perm used by each user and database since the last reset (default 24 hours).
    Current Perm Skew% A measure of how the perm space for a database distributes across all AMPs. Higher percentages indicate uneven distribution. A high perm skew percentage indicates that one or more tables in the database is skewed, that is, it has a poorly designed primary index.
    If you think there is a space problem, you can click on a database name to display the Details view, which shows the current perm, peak perm, and skew% for each table in the database.
  4. Use the Users Over 85% Spool view to display any users that have exceeded the safe range of spool usage since the last reset.
    In some cases excess spool usage may be the result of poorly constructed queries rather than an actual shortage of spool.
    Parameter Description Actions
    Current Spool% Percentage of available spool space currently being used by each user and database (list) Monitor regularly to determine whether certain users regularly exceed 85% spool.
    • Use Query Monitor to track query activity for users exceeding the limit, to determine whether the excessive spool usage is caused by poorly constructed queries.
    • Increase the spool space limit for users who need spool by modifying the user or applicable profile definition. See Increasing the Spool Space Limit for a User.
    Peak Spool% Largest percentage of available spool space recently used by each listed user and database since the last reset (default 24 hours).