17.10 - Teradata Database 系统指标 - Teradata Viewpoint - Teradata Workload Management

Teradata® Viewpoint 用户指南

Product
Teradata Viewpoint
Teradata Workload Management
Release Number
17.10
Release Date
2021 年 10 月
Content Type
用户指南
Publication ID
B035-2206-101K-CHS
Language
中文 (简体)

会话指标

指标 计算 类型
CPU 使用 Δ CPU:派生

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 * 具有 AMP 的节点上的 CPUCount 总数)) * 100 百分比
Δ CPU

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

当前会话的 AMPCPUSec - 之前抽样的 AMPCPUSec 数字
Δ I/O

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

当前会话的 AMPIO - 之前抽样的 AMPIO 数字
热 AMP Spool

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

(Teradata 16.0 及更高版本)ReqHotAmpSpool 数字
影响 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 及更早版本)(HotAmp1CPU * UpAMPCount)

(Teradata 15.10 及更高版本)(ReqHotAmpCPU * ReqInvolvedAMPCnt)

数字
分区

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

PartName 字符串
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) 数字
代理用户名

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

ProxyUser 字符串
请求计数

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

ReqCount 数字
请求 CPU

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

RequestAmpCPU 数字
请求 CPU 偏斜

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 及更高版本)100 * (1 - (RequestAmpCPU / ReqInvolvedAmpCnt) / ReqHotAmpCPU) 百分比
请求 I/O

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

RequestAmpI/O 数字
请求 I/O 偏斜

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 及更高版本)100 * (1 - (RequestAmpI/O / ReqInvolvedAmpCnt) / ReqHotAmpIO) 百分比
快照 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)) 百分比
快照 I/O 偏斜

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)) 百分比
Spool

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

Request_AmpSpool 数字
Spool 偏斜

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 及更高版本)100 * (1 – (Request_AmpSpool / (ReqHotAmpSpool * ReqInvolvedAMPCnt))) 百分比
开始

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

RequestStartTime 数字
状态

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

请参见《Teradata® Database 应用程序编程参考》中的“MONITOR SESSION Response Combinations”一章。 字符串
TEMP 空间

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

TempSpace 数字
不必要的 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) 数字
工作负载 TDWM.RuleDefs rulename 字符串

帐户字符串和用户指标

指标 计算 类型
Δ 请求计数

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

样本间请求计数的差值 数字

阻止程序指标

指标 计算 类型
阻止计数

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

阻止会话的计数 数字
阻止类型

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

如果是阻止程序会话且无 Blk_1_SessNo,则为根本原因。否则,如果任一 Blk_Status 具有“已授予”状态,则类型为“已授予”,否则为“正在等待”。 数字

实用程序指标

指标 计算 类型
LSN

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

LSN 数字
实用程序

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

LSN > 0 字符串
AMP CPU

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

RequestAmpCPU 数字
AMP I/O

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

RequestAmpI/O 数字

Vproc 指标

指标 计算 类型
PE

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

LogonPENo 数字
PE CPU

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

PECPUsec 数字
偏斜 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)) 百分比