ResMemMgmtByNode Macros Output - 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ā„¢

The reports generated by the ResMemMgmtByNode, the ResMemMgmtOneNode, and the ResMemByGroup macros, output the following:

Column... Reports the...
% Mem Free current snapshot of the percent of memory that is unused.
Text Alocs/ Sec average number of text page allocations per second.

text pages are allocations of memory for code that is not associated with system-level overhead tasks.

VPR Alocs/ Sec average number of vproc-specific page and segment allocations per second on a node.
KB/ VPR Aloc average KB per vproc-specific page and segment allocation on a node.
Aloc Fail % percent of memory allocation attempts that failed.
Ages/ Sec average number of times memory pages were aged out per second.
# Proc Swp current number of processes that are swapped out.
Page Drops/ Sec average number of text pages dropped from memory per second.

Page drops are text pages that are dropped from memory to increase the amount of available memory.

Page Reads KBs/ Sec average number of memory paging KB, read from disk per second.

Page reads include both memory text pages and task context pages, such as scratch, stack, etc.

Page Writes/ Sec average number of memory pages written to disk per second.

Page writes include only task context pages.

Swap Drops/ Sec average number of disk segments dropped from memory per second.

Swap drops include all disk segments dropped from memory because their ancestor processes were swapped out.

Swap Reads/ Sec average number of disk segments reread back into memory, after being swapped, out per second.

Swap reads include all reread disk segments that had been previously dropped from memory because their ancestor processes were swapped out.

KB/Swp Drp average size, in KB, of disk segments dropped from memory because their ancestor processes were swapped out.
KB/Swp Rd average size, in KB, of reread disk segments that had been previously dropped from memory because their ancestor processes were swapped out.
P+S Drops/ Sec average number of paged, swapped page, or segment drops per second.

This statistic includes both the memory text pages (Pg Drps/ Sec), and the disk segments (Swp Drps/ Sec), that were dropped.

P+S Read KBs/ Sec average total number of paged, swapped page, or segment read KB, per second. Includes both the memory text pages and task context pages (Pg Rds/ Sec), and the disk segments (Swp Rds/ Sec), reread back into memory after being swapped out.
P+S Writes/ Sec average total number of paged, swapped page, or segment writes per second.
P+S IO KB % percent of logical device input and output KB done for paging or swapping inputs and outputs.

The NodeID column only appears in the ResMemMgmtByNode output report.

The GroupID column only appears in the ResMemByGroup output report.

ResMemMgmtByNode Examples

exec resMemMgmtByNode(,,,,,);

exec resMemMgmtOneNode(,,,,);

exec resMemByGroup(,,,);