17.05 - Memory: PDE Kernel Memory Usage Columns - Teradata Database

Teradata Vantageā„¢ - Resource Usage Macros and Tables

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Administration
User Guide
featnum
B035-1099-170K
Column Name Mode Description Data Type
KernMemInuseKB track Amount of Kernel memory in use by PDE in kilobytes.
The ResSpmaView has an alias field called TotalKernMemInuseKB, derived from: KernMemInuseKB + SegMDLInuseKB
FLOAT
SegMDLInuseKB track Total memory in use by segment MDLs. An MDL is an internal PDE data structure needed by the operation of the segment subsystem.

The pages associated with MDL segments are pinned in memory for bynet DMA.

The ResSpmaView has an alias field called TotalKernMemInuseKB, derived from: KernMemInuseKB + SegMDLInuseKB
FLOAT
SegMaxAvailMB track Current MB of maximum PDE segment files available. FLOAT
SegInuseMB track Current MB of PDE segment files in use. FLOAT
SegCacheMB track Current MB of segment cache. FLOAT
SegMDLAlloc count Number of segments of all sizes allocated for the MDL pool during this period. FLOAT
SegMDLFree count Number of dirty segments of all sizes freed from the MDL pool during this period. FLOAT
SegMDLRelease count Number of clean segments of all sizes freed from the MDL pool during this period. FLOAT
SegMDLRecycle count Number of segments of all sizes recycled to the MDL pool during this period. FLOAT
SegMDLAllocKB count KB of segments of all sizes allocated for the MDL pool during this period. FLOAT
SegMDLFreeKB count KB of dirty segments of all sizes freed from the MDL pool during this period. FLOAT
SegMDLReleaseKB count KB of clean segments of all sizes freed from the MDL pool during this period. FLOAT
SegMDLRecycleKB count KB of segments of all sizes recycled to the MDL pool during this period. FLOAT
FsgCacheKB track Allocated memory for FSG cache. This includes the memory allocated for TIM (VHCacheKB). FLOAT