MonitorAWTResource 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 * FROM TABLE (MonitorAWTResource(1,2,3,4)) AS t1;
 *** Query completed. One row found. 30 columns returned.
 *** Total elapsed time was 1 second.
    IntervalCount1            0
    IntervalCount2            0
    IntervalCount3            2
    IntervalCount4            4
       FlowControl            0
   HighAMP1VprocId            2
HighAMP1InUseCount            6
   HighAMP2VprocId            5
HighAMP2InUseCount            4
   HighAMP3VprocId            3
HighAMP3InUseCount            4
   HighAMP4VprocId            1
HighAMP4InUseCount            4
   HighAMP5VprocId            4
HighAMP5InUseCount            3
    LowAMP1VprocId            4
 LowAMP1InUseCount            3
    LowAMP2VprocId            0
 LowAMP2InUseCount            3
    LowAMP3VprocId            5
 LowAMP3InUseCount            4
    LowAMP4VprocId            3
 LowAMP4InUseCount            4
    LowAMP5VprocId            1
 LowAMP5InUseCount            4
        FCVprocId1           -1
        FCVprocId2           -1
        FCVprocId3           -1
        FCVprocId4           -1
        FCVprocId5           -1