15.10 - MonitorVirtualSummary - Teradata Database

Teradata Database Application Programming Reference

prodname
Teradata Database
vrm_release
15.10
category
Programming Reference
featnum
B035-1090-151K

Collects global summary information on system utilization.

REPLACE FUNCTION SYSLIB.MonitorVirtualSummary()
 RETURNS TABLE 
   (AMPAvgCPU FLOAT,
    AMPAvgDisk FLOAT, 
    AMPAvgDiskIO FLOAT, 
    HiCPUAMPUse FLOAT, 
    HiDiskAMP FLOAT,
    HiDiskAMPIO FLOAT, 
    HiCPUAMPNo SMALLINT, 
    HiDiskAMPNo SMALLINT, 
    HiDiskAMPIONo SMALLINT, 
    HiCPUAMPProc SMALLINT, 
    HiDiskAMPProc SMALLINT, 
    HiDiskAMPIOProc SMALLINT,
    LoCPUAMPUse FLOAT,
    LoDiskAMP FLOAT,
    LoDiskAMPIO FLOAT, 
    LoCPUAMPNo SMALLINT, 
    LoDiskAMPNo SMALLINT,
    LoDiskAMPIONo SMALLINT,
    LoCPUAMPProc SMALLINT, 
    LoDiskAMPProc SMALLINT,
    LoDiskAMPIOProc SMALLINT,
    PEAvgCPU FLOAT, 
    HiCPUPEUse FLOAT, 
    LoCPUPEUse FLOAT, 
    HiCPUPENo SMALLINT, 
    LoCPUPENo SMALLINT, 
    HiCPUPEProc SMALLINT,
    LoCPUPEProc SMALLINT, 
    SessionCnt FLOAT, 
    SesMonitorSys SMALLINT, 
    SesMonitorLoc SMALLINT, 
    ResLogging SMALLINT, 
    ResMonitor SMALLINT, 
    ReleaseNum CHAR(30) CHARACTER SET LATIN, 
    Version CHAR(32) CHARACTER SET LATIN
   )
          .
          .
          .
;

The MonitorVirtualSummary function provides similar functionality to the PMPC MONITOR VIRTUAL SUMMARY request. For information about this interface, see “MONITOR VIRTUAL SUMMARY” on page 185.

 

Column Name

Description

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:

(CPUUse1 + ... + CPUUsen) / n

This value is NULL if certain conditions apply, see “Usage Notes” on page 185 for more information.

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:

(DiskUse1 + ... + DiskUsen) / n

This value is NULL if certain conditions apply, see “Usage Notes” on page 185 for more information.

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:

(DiskReads1 + DiskWrites1 + ... + DiskReads1 + DiskWritesn) / n

This value is NULL if certain conditions apply, see “Usage Notes” on page 185 for more information.

HiCPUAMPUse

Highest CPUUse percentage currently associated with any online AMP.

This value is NULL if certain conditions apply, see “Usage Notes” on page 185 for more information.

HiDiskAMP

Highest DiskUse percentage currently associated with any online AMP.

This value is NULL if certain conditions apply, see “Usage Notes” on page 185 for more information.

HiDiskAMPIO

Highest DiskReads and DiskWrites value currently associated with any online AMP.

This value is NULL if certain conditions apply, see “Usage Notes” on page 185 for more information.

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” on page 185 for more information.

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” on page 185 for more information.

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” on page 185 for more information.

HiCPUAMPProc

ID of the node currently responsible for managing the AMP reported as HiCPUAMPNo.

This value is NULL if certain conditions apply, see “Usage Notes” on page 185 for more information.

HiDiskAMPProc

ID of the node currently responsible for managing the AMP reported in HiDiskAMPNo.

This value is NULL when HiDiskAMPNo is NULL.

HiDiskAMPIOProc

ID of the node currently responsible for managing the AMP reported in HiDiskAMPIONo.

This value is NULL when HiDiskAMPIONo is NULL.

LoCPUAMPUse

Lowest CPUUse percentage currently associated with any online AMP.

This value is NULL if certain conditions apply, see “Usage Notes” on page 185 for more information.

LoDiskAMP

Lowest DiskUse percentage currently associated with any online AMP.

This value is NULL if certain conditions apply, see “Usage Notes” on page 185 for more information.

LoDiskAMPIO

Lowest DiskReads and DiskWrites number currently associated with any online AMP.

This value is NULL if certain conditions apply, see “Usage Notes” on page 185 for more information.

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” on page 185 for more information.

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” on page 185 for more information.

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” on page 185 for more information.

LoCPUAMPProc

ID of the node currently responsible for managing the AMP reported as LoCPUAMPNo.

This value is NULL if certain conditions apply, see “Usage Notes” on page 185 for more information.

LoDiskAMPProc

ID of the node currently responsible for managing the AMP reported as LoDiskAMPNo.

This value is NULL when LoDiskAMPNo is NULL.

LoDiskAMPIOProc

ID of the node currently responsible for managing the AMP reported as LoDiskAMPIONo.

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” on page 185 for more information.

HiCPUPEUse

Highest CPUUse percentage currently associated with any online PE.

This value is NULL if certain conditions apply, see “Usage Notes” on page 185 for more information.

LoCPUPEUse

Lowest CPUUse percentage currently 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” on page 185 for more information.

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” on page 185 for more information.

HiCPUPEProc

ID of the node currently responsible for managing the PE reported in HiCPUPENo.

This value is NULL when HiCPUPENo is NULL.

LoCPUPEProc

ID of the node currently responsible for managing the PE reported as LoCPUPENo.

This value is NULL if certain conditions apply, see “Usage Notes” on page 185 for more information.

SessionCnt

Total number of sessions currently logged onto the system. This value is usually equal to the sum of the SessLogCount values for all PEs.

This value is NULL if certain conditions apply, see “Usage Notes” on page 185 for more information.

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 via the PM/API.

ReleaseNum

Release number of the currently running Teradata Database software (for example, 15.00.00.00).

This value is supplied by Teradata Database.

Version

Version number of the currently running Teradata Database software (for example, 15.00.00.00).

This value is supplied by Teradata Database.

SELECT * FROM TABLE (MonitorVirtualSummary()) AS t1;
 
 *** Query completed. One row found. 35 columns returned.
 *** Total elapsed time was 1 second.
 
      AMPAvgCPU   6.14583333333333E-003
     AMPAvgDisk   4.25000000000000E-002
   AMPAvgDiskIO   8.41250000000000E 001
    HiCPUAMPUse   1.00000000000000E-002
      HiDiskAMP   6.91666666666667E-002
    HiDiskAMPIO   1.12000000000000E 002
     HiCPUAMPNo            3
    HiDiskAMPNo            0
  HiDiskAMPIONo            0
   HiCPUAMPProc           33
  HiDiskAMPProc           33
HiDiskAMPIOProc           33
    LoCPUAMPUse   3.75000000000000E-003
      LoDiskAMP   1.16666666666667E-002
    LoDiskAMPIO   3.90000000000000E 001
     LoCPUAMPNo            6
    LoDiskAMPNo            5
  LoDiskAMPIONo            5
   LoCPUAMPProc           33
  LoDiskAMPProc           33
LoDiskAMPIOProc           33
       PEAvgCPU   4.79166666666667E-002
     HiCPUPEUse   4.79166666666667E-002
     LoCPUPEUse   4.79166666666667E-002
      HiCPUPENo        16383
      LoCPUPENo        16383
    HiCPUPEProc           33
    LoCPUPEProc           33
     SessionCnt   7.00000000000000E 000
  SesMonitorSys           60
  SesMonitorLoc            0
     ResLogging          600
     ResMonitor          600
     ReleaseNum    13.10.00.00
        Version    13.10.00.00