MonitorAMPLoad Example - Teradata VantageCloud Lake

This example shows the data reported in statement 3 of MONITOR AWT RESOURCE.

SELECT * FROM TABLE (MonitorAMPLoad()) AS t1;

*** Query completed. 4 rows found. 6 columns returned.
*** Total elapsed time was 1 second.

            VprocNo       0
      AvailableAWTs           49
          InUseAWTs            2
           MsgCount            0
         DQMsgCount          737
AvailableAWTsForAll           55
            VprocNo       1
      AvailableAWTs           49
          InUseAWTs            1
           MsgCount            0
         DQMsgCount          765
AvailableAWTsForAll           56
            VprocNo       2
      AvailableAWTs           49
          InUseAWTs            1
           MsgCount            0
         DQMsgCount          695
AvailableAWTsForAll           56
            VprocNo       3
      AvailableAWTs           48
          InUseAWTs            2
           MsgCount            0
         DQMsgCount          863
AvailableAWTsForAll           56