MonitorPhysicalResource Example - 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
SELECT t2.* from table (MonitorPhysicalResource()) as t2;

 *** Query completed. One row found. 28 columns returned.
 *** Total elapsed time was 1 second.

              ProcId   10001
              Status   U
            AmpCount   4
             PECount   2
              CPUUse   1.00000000000000E 002
         PrcntKernel   0.00000000000000E 000
        PrcntService   2.34804329725229E 000
           PrcntUser   9.76519567027477E 001
             DiskUse   9.08909242298085E 000
           DiskReads   8.48000000000000E 002
          DiskWrites   6.56500000000000E 003
       DiskOutReqAvg   1.58467943380516E-001
             NetAUse   0.00000000000000E 000
             NetBUse   0.00000000000000E 000
            NetReads   0.00000000000000E 000
           NetWrites   0.00000000000000E 000
              CICUse   0.00000000000000E 000
            HstBlkRds  2.00000000000000E 000
           HstBlkWrts  1.00000000000000E 000
         MemAllocates  0.00000000000000E 000
        MemAllocateKB  1.28000000000000E 002
          MemFailures  0.00000000000000E 000
            MemAgings  0.00000000000000E 000
        NVMemAllocate  0.00000000000000E 000
       NVMemAllocSegs  0.00000000000000E 000
          NVMemAgings  0.00000000000000E 000
               NetAUp  U
               NetBUp  U
           VProcCount  12
    SegSizeMBperVProc  1109
SegCurrAvailMBperVProc  924