resusagespsV | VantageCloud Lake - resusagespsV - Teradata Vantage

Teradata® VantageCloud Lake
Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

Database: td_metric_svc

If you need detailed statistics for each workload definition on the system, use this view to:
  • Get a historical view of workload behavior for utilities and SQL operations.
  • Determine the number of workload requests that are using AMP Worker Task.
  • Examine queue wait and service time numbers to find backed up queries and allocation groups.
  • Determine what workload is responsible for I/O skew.
  • Monitor CPU usage managed by the Priority Scheduler.
  • Identifiy the percent of CPU being used by different workloads.
View Column Data Type Format Comment
Location VARCHAR(2048) UNICODE CASESPECIFIC X(2048) File path in object storage for metric data objects.
path_component_id VARCHAR(8000) UNICODE CASESPECIFIC X(8000) Operational group (primary cluster or compute cluster) ID.
path_collecttimestamp VARCHAR(8000) UNICODE CASESPECIFIC X(8000) Timestamp, in EPOCH timestamp format, this metric data was collected from your database and written to object storage.
path_year VARCHAR(8000) UNICODE CASESPECIFIC X(8000) The year in which the data was logged.
path_month VARCHAR(8000) UNICODE CASESPECIFIC X(8000) The month in which the data was recorded in the table.
path_day VARCHAR(8000) UNICODE CASESPECIFIC X(8000) The day on which the data was recorded in the table.
path_hour VARCHAR(8000) UNICODE CASESPECIFIC X(8000) The hour at which the data was recorded in the table.
path_minute VARCHAR(8000) UNICODE CASESPECIFIC X(8000) The minute at which the data was recorded in the table.
path_ver VARCHAR(8000) UNICODE CASESPECIFIC X(8000) The version of Vantage software that was running on the operational group.
TheDate DATE NOT NULL YYYY/MM/DD Local Date of the log entry.
NodeID INTEGER NOT NULL ZZZ9-9999 Numeric value that uniquely identifies a node (cloud compute instance) within a compute cluster. For example, '10001','10002'.
TheTime FLOAT NOT NULL 99:99:99.99 Nominal local time of the log entry.
GmtTime FLOAT NOT NULL 99:99:99.99 Nominal GMT time of the log entry. Greenwich Mean Time is not affected by the Daylight Saving Time adjustments that occur twice a year.
CabinetID
Not applicable. Do not use.
     Not applicable.
ModuleID
Not applicable. Do not use.
     Not applicable.
NodeType CHAR(8) LATIN NOT CASESPECIFIC X(8) Indicates the node (cloud compute instance) family. For example, '67_R5'.
TheTimestamp BIGINT NOT NULL -(20)9 Number of seconds since midnight, January 1, 1970.
CentiSecs INTEGER NOT NULL -(11)9 Actual number of centiseconds in the logging period.
Secs SMALLINT NOT NULL -(6)9 Actual number of seconds in the logging period.
NominalSecs SMALLINT NOT NULL -(6)9 Nominal number of seconds in the logging period.
PM_COD_CPU SMALLINT NOT NULL -(6)9 Platform Metering CPU COD value in one tenths of a percent. For example, a value of 500 represents a COD value of 50.0%.
PM_COD_IO SMALLINT NOT NULL -(6)9 Platform Metering IO COD value in whole percent. For example, a value of 50 represents a COD value of 50.0%
WM_COD_CPU SMALLINT NOT NULL -(6)9 Workload Management CPU COD value in one tenths of a percent. For example, a value of 500 represents a COD value of 50.0%.
WM_COD_IO SMALLINT NOT NULL -(6)9 Workload Management IO COD value in whole percent. For example, a value of 50 represents a COD value of 50.0%.
TIER_FACTOR SMALLINT NOT NULL -(6)9 I/O performance limit placed on a core-reduced node. For example, a value of 75 represents an I/O limit of 75.0% placed before other COD values.
Reserved00 SMALLINT NOT NULL -(6)9 Reserved for future use.
NCPUs SMALLINT NOT NULL -(6)9 Number of online CPUs on this node.
AMPcount SMALLINT NOT NULL -(6)9 Number of AMPs on the node. AMPcount is used to divide columns that are reporting data from all the AMPs. This allows the ResSpsView view to report the data columns on a per-AMP basis.
RowIndex1 SMALLINT NOT NULL -(6)9 On SLES 10 or earlier systems, this column contains the PGId. On SLES 11 or later systems, this column contains the pWDid. The pWDid value ranges from 0 to 255.
VprType CHAR(4) LATIN NOT CASESPECIFIC NOT NULL X(4) Type of vproc (AMP, PE, and MISC). Rows reported as vproc type of MISC contain data for all vproc types other than the AMP and PE vproc types.
ReservedS0 CHAR(2) LATIN NOT CASESPECIFIC NOT NULL X(2) Reserved for future use.
PPid BYTEINT NOT NULL -(4)9 On SLES 10 or earlier systems, this column identifies the performance period. The PPId maps the internal performance period to a RSS value (0=>0, 1 to 7 => 1). On SLES 11 or later systems, this column is not valid and returns a zero value.
ReservedS1 CHAR(7) LATIN NOT CASESPECIFIC NOT NULL X(7) Reserved for future use.
QWaitTime FLOAT NOT NULL -(20)9 Total time in milliseconds that work requests waited on an input queue before being serviced. Work requests that are not delivered are not counted.
ServiceTime FLOATNOT NULL -(20)9 Time in milliseconds that work requests required for service. The service time is the elapsed time from the time the message was received to the time the AMP Worker Task was released. The time it was held through sleeps, I/O, and so on, until it is released.
WorkTimeInuse FLOAT NOT NULL -(20)9 Service time consumed by a WD during the current reporting period
FilePDbAcqKB FLOAT NOT NULL -(20)9 KB acquired by FilePDbAcqs.
FilePCiAcqKB FLOAT NOT NULL -(20)9 KB acquired by FilePCiAcqs.
FileSDbAcqKB FLOAT NOT NULL -(20)9 KB acquired by FileSDbAcqs.
FileSCiAcqKB FLOAT NOT NULL -(20)9 KB acquired by FileSCiAcqs.
FileTJtAcqKB FLOAT NOT NULL -(20)9 KB acquired by FileTJtAcqs.
FileAPtAcqKB FLOAT NOT NULL -(20)9 KB acquired by FileAPtAcqs.
FilePDbAcqReadKB FLOAT NOT NULL -(20)9 KB physically read by FilePDbAcqReads.
FilePCiAcqReadKB FLOAT NOT NULL -(20)9 KB physically read by FilePCiAcqReads.
FileSDbAcqReadKB FLOAT NOT NULL -(20)9 KB physically read by FileSDbAcqReads.
FileSCiAcqReadKB FLOAT NOT NULL -(20)9 KB physically read by FileSCiAcqReads.
FileTJtAcqReadKB FLOAT NOT NULL -(20)9 KB physically read by FileTJtAcqReads.
FileAPtAcqReadKB FLOAT NOT NULL -(20)9 KB physically read by FileAPtAcqReads.
FilePDbPresKB FLOAT NOT NULL -(20)9 Number of KB prefetched by FilePDbPres.
FilePCiPresKB FLOAT NOT NULL -(20)9 Number of KB prefetched by FilePCiPres.
FileSDbPresKB FLOAT NOT NULL -(20)9 Number of KB prefetched by FileSDbPres.
FileSCiPresKB FLOAT NOT NULL -(20)9 Number of KB prefetched by FileSCiPres.
FileTJtPresKB FLOAT NOT NULL -(20)9 Number of KB prefetched by FileTJtPres.
FileAPtPresKB FLOAT NOT NULL -(20)9 Number of KB prefetched by FileAPtPres.
FilePDbPreReadKB FLOAT NOT NULL -(20)9 Number of KB physical read by FilePDbPreReads.
FilePCiPreReadKB FLOAT NOT NULL -(20)9 Number of KB physical read by FilePCiPreReads.
FileSDbPreReadKB FLOAT NOT NULL -(20)9 Number of KB physical read by FileSDbPreReads.
FileSCiPreReadKB FLOAT NOT NULL -(20)9 Number of KB physical read by FileSCiPreReads.
FileTJtPreReadKB FLOAT NOT NULL -(20)9 Number of KB physical read by FileTJtPreReads
FileAPtPreReadKB FLOAT NOT NULL -(20)9 Number of KB physical read by FileAPtPreReads
FilePDbDyRRelKB FLOAT NOT NULL -(20)9 KB released by FilePDbDyRRels.
FilePCiDyRRelKB FLOAT NOT NULL -(20)9 KB released by FilePCiDyRRels.
FileSDbDyRRelKB FLOAT NOT NULL -(20)9 KB released by FileSDbDyRRels.
FileSCiDyRRelKB FLOAT NOT NULL -(20)9 KB released by FileSCiDyRRels.
FileTJtDyRRelKB FLOAT NOT NULL -(20)9 KB released by FileTJtDyRRels.
FileAPtDyRRelKB FLOAT NOT NULL -(20)9 KB released by FileAPtDyRRels.
FilePDbFWriteKB FLOAT NOT NULL -(20)9 KB written by FilePDbFWrites.
FilePCiFWriteKB FLOAT NOT NULL -(20)9 KB written by FilePCiFWrites.
FileSDbFWriteKB FLOAT NOT NULL -(20)9 KB written by FileSDbFWrites.
FileSCiFWriteKB FLOAT NOT NULL -(20)9 KB written by FileSCiFWrites.
FileTJtFWriteKB FLOAT NOT NULL -(20)9 KB written by FileTJtFWrites.
FileAPtFWriteKB FLOAT NOT NULL -(20)9 KB written by FileAPtFWrites.
NetPtPReadKB FLOAT NOT NULL -(20)9 KB of point-to-point messages input to the vproc on behalf of the WD.
NetPtPWriteKB FLOAT NOT NULL -(20)9 KB of point-to-point messages output to the vproc on behalf of the WD.
ProcBlksTime FLOAT NOT NULL -(20)9 Number of times processes were blocked for a timer expiration.
ProcWaitTime FLOAT NOT NULL -(20)9 Time in milliseconds processes were blocked pending some amount of elapsed time only.
ProcWaitMisc FLOAT NOT NULL -(20)9 Time in milliseconds processes were blocked pending miscellaneous events.
WaitIO FLOAT NOT NULL -(20)9 SLES11: Time in milliseconds tasks in WD waited for I/O. Updated when the wait for I/O is completed.
CPURunDelay FLOAT NOT NULL -(20)9 SLES11: Time in milliseconds tasks in the WD sat in the CPU run queue waiting to run over the reporting period.
IOSubmittedKB FLOAT NOT NULL -(20)9 SLES11: KB of I/O submitted on behalf of this WD.
FileAgeOutNowIOKB FLOAT NOT NULL -(20)9 Volume of AgeOut Now data blocks not to keep in memory(fsgcache) and to be written out to disk in terms of KB (FileAgeOutNowIOKB).
IOCriticalSubmittedKB FLOAT NOT NULL -(20)9 SLES11: KB of I/O submitted with an MI Lock Priority. These I/Os go into a Teradata Scheduler queue and are not prioritized based on the type of management method.
FullPotentialIota FLOAT NOT NULL -(20)9 Sum of full (total uninhibited) potential IOTAs from all devices attached to this node.
CodPotentialIota FLOAT NOT NULL -(20)9 Sum of potential IOTAs from all devices attached to this node for this WD. These are accumulated only when an I/O is pending on a device, and they are limited by the IO_COD setting.
UsedIota FLOAT NOT NULL -(20)9 Sum of used IOTAs from all devices attached to this node for this WD.
IoThrottleCount FLOAT NOT NULL -(20)9 Number of times an I/O was throttled.
CpuVpThrottleCount FLOAT NOT NULL -(20)9 Number of times that VP hard limits throttling was triggered.
CpuVpThrottleTime FLOAT NOT NULL -(20)9 Time in milliseconds that VP hard limits throttling was active.
CpuThrottleCount FLOAT NOT NULL -(20)9 Number of times that WD hard limits throttling was triggered.
CpuThrottleTime FLOAT NOT NULL -(20)9 Time in milliseconds that WD hard limits throttling was active.
VHLogicalDBRead FLOAT NOT NULL -(20)9 Logical reads that were hit in the FSG-VH cache per WD.
VHLogicalDBReadKB FLOAT NOT NULL -(20)9 KB read from the FSG-VH cache per WD.
VHPhysicalDBRead FLOAT NOT NULL -(20)9 Physical reads by TVS for Very Hot data per WD.
VHPhysicalDBReadKB FLOAT NOT NULL -(20)9 Physical read KBs by TVS for Very Hot data per WD.
IoThrottleTime FLOAT NOT NULL -(20)9 Total I/O Throttle Time in milliseconds.
IoThrottleTimeMax FLOAT NOT NULL -(20)9 Maximum I/O Throttle Time in milliseconds.
IoThrottleCntZeroIotas FLOAT NOT NULL -(20)9 Number of times an I/O was throttled due to no IOTA tokens available in the bucket.
IoThrottleCntInsuffIotas FLOAT NOT NULL -(20)9 Number of times an I/O was throttled due to insufficient IOTA tokens available in the bucket.
IoThrottleCntInsuffIotasHL FLOAT NOT NULL -(20)9 Number of times an I/O was throttled due to insufficient IOTA tokens available in the bucket for Hard Limits.
IoThrottleCntMaxQD FLOAT NOT NULL -(20)9 Number of times an I/O was throttled due to the queue depth to the storage being at maximum.
ReadRespMax FLOAT NOT NULL -(20)9 Maximum I/O Read Response Time in milliseconds.
WriteRespMax FLOAT NOT NULL -(20)9 Maximum I/O Write Response Time in milliseconds.
ReadRespTot FLOAT NOT NULL -(20)9 Total I/O Read Response Time in milliseconds.
WriteRespTot FLOAT NOT NULL -(20)9 Total I/O Write Response Time in milliseconds.
ProcBlksCpuThrottle FLOAT NOT NULL -(20)9 Number of times processes were throttled due to WM CPU COD or CPU hard limits.
ProcWaitCpuThrottle FLOAT NOT NULL -(20)9 Time in milliseconds processes were throttled due to WM CPU COD or CPU hard limits.
RRDHCount FLOAT NOT NULL -(20)9 Total count of hashed row redistributions (RRDs) processed by the node-level buffered redistribution services (NLB).
RRDHCascAll FLOAT NOT NULL -(20)9 Count of hashed RRDs with a Cascade Factor of 100%.
RRDHCascSome FLOAT NOT NULL -(20)9 Count of hashed RRDs with a Cascade Factor greater than 0% but less than 100%.
CISleeps FLOAT NOT NULL -(20)9 Number of times that processes are blocked waiting for a lock on the CI.
CISleepTime FLOAT NOT NULL -(20)9 Total amount of time in milliseconds that processes are blocked waiting for a lock on the CI.
CISleepTimeMax FLOAT NOT NULL -(20)9 Maximum amount of time in milliseconds that processes are blocked waiting for a lock on the CI.
FileWalTJCount FLOAT NOT NULL -(20)9 Number of Transient Journal records operations.
FileWalRedoCount FLOAT NOT NULL -(20)9 Number of Redo records operations.
FileWalTJIOKB FLOAT NOT NULL -(20)9 Volume of Transient Journal records operations in terms of KB.
FileWalRedoIOKB FLOAT NOT NULL -(20)9 Volume of Redo records operations in terms of KB.
IoPrioStarvedCount FLOAT NOT NULL -(20)9 Number of prioritized I/Os that were starved and had their priority updated to alleviate starvation.
MISleeps FLOAT NOT NULL -(20)9 Number of times that processes are blocked waiting for a lock on the MI.
MISleepTime FLOAT NOT NULL -(20)9 Total amount of time in milliseconds that processes are blocked waiting for a lock on the MI.
MISleepTimeMax FLOAT NOT NULL -(20)9 Maximum amount of time in milliseconds that processes are blocked waiting for a lock on the MI.
MmapSemReadCount FLOAT NOT NULL -(20)9 Number of times a segment is mapped and pinned pages or unmapped to process address-space.
MmapSemReadTime FLOAT NOT NULL -(20)9 Time in milliseconds task took to map and pin or unmap a segment to process address-space.
MmapSemWriteCount FLOAT NOT NULL -(20)9 Number of times a segment is mapped or unmapped to process address-space
MmapSemWriteTime FLOAT NOT NULL -(20)9 Time in milliseconds task took to map or unmap a segment to process address-space
IOSubmittedLocal FLOAT NOT NULL -(20)9 Number of I/Os submitted to local disks.
IOSubmittedLocalKB FLOAT NOT NULL -(20)9 Amount of I/O submitted, in KB, to local disks.
ProcWaitIoThrottle FLOAT NOT NULL -(20)9 Time in milliseconds processes were throttled due to PSF WM I/O COD or I/O hard limits.
Active FLOAT NOT NULL -(20)9 Controls whether the rows are logged to the resource usage tables if Active Row Filter Mode is enabled.
VPid FLOAT NOT NULL -(20)9 Virtual partition ID. Only one VpId is associated with a pWDid and VprType row at any point in time. There can be multiple pWDid values associated with a VPId.
WDid FLOAT NOT NULL -(20)9 Workload Definition ID.
NumTasks FLOAT NOT NULL -(20)9 Average number of tasks of online nodes
ActiveSessions FLOAT NOT NULL -(20)9 On SLES 10, this is the number of Scheduling Sets. On SLES 11, this is the number of request-level workload management objects created. There is one object created per user request. For non-user work request, there is one object created per WD.
NumRequests FLOAT NOT NULL -(20)9 Number of AMP Worker Task messages or requests that got assigned AMP Worker Tasks to them.
QWaitTimeMax FLOAT NOT NULL -(20)9 Maximum time in milliseconds that work requests waited on an input queue before being serviced.
ServiceTimeMax FLOAT NOT NULL -(20)9 Maximum time in milliseconds that work requests required for service.
WorkMsgSendDelay FLOAT NOT NULL -(20)9 Total time in milliseconds it takes to deliver work messages.
WorkMsgSendDelayMax FLOAT NOT NULL -(20)9 Maximum time in milliseconds that it takes to deliver any single work message.
WorkMsgReceiveDelay FLOAT NOT NULL -(20)9 Time for all messages not yet delivered at the end of each reporting period. Related to the QWaitTime column, represents a running total of delays attributed to the tasks that still have not been assigned an AMP Worker Task within this interval.
WorkMsgReceiveDelayMax FLOAT NOT NULL -(20)9 Maximum delay time in milliseconds for messages that are still in the work box at the end of each reporting period.
WorkTimeInuseMax FLOAT NOT NULL -(20)9 Maximum service time of a single task in a WD that is running or ha finished in the current reporting period. This includes time used during previous intervals for that task.
AwtReleases FLOAT NOT NULL -(20)9 Number of AMP Worker Tasks released (that is, completed requests) while the NumRequests column reports the number of AMP Worker Task requests that arrived.
WorkMsgSendDelayCnt FLOAT NOT NULL -(20)9 Number of messages that are delivered to the work box.
WorkMsgReceiveDelayCnt FLOAT NOT NULL -(20)9 Number of messages that are still waiting for AMP Worker Tasks at the end of each reporting period.
CPUUServ FLOAT NOT NULL -(20)9 Time in milliseconds CPUs are busy executing user service code. This is the system-level time spent on a process.
CPUUExec FLOAT NOT NULL -(20)9 Time in milliseconds CPUs are busy executing user execution code. This is the user-level time spent on a process.
CPUUServOther FLOAT NOT NULL -(20)9 Time in milliseconds CPUs are busy executing miscellaneous activities for user service code. This is the system-level time spent on a process.
CPUUExecOther FLOAT NOT NULL -(20)9 Time in milliseconds CPUs are busy executing miscellaneous activities for user execution code. This is the user-level time spent on a process
MemAllocs FLOAT NOT NULL -(20)9 Number of successful SEG memory allocations.
WorkTypeInuse00 FLOAT NOT NULL -(20)9 Current number of AMP Worker Tasks in use for each work type.
WorkTypeInuse01 FLOAT NOT NULL -(20)9 Current number of AMP Worker Tasks in use for each work type.
WorkTypeInuse02 FLOAT NOT NULL -(20)9 Current number of AMP Worker Tasks in use for each work type.
WorkTypeInuse03 FLOAT NOT NULL -(20)9 Current number of AMP Worker Tasks in use for each work type.
WorkTypeInuse04 FLOAT NOT NULL -(20)9 Current number of AMP Worker Tasks in use for each work type.
WorkTypeInuse05 FLOAT NOT NULL -(20)9 Current number of AMP Worker Tasks in use for each work type.
WorkTypeInuse06 FLOAT NOT NULL -(20)9 Current number of AMP Worker Tasks in use for each work type.
WorkTypeInuse07 FLOAT NOT NULL -(20)9 Current number of AMP Worker Tasks in use for each work type.
WorkTypeInuse08 FLOAT NOT NULL -(20)9 Current number of AMP Worker Tasks in use for each work type.
WorkTypeInuse09 FLOAT NOT NULL -(20)9 Current number of AMP Worker Tasks in use for each work type.
WorkTypeInuse10 FLOAT NOT NULL -(20)9 Current number of AMP Worker Tasks in use for each work type.
WorkTypeInuse11 FLOAT NOT NULL -(20)9 Current number of AMP Worker Tasks in use for each work type.
WorkTypeInuse12 FLOAT NOT NULL -(20)9 Current number of AMP Worker Tasks in use for each work type.
WorkTypeInuse13 FLOAT NOT NULL -(20)9 Current number of AMP Worker Tasks in use for each work type.
WorkTypeInuse14 FLOAT NOT NULL -(20)9 Current number of AMP Worker Tasks in use for each work type.
WorkTypeInuse15 FLOAT NOT NULL -(20)9 Current number of AMP Worker Tasks in use for each work type.
WorkTypeMax00 FLOAT NOT NULL -(20)9 Maximum of the WorkTypeInuse values reported during the logging period. The true maximum number of in-use AMP Worker Tasks of a WorkType may occur at a different time during the reporting period and not be seen and, therefore, not be reported.
WorkTypeMax01 FLOAT NOT NULL -(20)9 Maximum of the WorkTypeInuse values reported during the logging period. The true maximum number of in-use AMP Worker Tasks of a WorkType may occur at a different time during the reporting period and not be seen and, therefore, not be reported.
WorkTypeMax02 FLOAT NOT NULL -(20)9 Maximum of the WorkTypeInuse values reported during the logging period. The true maximum number of in-use AMP Worker Tasks of a WorkType may occur at a different time during the reporting period and not be seen and, therefore, not be reported.
WorkTypeMax03 FLOAT NOT NULL -(20)9 Maximum of the WorkTypeInuse values reported during the logging period. The true maximum number of in-use AMP Worker Tasks of a WorkType may occur at a different time during the reporting period and not be seen and, therefore, not be reported.
WorkTypeMax04 FLOAT NOT NULL -(20)9 Maximum of the WorkTypeInuse values reported during the logging period. The true maximum number of in-use AMP Worker Tasks of a WorkType may occur at a different time during the reporting period and not be seen and, therefore, not be reported.
WorkTypeMax05 FLOAT NOT NULL -(20)9 Maximum of the WorkTypeInuse values reported during the logging period. The true maximum number of in-use AMP Worker Tasks of a WorkType may occur at a different time during the reporting period and not be seen and, therefore, not be reported.
WorkTypeMax06 FLOAT NOT NULL -(20)9 Maximum of the WorkTypeInuse values reported during the logging period. The true maximum number of in-use AMP Worker Tasks of a WorkType may occur at a different time during the reporting period and not be seen and, therefore, not be reported.
WorkTypeMax07 FLOAT NOT NULL -(20)9 Maximum of the WorkTypeInuse values reported during the logging period. The true maximum number of in-use AMP Worker Tasks of a WorkType may occur at a different time during the reporting period and not be seen and, therefore, not be reported.
WorkTypeMax08 FLOAT NOT NULL -(20)9 Maximum of the WorkTypeInuse values reported during the logging period. The true maximum number of in-use AMP Worker Tasks of a WorkType may occur at a different time during the reporting period and not be seen and, therefore, not be reported.
WorkTypeMax09 FLOAT NOT NULL -(20)9 Maximum of the WorkTypeInuse values reported during the logging period. The true maximum number of in-use AMP Worker Tasks of a WorkType may occur at a different time during the reporting period and not be seen and, therefore, not be reported.
WorkTypeMax10 FLOAT NOT NULL -(20)9 Maximum of the WorkTypeInuse values reported during the logging period. The true maximum number of in-use AMP Worker Tasks of a WorkType may occur at a different time during the reporting period and not be seen and, therefore, not be reported.
WorkTypeMax11 FLOAT NOT NULL -(20)9 Maximum of the WorkTypeInuse values reported during the logging period. The true maximum number of in-use AMP Worker Tasks of a WorkType may occur at a different time during the reporting period and not be seen and, therefore, not be reported.
WorkTypeMax12 FLOAT NOT NULL -(20)9 Maximum of the WorkTypeInuse values reported during the logging period. The true maximum number of in-use AMP Worker Tasks of a WorkType may occur at a different time during the reporting period and not be seen and, therefore, not be reported.
WorkTypeMax13 FLOAT NOT NULL -(20)9 Maximum of the WorkTypeInuse values reported during the logging period. The true maximum number of in-use AMP Worker Tasks of a WorkType may occur at a different time during the reporting period and not be seen and, therefore, not be reported.
WorkTypeMax14 FLOAT NOT NULL -(20)9 Maximum of the WorkTypeInuse values reported during the logging period. The true maximum number of in-use AMP Worker Tasks of a WorkType may occur at a different time during the reporting period and not be seen and, therefore, not be reported.
WorkTypeMax15 FLOAT NOT NULL -(20)9 Maximum of the WorkTypeInuse values reported during the logging period. The true maximum number of in-use AMP Worker Tasks of a WorkType may occur at a different time during the reporting period and not be seen and, therefore, not be reported.
FilePDbAcqs FLOAT NOT NULL -(20)9 Number of permanent data block disk segments acquired.
FilePCiAcqs FLOAT NOT NULL -(20)9 Number of permanent cylinder index disk segments acquired.
FileSDbAcqs FLOAT NOT NULL -(20)9 Number of regular or restartable spool data block disk segments acquired.
FileSCiAcqs FLOAT NOT NULL -(20)9 Number of regular or restartable spool cylinder index disk segments acquired.
FileTJtAcqs FLOAT NOT NULL -(20)9 Number of transient journal table disk segments acquired.
FileAPtAcqs FLOAT NOT NULL -(20)9 Number of append table or permanent journal table data block or cylinder index disk segments acquired.
FilePDbAcqReads FLOAT NOT NULL -(20)9 Number of permanent data block disk segment acquires that caused a physical read.
FilePCiAcqReads FLOAT NOT NULL -(20)9 Number of permanent cylinder index disk segment acquires that caused a physical read.
FileSDbAcqReads FLOAT NOT NULL -(20)9 Number of regular or restartable spool data block disk segments that caused a physical read.
FileSCiAcqReads FLOAT NOT NULL -(20)9 Number of regular or restartable spool index disk segments that caused a physical read.
FileTJtAcqReads FLOAT NOT NULL -(20)9 Number of transient journal table disk segments that caused a physical read.
FileAPtAcqReads FLOAT NOT NULL -(20)9 Number of append table or permanent journal table data block or cylinder index disk segments that caused a physical read.
FilePDbPres FLOAT NOT NULL -(20)9 Number of permanent data block disk segments prefetched.
FilePCiPres FLOAT NOT NULL -(20)9 Number of permanent cylinder index disk segments prefetched.
FileSDbPres FLOAT NOT NULL -(20)9 Number of regular or restartable spool data block disk segments prefetched.
FileSCiPres FLOAT NOT NULL -(20)9 Number of regular or restartable spool index disk segments prefetched.
FileTJtPres FLOAT NOT NULL -(20)9 Number of transient journal table disk segments prefetched.
FileAPtPres FLOAT NOT NULL -(20)9 Number of append table or permanent journal table data block or cylinder index disk segments prefetched.
FilePDbPreReads FLOAT NOT NULL -(20)9 Number of permanent data block disk segment prefetches that caused a physical read.
FilePCiPreReads FLOAT NOT NULL -(20)9 Number of permanent cylinder index disk segment prefetches that caused a physical read.
FileSDbPreReads FLOAT NOT NULL -(20)9 Number of regular or restartable spool data block disk segment prefetches that caused a physical read.
FileSCiPreReads FLOAT NOT NULL -(20)9 Number of regular or restartable spool index disk segment prefetches that caused a physical read.
FileTJtPreReads FLOAT NOT NULL -(20)9 Number of transient journal table disk segment prefetches that caused a physical read
FileAPtPreReads FLOAT NOT NULL -(20)9 Number of append table or permanent journal table data block or cylinder index disk segment prefetches that caused a physical read.
FilePDbDyRRels FLOAT NOT NULL -(20)9 Number of dirty permanent data block disk segment resident releases.
FilePCiDyRRels FLOAT NOT NULL -(20)9 Number of dirty permanent cylinder index disk segment resident releases.
FileSDbDyRRels FLOAT NOT NULL -(20)9 Number of dirty regular or restartable spool data block disk segment resident releases.
FileSCiDyRRels FLOAT NOT NULL -(20)9 Number of dirty regular or restartable spool cylinder index disk segment resident releases.
FileTJtDyRRels FLOAT NOT NULL -(20)9 Number of dirty transient journal table or WAL data block or WAL cylinder index disk segment resident releases.
FileAPtDyRRels FLOAT NOT NULL -(20)9 Number of dirty append table and permanent journal data block or cylinder index disk segment resident releases.
FilePDbFWrites FLOAT NOT NULL -(20)9 Number of permanent data block disk segment forced releases or specific I/O requests causing an immediate physical write.
FilePCiFWrites FLOAT NOT NULL -(20)9 Number of permanent cylinder index disk segment forced releases or specific I/O requests causing an immediate physical write.
FileSDbFWrites FLOAT NOT NULL -(20)9 Number of regular or restartable spool data block disk segment forced releases or specific I/O requests causing an immediate physical write.
FileSCiFWrites FLOAT NOT NULL -(20)9 Number of regular or restartable spool cylinder index disk segment forced releases or specific I/O requests causing an immediate physical write.
FileTJtFWrites FLOAT NOT NULL -(20)9 Number of transient journal table or WAL data block or WAL cylinder index disk segment forced releases or specific I/O requests causing an immediate physical write.
FileAPtFWrites FLOAT NOT NULL -(20)9 Number of append table and permanent journal data block or cylinder index disk segment forced releases or specific I/O requests causing an immediate physical write.
NetPtPReads FLOAT NOT NULL -(20)9 Number of point-to-point messages input to the vproc on behalf of the WD.
NetPtPWrites FLOAT NOT NULL -(20)9 Number of point-to-point messages output from the vproc on behalf of the WD
NetBrdReads FLOAT NOT NULL -(20)9 Number of broadcast messages input to the vproc.
NetBrdWrites FLOAT NOT NULL -(20)9 Number of broadcast messages output from the vproc.
ProcBlksSegNoVirtual FLOAT NOT NULL -(20)9 Number of times processes were blocked waiting for virtual memory for a segment.
ProcBlksFsgNIOs FLOAT NOT NULL -(20)9 Number of times processes were blocked waiting for task I/Os to complete.
ProcBlksSegMDL FLOAT NOT NULL -(20)9 Number of times processes were blocked waiting for an MDL resource to become available. An MDL is an internal PDE data structure needed by the operation of the segment subsystem.
ProcBlksMonResume FLOAT NOT NULL -(20)9 Number of times processes were blocked for a user monitor resume from a yield.
ProcBlksNetThrottle FLOAT NOT NULL -(20)9 Number of times processes were blocked for delivery of outstanding outgoing messages.
ProcBlksQnl FLOAT NOT NULL -(20)9 Number of times processes were blocked for a TSKQNL lock.
ProcBlksFsgRead FLOAT NOT NULL -(20)9 Number of times processes were blocked for an FSG read
ProcBlksFsgWrite FLOAT NOT NULL -(20)9 Number of times processes were blocked for an FSG write from disk.
ProcBlksDBLock FLOAT NOT NULL -(20)9 Number of times processes were blocked for a database lock.
ProcBlksMonitor FLOAT NOT NULL -(20)9 Number of times processes were blocked for a user monitor.
ProcBlksSegLock FLOAT NOT NULL -(20)9 Number of times processes were blocked for a disk or task context (for example, scratch, stack, and so on).
ProcBlksFsgLock FLOAT NOT NULL -(20)9 Number of times processes were blocked for an FSG lock
ProcBlksFlowControl FLOAT NOT NULL -(20)9 Number of times processes were blocked by delays caused by the flow control conditions.
ProcBlksMisc FLOAT NOT NULL -(20)9 Number of times processes were blocked for miscellaneous events.
ProcWaitSegNoVirtual FLOAT NOT NULL -(20)9 Time in milliseconds processes were blocked waiting for virtual memory for a segment.
ProcWaitFsgNIOs FLOAT NOT NULL -(20)9 Time in milliseconds processes were blocked waiting for task I/ Os to complete.
ProcWaitSegMDL FLOAT NOT NULL -(20)9 Time in milliseconds processes were blocked waiting for an MDL resource to become available. An MDL is an internal PDE data structure needed by the operation of the segment subsystem.
ProcWaitMonResume FLOAT NOT NULL -(20)9 Time in milliseconds processes were blocked pending a user monitor resume from a yield.
ProcWaitNetThrottle FLOAT NOT NULL -(20)9 Time in milliseconds processes were blocked pending delivery of outstanding outgoing messages.
ProcWaitQnl FLOAT NOT NULL -(20)9 Time in milliseconds processes were blocked pending an TSKQNL lock.
ProcWaitFsgRead FLOAT NOT NULL -(20)9 Time in milliseconds processes were blocked pending an FSG read from disk.
ProcWaitFsgWrite FLOAT NOT NULL -(20)9 Time in milliseconds processes were blocked pending an FSG write from disk.
ProcWaitDBLock FLOAT NOT NULL -(20)9 Time in milliseconds processes were blocked pending a database lock.
ProcWaitMonitor FLOAT NOT NULL -(20)9 Time in milliseconds processes were blocked pending a user monitor.
ProcWaitSegLock FLOAT NOT NULL -(20)9 Time in milliseconds processes were blocked pending a disk or task context (for example, scratch, stack, and so on) lock.
ProcWaitFsgLock FLOAT NOT NULL -(20)9 Time in milliseconds processes were blocked pending an FSG lock.
ProcWaitFlowControl FLOAT NOT NULL -(20)9 Time in milliseconds processes were blocked pending the delays caused by flow control conditions.
IOSubmitted FLOAT NOT NULL -(20)9 SLES11: Number of I/Os submitted on behalf of this WD.
FileAgeOutNowCount FLOAT NOT NULL -(20)9 Number of AgeOut Now data blocks not to keep in memory(fsgcache) and to be written out to disk (FileAgeOutNowCount)..
IOCriticalSubmitted FLOAT NOT NULL -(20)9 SLES11: Number of I/Os submitted with a MI Lock Priority. These I/Os go into a Teradata Scheduler queue and are not prioritized based on the type of management method.
DecayLevel1IO FLOAT NOT NULL -(20)9 SLES11: Number of times SQL requests in the WD hit decay level 1 due to I/O.
DecayLevel2IO FLOAT NOT NULL -(20)9 SLES11: Number of times SQL requests in the WD decay level 2 due to I/O.
DecayLevel1CPU FLOAT NOT NULL -(20)9 SLES11: Number of times SQL requests in the WD hit decay level 1 due to CPU.
DecayLevel2CPU FLOAT NOT NULL -(20)9 SLES11: Number of times SQL requests in the WD hit decay level 2 due to CPU.
TacticalExceptionIO FLOAT NOT NULL -(20)9 SLES11: Number of times SQL requests in the WD hit a tactical per-node exception due to I/O.
TacticalExceptionCPU FLOAT NOT NULL -(20)9 SLES11: Number of times SQL requests in the WD hit a tactical per-node exception due to CPU.
RTBoostCount FLOAT NOT NULL -(20)9 Number of tasks boosted to real time priority (Maximum priority).
RTCpuTime FLOAT NOT NULL -(20)9 Total CPU time in milliseconds consumed by boosted real-time tasks.
RTTasksMax FLOAT NOT NULL -(20)9 Maximum number of tasks running in boosted real-time priority.
WorkTypeAWTExhausted00 FLOAT NOT NULL -(20)9 Number of times a work message cannot be assigned to an AWT.
WorkTypeAWTExhausted01 FLOAT NOT NULL -(20)9 Number of times a work message cannot be assigned to an AWT.
WorkTypeAWTExhausted02 FLOAT NOT NULL -(20)9 Number of times a work message cannot be assigned to an AWT.
WorkTypeAWTExhausted03 FLOAT NOT NULL -(20)9 Number of times a work message cannot be assigned to an AWT.
WorkTypeAWTExhausted04 FLOAT NOT NULL -(20)9 Number of times a work message cannot be assigned to an AWT.
WorkTypeAWTExhausted05 FLOAT NOT NULL -(20)9 Number of times a work message cannot be assigned to an AWT.
WorkTypeAWTExhausted06 FLOAT NOT NULL -(20)9 Number of times a work message cannot be assigned to an AWT.
WorkTypeAWTExhausted07 FLOAT NOT NULL -(20)9 Number of times a work message cannot be assigned to an AWT.
WorkTypeAWTExhausted08 FLOAT NOT NULL -(20)9 Number of times a work message cannot be assigned to an AWT.
WorkTypeAWTExhausted09 FLOAT NOT NULL -(20)9 Number of times a work message cannot be assigned to an AWT.
WorkTypeAWTExhausted10 FLOAT NOT NULL -(20)9 Number of times a work message cannot be assigned to an AWT.
WorkTypeAWTExhausted11 FLOAT NOT NULL -(20)9 Number of times a work message cannot be assigned to an AWT.
WorkTypeAWTExhausted12 FLOAT NOT NULL -(20)9 Number of times a work message cannot be assigned to an AWT.
WorkTypeAWTExhausted13 FLOAT NOT NULL -(20)9 Number of times a work message cannot be assigned to an AWT.
WorkTypeAWTExhausted14 FLOAT NOT NULL -(20)9 Number of times a work message cannot be assigned to an AWT.
WorkTypeAWTExhausted15 FLOAT NOT NULL -(20)9 Number of times a work message cannot be assigned to an AWT.
UdfServ FLOAT NOT NULL -(20)9 System-level UDF CPU time in milliseconds, excluding the CPU time of the STO child processes.
UdfExec FLOAT NOT NULL -(20)9 User-level UDF CPU time in milliseconds, excluding the CPU time of the STO child processes.
UdfServOther FLOAT NOT NULL -(20)9 System-level UDF CPU time in milliseconds of other UDF processes such as the STO child processes.
UdfExecOther FLOAT NOT NULL -(20)9 User-level UDF CPU time in milliseconds of other UDF processes such as the STO child processes.
TDEnabledCPUs FLOAT NOT NULL -(20)9 Number of CPUs available for Teradata tasks at the end of the reporting period.