Teradata Database System Metrics

Teradata Viewpoint User Guide

brand
Analytical Ecosystem
prodname
Teradata Viewpoint
vrm_release
16.00
category
User Guide
featnum
B035-2206-106K

Session Metrics

Metric Source Calculation Type
CPU Use Δ CPU: derived

SessionRate: Teradata PM/API > System PMPC APIs > Monitor Session > Statement 1 > Group I Data Fields > SessionRate

CPUCount: Teradata PM/API > System PMPC APIs > Monitor Physical Config > Statement 2 > CPUCount

(Δ CPU / (SessionRate * total CPUCount on nodes with amps)) * 100 Percent
Δ CPU

AMPCPUSec: Teradata PM/API > System PMPC APIs > Monitor Session > Statement 2 > Group I Data Fields > AMPCPUSec

Current session's AMPCPUSec - previous sampled AMPCPUSec Number
Δ I/O

AMPIO: Teradata PM/API > System PMPC APIs > Monitor Session > Statement 2 > Group I Data Fields > AMPIO

Current session's AMPIO - previous sampled AMPIO Number
Hot AMP Spool

ReqHotAmpSpool: Teradata PM/API > System PMPC APIs > Monitor Session > Statement 2 > Group VIII Data Fields > ReqHotAmpSpool

Teradata 16.0 and later: ReqHotAmpSpool Number
Impact CPU

HotAmp1CPU: Teradata PM/API > System PMPC APIs > Monitor Session > Statement 2 > Group II Data Fields > HotAmp1CPU

UpAMPCount: Teradata PM/API > System PMPC APIs > Monitor Session > Statement 2 > Group II Data Fields > UpAMPCount

ReqHotAmpCPU: Teradata PM/API (15.10)> System PMPC APIs > Monitor Session > Statement 2 > Group VII Data Fields > ReqHotAmpCPU

ReqInvolvedAMPCnt: Teradata PM/API (15.10) > System PMPC APIs > Monitor Session > Statement 2 > Group VII Data Fields > ReqInvolvedAMPCnt

Teradata 15.0 and earlier:(HotAmp1CPU * UpAMPCount)

Teradata 15.10 and later: (ReqHotAmpCPU * ReqInvolvedAMPCnt)

Number
Partition

PartName: Teradata PM/API > System PMPC APIs > Monitor Session > Statement 2 > Group I Data Fields > PartName

PartName String
PJI

RequestAmpCPU: Teradata PM/API > System PMPC APIs > Monitor Session > Statement 2 > Group III Data Fields > RequestAmpCPU

RequestAmpI/O: Teradata PM/API > System PMPC APIs > Monitor Session > Statement 2 > Group III Data Fields > RequestAmpI/O

1000 * (RequestAmpCPU / RequestAmpI/O) Number
Proxy Username

ProxyUser: Teradata PM/API > System PMPC APIs > Monitor Session > Statement 2 > Group V Data Fields > ProxyUser

ProxyUser String
Request Count

ReqCount: Teradata PM/API > System PMPC APIs > Monitor Session > Statement 1 > Group I Data Fields > ReqCount

ReqCount Number
Request CPU

RequestAmpCPU: Teradata PM/API > System PMPC APIs > Monitor Session > Statement 2 > Group III Data Fields > RequestAmpCPU

RequestAmpCPU Number
Request CPU Skew

RequestAmpCPU: Teradata PM/API > System PMPC APIs > Monitor Session > Statement 2 > Group III Data Fields > RequestAmpCPU

ReqInvolvedAMPCnt: Teradata PM/API (15.10) > System PMPC APIs > Monitor Session > Statement 2 > Group VII Data Fields > ReqInvolvedAMPCnt

ReqHotAmpCPU: Teradata PM/API (15.10)> System PMPC APIs > Monitor Session > Statement 2 > Group VII Data Fields > ReqHotAmpCPU

Teradata 15.10 and later: 100 * (1 - (RequestAmpCPU / ReqInvolvedAmpCnt) / ReqHotAmpCPU) Percent
Request I/O

RequestAmpI/O: Teradata PM/API > System PMPC APIs > Monitor Session > Statement 2 > Group III Data Fields > RequestAmpI/O

RequestAmpI/O Number
Request I/O Skew

RequestAmpI/O: Teradata PM/API > System PMPC APIs > Monitor Session > Statement 2 > Group III Data Fields > RequestAmpI/O

ReqInvolvedAMPCnt: Teradata PM/API (15.10) > System PMPC APIs > Monitor Session > Statement 2 > Group VII Data Fields > ReqInvolvedAMPCnt

ReqHotAmpIO: Teradata PM/API > System PMPC APIs > Monitor Session > Statement 2 > Group VII Data Fields > ReqHotAmpIO

Teradata 15.10 and later: 100 * (1 - (RequestAmpI/O / ReqInvolvedAmpCnt) / ReqHotAmpIO) Percent
Snapshot CPU Skew

AvgAmpCPUSec: Teradata PM/API > System PMPC APIs > Monitor Session > Statement 2 > Group II Data Fields > AvgAmpCPUSec

HotAmp1CPU: Teradata PM/API > System PMPC APIs > Monitor Session > Statement 2 > Group II Data Fields > HotAmp1CPU

100 * (1 - (AvgAmpCPUSec / HotAmp1CPU)) Percent
Snapshot I/O Skew

AvgAmpIOCnt: Teradata PM/API > System PMPC APIs > Monitor Session > Statement 2 > Group II Data Fields > AvgAmpIOCnt

HotAmpIO: Teradata PM/API > System PMPC APIs > Monitor Session > Statement 2 > Group II Data Fields > HotAmp1IO

100 * (1 - (AvgAmpIOCnt / HotAmp1IO)) Percent
Spool

Request_AmpSpool: Teradata PM/API > System PMPC APIs > Monitor Session > Statement 2 > Group I Data Fields > Request_AmpSpool

Request_AmpSpool Number
Spool Skew

Request_AmpSpool: Teradata PM/API > System PMPC APIs > Monitor Session > Statement 2 > Group I Data Fields > Request_AmpSpool

ReqHotAmpSpool: Teradata PM/API > System PMPC APIs >Monitor Session > Statement 2 > Group VIII Data Fields > ReqHotAmpSpool

ReqInvolvedAMPCnt: Teradata PM/API > System PMPC APIs > Monitor Session > Statement 2 > Group VII Data Fields > ReqInvolvedAMPCnt

Teradata 16.0 and later: 100 * (1 – (Request_AmpSpool / (ReqHotAmpSpool * ReqInvolvedAMPCnt))) Percent
Start

RequestStartTime: Teradata PM/API > System PMPC APIs > Monitor Session > Statement 2 > Group III Data Fields > RequestStartTime

RequestStartTime Number
State

PEState: Teradata PM/API > System PMPC APIs > Monitor Session > Statement 2 > Group I Data Fields > PEState

AMPState: Teradata PM/API > System PMPC APIs > Monitor Session > Statement 2 > Group I Data Fields > AMPState

See MONITOR SESSION Response Combinations in Application Programming Reference. String
Temp Space

TempSpace: Teradata PM/API > System PMPC APIs > Monitor Session > Statement 2 > Group I Data Fields > TempSpace

TempSpace Number
Unnecessary I/O

RequestAmpI/O: Teradata PM/API > System PMPC APIs > Monitor Session > Statement 2 > Group III Data Fields > RequestAmpI/O

RequestAmpCPU: Teradata PM/API > System PMPC APIs > Monitor Session > Statement 2 > Group III Data Fields > RequestAmpCPU

RequestAmpI/O / (RequestAmpCPU * 1000) Number
Workload TDWM.RuleDefs Teradata Database 13.10 and later: rulename String

Account String and User Metrics

Metric Source Calculation Type
Δ Request Count

ReqCount: Teradata PM/API > System PMPC APIs > Monitor Session > Statement 1 > Group I Data Fields > ReqCount

Difference between request counts between samples Number

Blocker Metrics

Metric Source Calculation Type
Blocking Count

Blk_x_SessNo: Teradata PM/API > System PMPC APIs > Monitor Session > Statement 2 > Group I Data Fields > Blk_x_SessNo

Count of blocking session Number
Blocking Type

Blk_1_SessNo: Teradata PM/API > System PMPC APIs > Monitor Session > Statement 2 > Group I Data Fields > Blk_1_SessNo

Blk_x_Status: Teradata PM/API > System PMPC APIs > Monitor Session > Statement 2 > Group I Data Fields > Blk_x_Status

If blocker session and there is no Blk_1_SessNo, then root cause. Otherwise, if any Blk_Status has a GRANTED status, then type is GRANTED. Otherwise, WAITING. Number

Utility Metrics

Metric Source Calculation Type
LSN

LSN: Teradata PM/API > System PMPC APIs > Monitor Session > Statement 2 > Group I Data Fields > LSN

LSN Number
Utility

LSN: Teradata PM/API > System PMPC APIs > Monitor Session > Statement 2 > Group I Data Fields > LSN

LSN > 0 String
AMP CPU

RequestAmpCPU: Teradata PM/API > System PMPC APIs > Monitor Session > Statement 2 > Group III Data Fields > RequestAmpCPU

RequestAmpCPU Number
AMP I/O

RequestAmpI/O: Teradata PM/API > System PMPC APIs > Monitor Session > Statement 2 > Group III Data Fields > RequestAmpI/O

RequestAmpI/O Number

Vproc Metrics

Metric Source Calculation Type
PE

LogonPENo: Teradata PM/API > System PMPC APIs > Monitor Session > Statement 2 > Group I Data Fields > LogonPENo

LogonPENo Number
PE CPU

PECPUsec: Teradata PM/API > System PMPC APIs > Monitor Session > Statement 2 > Group I Data Fields > PECPUsec

PECPUsec Number
Skewed CPU

AvgAmpCPUSec: Teradata PM/API > System PMPC APIs > Monitor Session > Statement 2 > Group II Data Fields > AvgAmpCPUSec

HotAmp1CPU: Teradata PM/API > System PMPC APIs > Monitor Session > Statement 2 > Group II Data Fields > HotAmp1CPU

100 * (1 - (AvgAmpCPUSec / HotAmp1CPU)) Percent