Memory: PDE Kernel Memory Usage Columns - Analytics Database - Teradata Vantage

Resource Usage Macros and Tables

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-10-30
dita:mapPath
efj1628112349534.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
wqp1472240716284
lifecycle
latest
Product Category
Teradata Vantageā„¢
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