Examples: Using MonitorAMPLoadSV - Teradata Vantage

Example: Using MonitorAMPLoadSV with Default Query

SELECT * from MonitorAMPLoadSV() AS dt;

The output is similar to this. The output shown is abbreviated.

            VprocNo       0
      AvailableAWTs           48
          InUseAWTs            3
           MsgCount            0
         DQMsgCount        26745
AvailableAWTsForAll           55
            VprocNo       1
      AvailableAWTs           49
          InUseAWTs            1
           MsgCount            0
         DQMsgCount        27138
AvailableAWTsForAll           56
            VprocNo       2
      AvailableAWTs           49
          InUseAWTs            1
           MsgCount            0
         DQMsgCount        25527
AvailableAWTsForAll           56
            VprocNo       3
      AvailableAWTs           49
          InUseAWTs            1
           MsgCount            0
         DQMsgCount        25948
AvailableAWTsForAll           56
            VprocNo       4
      AvailableAWTs           49
          InUseAWTs            1
           MsgCount            0
         DQMsgCount        26847
AvailableAWTsForAll           56
            VprocNo       5
      AvailableAWTs           49
          InUseAWTs            1
           MsgCount            0
         DQMsgCount        27019
.
.
.

            VprocNo   10023
      AvailableAWTs           50
          InUseAWTs            0
           MsgCount            0
         DQMsgCount        12363
AvailableAWTsForAll           56

Example: Using MonitorAMPLoadSV with Detailed View Query

The detailed view adds the Type, Id, Name, and Group columns to identify the source of these metrics.

SELECT * from MonitorAMPLoadSV(
    USING
    details('1')
) 
AS dt;

The output is similar to this. The output shown here is abbreviated.

            VprocNo      0
      AvailableAWTs          48
          InUseAWTs           3
           MsgCount           0
         DQMsgCount       26745
AvailableAWTsForAll          55
               Type primary cluster
                 Id pog-784f2c715b
               Name 1
              Group ?
            VprocNo      1
      AvailableAWTs          49
          InUseAWTs           1
           MsgCount           0
         DQMsgCount       27138
AvailableAWTsForAll          56
               Type primary cluster
                 Id pog-784f2c715b
               Name 1
              Group ?
            VprocNo      2
      AvailableAWTs          49
          InUseAWTs           1
           MsgCount           0
         DQMsgCount       25527
AvailableAWTsForAll          56
               Type primary cluster
                 Id pog-784f2c715b
               Name 1
              Group ?
            VprocNo      3
      AvailableAWTs          49
          InUseAWTs           1
           MsgCount           0
         DQMsgCount       25948
AvailableAWTsForAll          56
               Type primary cluster
                 Id pog-784f2c715b
               Name 1
              Group ?
            VprocNo      4
      AvailableAWTs          49
          InUseAWTs           1
           MsgCount           0
         DQMsgCount       26847
AvailableAWTsForAll          56
               Type primary cluster
                 Id pog-784f2c715b
               Name 1
              Group ?
            VprocNo      5
      AvailableAWTs          49
          InUseAWTs           1
           MsgCount           0
         DQMsgCount       27019
AvailableAWTsForAll          56
               Type primary cluster
                 Id pog-784f2c715b
               Name 1
              Group ?
.
.
.
            VprocNo  10023
      AvailableAWTs          50
          InUseAWTs           0
           MsgCount           0
         DQMsgCount       12446
AvailableAWTsForAll          56
               Type compute cluster
                 Id sys-784f2c8afd_pog_784f2c715b_group_1_cog_1_setwlc
              Name 1-setwlc
              Group pog_784f2c715b_group_1