TPDC Manual (G06.24+)
Table Of Contents
- What’s New in This Manual
- About This Manual
- 1 TPDC Overview
- TPDC Components and Architecture
- Tandem Performance Data Collector (TPDC)
- Tandem Performance System File Label (TPSFL)
- Tandem Performance File Label (TPFL)
- Tandem Performance Load Measure (TPLM)
- Tandem Performance Load Data (TPLD)
- System Performance Analysis Using Measure (SPAM)
- Tandem Performance Deferred Processing (TPDP)
- Data Files (RWS, DWS, UWS)
- How TPDC Collects Data
- Example: Scheduling TPDC Data Collection
- TPDC Components and Architecture
- 2 Installing and Running TPDC
- 3 Using the Collected Data
- 4 Using the System Configuration Reports
- 5 Using the SPAM Performance Data Charts and Reports
- Overview of the Charts and Reports
- Performance Data Charts
- Acceleration Profiles of User Programs (AXLCHRT)
- Apportioned Program CPU Consumption (WKLOAD)
- Average CPU Utilization (ACUCHRT)
- Average Disc Utilization (ADUCHRT)
- Data Communications Line Overview (DATACOM)
- Disc Cache Performance (DCPCHRT)
- Disc File Block Splits Shares (BLKSPLT)
- Disc File I/O Activity Distribution (DFIODST)
- Disc File Overview (Alphabetic) (DFOATBL)
- Disc File Physical I/O Shares (DFPIOS)
- Disc File ‘Requests Blocked’ Shares (REQBLKD)
- Disc File System I/O Shares (DFSIOS)
- Disc I/Os per Second (DIOCHRT)
- Disc Response Time (DRTCHRT)
- EXPAND Communications Line Overview (EXPAND)
- Global Indicators (COVER)
- Logical Disc File I/O Wait Shares (LDFIOWT)
- SQL/MP Program Overview (SQLPROG)
- SQL/MP Statement Overview (SQLSTAT)
- Process Category Counts (PCOUNTS)
- Process/CPU Priority Distribution (PRIDIST)
- Program Disc File I/O Wait Shares (PGDIOWT)
- Program Logical File Open Shares (PGOPENS)
- Program Logical I/O Wait Shares (PGLIOWT)
- Program Overview (PGOVIEW)
- Program Spooler File I/O Wait Shares (PGSPLWT)
- Relative CPU Balance (RCBCHRT)
- Relative Disc Balance (RDBCHRT)
- TMF Overview (TMFVIEW)
- Performance Data Reports
- Busiest Disc Files (Logical I/O Wait Time, Overall) (IOWOVER)
- Busiest Disc Files (Logical I/Os, by Volume) (LIOBVOL)
- Busiest Disc Files (Physical I/Os, by Volume) (PIOBVOL)
- Busiest Disc Files (System I/Os, by Volume) (SIOBVOL)
- Busiest Processes (by CPU) (PBSYCPU)
- CPU Activity (CPUREPT)
- Disc Cache 1 (Activity, by Block Size) (CACHE1)
- Disc Process Activity (DPREPT)
- Disc Subsystem Activity (DSCREPT)
- EXPAND Network Line Activity (NETREPT)
- Global Indicators (COVER)
- Low Selectivity (Needle in a Haystack) SQL Table Access Report (HAYSTCK)
- Network System Activity (SYSREPT)
- New Process Creation Timeline (NEWPROC)
- PATHWAY System Processes (PATHWAY)
- Physical Disc I/O Activity (PDISCIO)
- Process Existence Timeline (PTIMLIN)
- Process Memory Utilization (by CPU) (PMEMCPU)
- Process Page Faults (by CPU) (PFLTCPU)
- Server Summary (from $RECEIVE File) (SERVICE)
- TMF Activity Report (TMFREPT)
- A Entity and Attribute Definitions
- B Cross-Reference of Enform Queries to Data Files
- C Enform Query Source File (QPGROUPS)
- Index
Using the SPAM Performance Data Charts and
Reports
Tandem Performance Data Collector (TPDC) Manual—526357-001
5-76
Server Summary (from $RECEIVE File) (SERVICE)
Server Summary (from $RECEIVE File) (SERVICE)
This 132-column report summarizes server process information, including the average
time that requests for service spent waiting in process message input queues and the
estimated service times and utilization levels of server processes. The report includes:
•
The NonStop Kernel process name of the server process
•
The process identification
•
The execution priority of the process
•
The server program object file name
•
The times at which measurement of the process began and ended
•
The number of transactions per second handled by the process
•
The average time that requests for service waited in the process message queue
•
The estimated average service time of the process; the difference between the
time the process began working on a new transaction and the time it completed
work on that transaction
•
The estimated utilization of the process
•
The total number of logical file opens matched to the process
•
Logical I/O requests to measured files (by Measure)
•
Time spent actively using the CPU, waiting to use the CPU, and waiting for
Memory Manager service
•
Time spent waiting for completion of logical I/O requests to measured files
This report uses the CPUX, SERVER, and FILE entities.
Process Page Fault Activity (by CPU) Report for System \P20ET (C30)
-------------------------------------------
Process PID Pri Program File Name (headings continued below)
-------- ==---- --- --------------------------
<none> 0,172 139 $SYSTEM .SYSTEM .SQLCI (data continued below)
$W012 0,191 135 $USER01 .OPAXOBJ .OPAS012A
<none> 0,174 150 $SYSTEM .SYSTEM .SQLCOMP
<none> 0,194 139 $SYSTEM .SYSTEM .SQLCOMP
<--MemQ Secs--> <-Page Faults-> <-Flts/Sec--> <--Mem Pages--> CPU <-Rdy:Bsy->
* Indivdl Cuml've Indivdl Cuml've Indvdl Cumlve Average Maximum Busy(%) Total -MemQ
- ======= ------- ------- ------- ------ ------ ------- ------- ------- ----- -----
* 1.2 1.2 66 66 .02 .02 48 138 .00 23.6 6.1
.8 1.9 123 189 .03 .05 117 198 .01 5.0 2.8
* .4 2.3 445 634 .12 .18 50 577 .08 3.5 3.4
* .1 2.4 62 696 .02 .19 11 129 16.2 11.6
------- ------- ------ ------- ------- -------
2.4 696 .19 226 1042 .09