Space Accounting Columns for ResUsageSvpr Table - Advanced SQL Engine - Teradata Database

Resource Usage Macros and Tables

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
dep1592878989156.ditamap
dita:ditavalPath
dep1592878989156.ditaval
dita:id
B035-1099
lifecycle
previous
Product Category
Teradata Vantageā„¢

Previously, the Teradata accounting system assumed an even distribution of rows to AMPs. The database and user space limits were set at the AMP level to the defined maximum limit values divided by the number of AMPs in the system. Space was managed and monitored at the AMP level.

Some features now allow tables on subsets of AMPs. The space accounting and space management infrastructure now manages the space limits at a global or system level and augments the AMP-level space management. These enhancements are referred to as global space accounting.

These columns report statistics for space accounting.

Column Name Mode Description Data Type
SpaceProactiveAllocs count Total number of proactive allocations made in the AMP during the logging period. This field is populated by the spalocal task. FLOAT
SpaceGroupAllocs count Total number of group allocations initiated in the AMP during the logging period. This field is populated by the spaglobal task. FLOAT
SpaceMsgsCnt count Total number of allocations or de-allocation messages processed by the space accounting task managing the system limit for a database or user. This field is populated by the spaglobal task. FLOAT
SpaceAllocated count Total number of bytes of space allocated to the AMP. This field is populated by the spalocal task. FLOAT
SpaceDeallocated count Total number of bytes of space de-allocated from the AMP. This field is populated by the spalocal task. FLOAT