会话指标
| 指标 | 源 | 计算 | 类型 |
|---|---|---|---|
| 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)) | 百分比 |