Memory: PDE Kernel Memory Usage Columns - Advanced SQL Engine - Teradata Database

Resource Usage Macros and Tables

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
fwg1557098454552.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1099
lifecycle
previous
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