MonitorVirtualSummary Syntax Elements - Teradata VantageCloud Lake

Lake - Monitor Resources and Performance

Deployment

VantageCloud

Edition

Lake

Product

Teradata VantageCloud Lake

Release Number

Published

February 2025

ft:locale

en-US

ft:lastEdition

2025-11-21

dita:mapPath

wyu1683671641248.ditamap

dita:ditavalPath

pny1626732985837.ditaval

dita:id

wyu1683671641248

AMPAvgCPU: Average % CPU usage (CPUUse) of all online AMPs in the configuration.; Assuming n is the number of online AMPs in the configuration, AMPAvgCPU is computed from CPUUse data as:; (CPUUse 1+ ... + CPUUse n) / n; This value is NULL if certain conditions apply, see usage notes.
AMPAvgDisk: Average physical disk usage (DiskUse) of all online AMPs in the configuration.; Assuming n is the number of online AMPs in the configuration, AMPAvgDisk is computed from DiskUse data as:; (DiskUse 1+ ... + DiskUse n) / n; This value is NULL if certain conditions apply, see usage notes.
AMPAvgDiskIO: Average physical disk DiskReads and DiskWrites of all online AMPs in the configuration.; Assuming n is the number of online AMPs in the configuration, AMPAvgDiskIO is computed from DiskReads and DiskWrites data as:; (DiskReads 1+ DiskWrites 1+ ... + DiskReads 1+ DiskWrites n) / n; This value is NULL if certain conditions apply, see usage notes.
HiCPUAMPUse: Highest CPUUse percentage associated with any online AMP.; This value is NULL if certain conditions apply, see usage notes.
HiDiskAMP: Highest DiskUse percentage associated with any online AMP.; This value is NULL if certain conditions apply, see usage notes.
HiDiskAMPIO: Highest DiskReads and DiskWrites value associated with any online AMP.; This value is NULL if certain conditions apply, see usage notes.
HiCPUAMPNo: Vproc number (VprocNo) of an AMP with CPUUse equal to the value reported as HiCPUAMPUse.; This value is NULL if certain conditions apply, see usage notes.
HiDiskAMPNo: Number of an AMP with DiskUse equal to the value reported as HiDiskAMP.; This value is NULL if certain conditions apply, see usage notes.
HiDiskAMPIONo: Number of an AMP with the highest DiskReads and DiskWrites equal to the value reported as HiDiskAMPIO.; This value is NULL if certain conditions apply, see usage notes.
HiCPUAMPProc: ID of the node responsible for managing the AMP reported as HiCPUAMPNo.; This value is computed as the module number within a cabinet plus the cabinet number times 10000. For example, a node #123 on cabinet #4 returns an INTEGER value of 40123.; This value is NULL if certain conditions apply, see usage notes.
HiDiskAMPProc: ID of the node responsible for managing the AMP reported in HiDiskAMPNo.; This value is computed as the module number within a cabinet plus the cabinet number times 10000. For example, a node #123 on cabinet #4 returns an INTEGER value of 40123.; This value is NULL when HiDiskAMPNo is NULL.
HiDiskAMPIOProc: ID of the node responsible for managing the AMP reported in HiDiskAMPIONo.; This value is computed as the module number within a cabinet plus the cabinet number times 10000. For example, a node #123 on cabinet #4 returns an INTEGER value of 40123.; This value is NULL when HiDiskAMPIONo is NULL.
LoCPUAMPUse: Lowest CPUUse percentage associated with any online AMP.; This value is NULL if certain conditions apply, see usage notes.
LoDiskAMP: Lowest DiskUse percentage associated with any online AMP.; This value is NULL if certain conditions apply, see usage notes.
LoDiskAMPIO: Lowest DiskReads and DiskWrites number associated with any online AMP.; This value is NULL if certain conditions apply, see usage notes.
LoCPUAMPNo: Vproc number (VprocNo) of an AMP with CPUUse equal to the value reported as LoCPUAMPUse.; This value is NULL if certain conditions apply, see usage notes.
LoDiskAMPNo: Number of an AMP with DiskUse equal to the value reported as LoDiskAMP.; This value is NULL if certain conditions apply, see usage notes.
LoDiskAMPIONo: ID of an AMP with lowest DiskReads and DiskWrites equal to the value reported as LoDiskAMPIO.; This value is NULL if certain conditions apply, see usage notes.
LoCPUAMPProc: ID of the node responsible for managing the AMP reported as LoCPUAMPNo.; This value is computed as the module number within a cabinet plus the cabinet number times 10000. For example, a node #123 on cabinet #4 returns an INTEGER value of 40123.; This value is NULL if certain conditions apply, see usage notes.
LoDiskAMPProc: ID of the node responsible for managing the AMP reported as LoDiskAMPNo.; This value is computed as the module number within a cabinet plus the cabinet number times 10000. For example, a node #123 on cabinet #4 returns an INTEGER value of 40123.; This value is NULL when LoDiskAMPNo is NULL.
LoDiskAMPIOProc: ID of the node responsible for managing the AMP reported as LoDiskAMPIONo.; This value is computed as the module number within a cabinet plus the cabinet number times 10000. For example, a node #123 on cabinet #4 returns an INTEGER value of 40123.; This value is NULL when LoDiskAMPIONo is NULL.
PEAvgCPU: Average CPUUse for all online PEs in the configuration.; This value is NULL if certain conditions apply, see usage notes.
HiCPUPEUse: Highest CPUUse percentage associated with any online PE.; This value is NULL if certain conditions apply, see usage notes.
LoCPUPEUse: Lowest CPUUse percentage associated with any online PE.; This value is NULL when LoCPUPEUse is NULL.
HiCPUPENo: Vproc number (VProcNo) of a PE with CPUUse equal to the value reported as HiCPUPEUse.; This value is NULL if certain conditions apply, see usage notes.
LoCPUPENo: Vproc number (VProcNo) of a PE with CPUUse equal to the value reported as LoCPUPEUse.; This value is NULL if certain conditions apply, see usage notes.
HiCPUPEProc: ID of the node responsible for managing the PE reported in HiCPUPENo.; This value is computed as the module number within a cabinet plus the cabinet number times 10000. For example, a node #123 on cabinet #4 returns an INTEGER value of 40123.; This value is NULL when HiCPUPENo is NULL.
LoCPUPEProc: ID of the node responsible for managing the PE reported as LoCPUPENo.; This value is computed as the module number within a cabinet plus the cabinet number times 10000. For example, a node #123 on cabinet #4 returns an INTEGER value of 40123.; This value is NULL if certain conditions apply, see usage notes.
SessionCnt: Total number of sessions logged onto the system, typically equal to the sum of the SessLogCount values for all PEs.; This value is NULL if certain conditions apply, see usage notes.
SesMonitorSys: Sets the maximum acceptable age of collected session-level data in memory to the PM/API application or end user.; The global rate is the default collection rate for all MONITOR sessions. If the value is set to zero, the collection capability is disabled.
SesMonitorLoc: Sets the maximum acceptable age of collected session-level data in memory for an individual Monitor partition session that submits a MONITOR SESSION request.; This rate is initiated within a MONITOR session and may update session-level data within the system. If the value is zero, this allows SesMonitorSys to override the current local rate for that session.
ResLogging: Interval in seconds at which resource usage data is written to one or more active resource usage database tables.
ResMonitor: Interval in seconds at which all resource usage data is collected in memory for reporting using the PM/API.
ReleaseNum: Release number of the running database software (for example, 15.00.00.00).; This value is supplied by the database.
Version: Version number of the running database software (for example, 15.00.00.00).; This value is supplied by the database.