MonitorWD Example - Teradata Vantage

Teradata® VantageCloud Lake

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
Language
English (United States)
Last Update
2024-04-03
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905
SELECT * FROM TABLE (MonitorWd()) AS t2 where vpid=102 and vprtype='amp';
 *** Query completed. One row found. 43 columns returned.
 *** Total elapsed time was 1 second.
                 WDId            0
                 PPId       0
                 PGId     254
                 AGId       0
               RelWgt       0
             NumProcs          454
              VprType  AMP
            QWaitTime   0.00000000000000E 000
         QWaitTimeMax   0.00000000000000E 000
           CpuUserPct   0.00000000000000E 000
      WorkMsgMaxDelay   0.00000000000000E 000
     WorkTypeInUseMax            0
     WorkTimeInUseAvg   0.00000000000000E 000
              IODelay   1.60000000000000E 001
          IODelayTime   1.19968000000000E 005
         PhysicalRead   0.00000000000000E 000
       PhysicalReadKB   0.00000000000000E 000
        PhysicalWrite   1.60000000000000E 001
      PhysicalWriteKB   6.56000000000000E 002
          LogicalRead   8.00000000000000E 000
        LogicalReadKB   2.56000000000000E 002
         LogicalWrite   8.00000000000000E 000
       LogicalWriteKB   2.56000000000000E 002
          ExtraField1   0.00000000000000E 000
          ExtraField2   0.00000000000000E 000
          ExtraField3   0.00000000000000E 000
          ExtraField4   0.00000000000000E 000
                 VPId     102
               WaitIO   5.80000000000000E 001
            WaitOther   7.78500000000000E 005
          CPURunDelay   2.98000000000000E 002
          IOSubmitted   1.60000000000000E 001
        IOSubmittedKB   1.48000000000000E 002
          IOCompleted   1.60000000000000E 001
        IOCompletedKB   1.48000000000000E 002
  IOCriticalSubmitted   0.00000000000000E 000
IOCriticalSubmittedKB   0.00000000000000E 000
        DecayLevel1IO   0.00000000000000E 000
        DecayLevel2IO   0.00000000000000E 000
       DecayLevel1CPU   0.00000000000000E 000
       DecayLevel2CPU   0.00000000000000E 000
  TacticalExceptionIO   0.00000000000000E 000
 TacticalExceptionCPU   0.00000000000000E 000