Identifying Space Problems Using Viewpoint - Teradata Database

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” on page 177.
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. To identify skewed tables, see “Finding and Fixing Skewed Tables Using Viewpoint” on page 178.

Note: 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.

Note: 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” on page 178.
Peak Spool%	Largest percentage of available spool space recently used by each listed user and database since the last reset (default 24 hours).