- VprocNo
- ID of an AMP (that is, a set of disks and the associated tasks or processes that, in combination, make up the AMP), PE or TVS vproc.
- VprocType
- Type of vproc:
- AMP
- PE
- MISC
- Status
- Status of the node, AMP, PE, or TVS vproc associated with this record:
- U = Up/online.
- D = Down/offline.
- ProcId
- ID associated with a node.
- ClusterNo
- Number that identifies the compute cluster to which this AMP is assigned.
- SessLogCount
- Number of current sessions logged to this PE. A logged on session is either a session whose logon request was delivered to this PE, or a session that was switched to this PE following its logon.
- SessRunCount
- Number of current sessions whose Initiate Requests (TSR messages) are addressed to this vproc. For example:
- PEs have a SessRunCount that includes all the Teradata SQL and MONITOR sessions logged on to that PE.
- AMPs may have a nonzero SessRunCount, because AMPs receive TSR messages from FastLoad or MultiLoad logons.
- CPUUse
- % of CPU usage not spent being idle.
- PctService
- % of CPU resources spent in PDE user service processing.
- PctAMPWT
- % of CPU resources used by either the AMP Worker Task (Partition 11) or by the TVS Task (Partition 31) depending on the type of vproc this record represents.
- DiskUse
- % of disk usage per AMP. This value is computed from the ResUsageSvdsk table data:
- DiskReads
- Total number of physical disk reads per AMP during the collection period.
- DiskWrites
- Total number of physical disk writes per AMP during the collection period.
- DiskOutReqAvg
- Average number of outstanding disk requests.
- PctParser
- This field is obsolete and returns zero or NULL.
- PctDispatcher
- % of CPU resources spent in PE Dispatcher processing.
- HstBlkRds
- Number of message blocks (one or more messages sent in one physical group) received from all clients.
- HstBlkWrts
- Number of message blocks (that is, one or more messages sent in one physical group) sent to all hosts.
- NetReads
- Number of Reads from the BYNET to the vproc.
- NetWrites
- Number of messages written from the AMP, PE, or vproc to the BYNET during the collection period.
- NVMemAllocSegs
- Value is computed from ResUsageSvpr table data using the IoRespMax field. The IoRespMax is the maximum I/O response time in milliseconds. That is, the number of operations for each AMP vproc on that node.