»
At a glance
View schedule & enroll
Sorted by: location or date
Course number
U4195S
Length
5 days
Delivery method
Remotely assisted instructional learning (
RAIL
RAIL )
ILT
ILT )
OST
OST )
Price
USD $3,500
Prerequisites
Concepts and Facilities for Nonstop Systems (U4147)
NonStop NB-series Server Administration I (HG776) and NonStop
NB-series Server Administration II (HG777) or Equivalents
Audience
System managers, technical support, and performance analysis personnel
Systems and application designers and developers
Benefits to you
Learn how to regularly monitor your Integrity
systems and quickly recognize problems so users
experience smooth functioning IT operations
Effectively utilize the range of available
performance tools
Learn practical performance tuning procedures
reinforced through extensive hands-on lab sessions
Optimize your Integrity systems by identifying and
removing performance bottlenecks
Course Objective
At the conclusion of this course you should be able to:
Apply a basic tuning principle
Analyze Measure's CPU entity
Describe the processor's memory subsystem
Apply several basic queuing theory formulas
Analyze disk cache-hit ratios and fragmentation
Calculate a volume's true write cache-hit ratio
Use Reload Analyzer
Analyze process priorities
Analyze process memory consumption
Identify processes with long $RECEIVE queues Evaluate TCP process and server class parameters for best performance
Be familiar with the functionality of NonStop system utilities: ViewSys, Web ViewPoint, Peek,
Enform, GPA, TPDC, TPM, ASAP, APB, Diskpro, RPM, and TCM
Use Measure and SQLCI to analyze NonStop SQL/MP performance
Identify positive and negative factors in application performance
Use Measure entities for application analysis: DISCOPEN, FILE, PROCESSH, USERDEF, and TMF
Detailed Course Outline
Module 1 - Performance Analysis Introduction
OLTP versus batch processing
Service-Level Agreement (SLA)
General tuning procedure
Basic tuning principle
Two aspects of response times
System diagrams
Application Diagram
Measure Subsystem Processes
Measure Subsystem Files
Measure Subsystem Counters
Measure Subsystem — Counter units
Updating a Measure Data File
Measure Entities
Measure and Open System Services (OSS)
Measure and SQL/MX
Key Performance Manuals
Lab: Meascom and MEASFT
Module 2 - CPU Subsystem
HP NonStop Systems
NonStop Multi-core Architecture (NSMA)
NSMA Terminology
NB50000c and NB54000c BladeSystems
NonStop Operating System for NSMA
NS-series and NB-series System Architecture
NonStop System Processor Types
Meascom Output for CPU Entity
NSMA and the CPU Entity
New CPU COUNTER fields
Changed CPU COUNTER fields
CPU Subsystem - Ready List
NSMA Scheduling and Dispatching
NSMA Process Scheduler
PUCOM
QTIME Counters
Processor’s Memory Subsystem
Processor’s Disk Subsystem
CISC Versus EPIC
CPU’s Processes
Remaining CPU Counters
CPU Matrix
LIST CPU with PROCESSH active
Lab: IPUCOM and CPU matrix
Module 3 - Queuing Theory
Queues in NonStop Components
Queueing Theory Factors
Basic Model
Notation
Queue Length Versus Utilization
Relative Response Time Versus Utilization
QUEUEING formula
Actual Response Time Versus Utilization
Key Lessons from Queuing Theory
Non-Random Arrival Pattern for Processors
Processor Arrivals Pattern
Module 4 - Disk Subsystem
FCDM Subsystem
NS-series Disk Architecture
Meascom Output for DISC Entity
Disk Subsystem
Disk Reads Versus Writes
Disk Cache
Analyzing Cache Performance
Altering Cache Settings
SCF INFO/ALTER DISK
Meascom Output for SERVERNET Entity
NS-series Disk Paths
Disk Load Flexibility – NS-series
CLIM Product Overview
Storage and IP Cluster I/O Module (CLIM)
Distributed Disk Processes
CLIM Hardware Product Overview
IP CLIM
Storage CLIM
SERVERNET Command Line
New SERVERNET Node Classes
SERVERNET Port and Fiber
SERVERNET – New Counters
SERVERNET Command Line Examples
LIST SERVERNET (CLMI - IP)
LIST SERVERNET (CLMS - Storage)
DISC Examples
LIST DISC Display Example
Storage Management Foundation
Disk Fragmentation
DCOM
Lab: DISK matrix
Module 5 - Disk Files
Obtaining File Information
FUP INFO, DETAIL - SQL/MP
FUP INFO, DETAIL - SQL/MX
ENSCRIBE Structured Files
File Formats
Key-Sequenced File Structure
File Buffering
Rules for File Buffering
Sync-depth - SD
Data Integrity Risk for Buffered, Unaudited Files
Measure’s File-oriented Entities
Meascom Output for DISKFILE Entity
Write Cache-hit Ratio for a Volume
Finding Unbuffered Files
Finding Heavily-read Files
Other DISKFILE Counters
Enscribe Alternate-Key Files
File Partitioning
File Block Structure — FUP INFO, STAT
Other Enscribe File Attributes
File Fragmentation
File Disorganization
Reload Analyzer — TRA
FUP RELOAD
Labs: DISK and DISKFILE; Reload Analyzer (TRA)
Module 6 - Processes
RUN Command
Process Priorities
Mixed Workload Enhancement (MWE)
MWE — Impact on Priority Selection
Meascom Output - PROCESS
New ID Fields NSMA
New PROCESS COUNTER Field for NSMA
Process CPU Activity
Process Memory Activity
Process Message Activity
Process Execution Modes
Process Matrix
Lab: Process Matrix
Module 7 - Pathway Tuning
Pathway Overview
TCP Memory Structure
TCP Process Attributes
CONTROL TCP Comman
TCP Statistic
Terminal Statistic
Server Basics
Server Class Attributes
Linkers
LINDEPTHS and MAXLINKS
Linking Algorithm - Rank and Weight
Linking Algorithm - Example
PATHCOM STATUS SERVER, DETAIL
PATHCOM STATUS SERVER, PROCESSES
Server Queues
Server Queues and MAXSERVERS
Other Methods for Setting MAXSERVERS
Dynamic Server Processes
CPU Assignments
Process Priorities
Naming Server Processes
Server Statistics
Application Cluster Services (ACS)
Lab: Pathway Tuning
Module 8 - Other NonStop System Performance Tools
ViewSys
Web ViewPoint
Peek
Enform
Guardian Performance Analyzer (GPA)
Tandem Performance Data Collector (TPDC)
Tandem Performance Management (TPM)
Availability Stats and Performance (ASAP)
Automatic Process Balancer (APB)
Disk Prospector (Diskpro)
Real-time Process Monitor (RPM)
RPM Architecture
RPM peer-to-peer example in a 3-node network
RPM – Three versions of the RPM command Interpreter (CI)
RPM examples
Tandem Capacity Model (TCM)
Lab: Real-time Process Monitor (RPM)
Module 9 - NonStop SQL/MP Tuning
NonStop SQL/MP overview
Fundamental issues
Creating base tables
Indexes
SQLCI FILEINFO
Measure Entities for SQL/MP and SQL/MX
Meascom Output for SQLPROC Entity
Statement Selectivity
Statement Selectivity
Meascom Output for SQLSTMT Entity
Meascom Output for FILE Entity
SQLCI UPDATE STATISTICS
FUP RELOAD of SQL/MP Tables
SQLCI DISPLAY STATISTICS
SQLCI EXPLAIN
Sequential Block Buffering — RSBB and VSBB
SQLCOMP Compiler Options
CONTROL TABLE Options
CONTROL EXECUTOR Options
CONTROL QUERY Options
Access Options
Sequential Prefetch
Comparison: SQL/MX and SQL/MP
ANSI Logical Names
MXCI Basics
SQL/MX Disk Factors
Compile Time Factors
Displaying Query Statistics
Displaying Query Execution Plans
Explain Plan in VQP
Query Plan Caching
Improving Query Performance
Histogram Settings
Query Settings
Query Plan Cache Settings
Recompilation Settings
System Defaults Table
CONTROL QUERY DEFAULT
CONTROL TABLE
Updating Statistics
UPDATE STATISTICS
Good Practices
Module 10 - Application Tuning
Process Performance — Negative Factors
Process Performance — Positive Factors
Application Structure Problems
Meascom Output for DISCOPEN Entity
Meascom Output for FILE Entity (Guardian)
Meascom Output for FILE Entity (OSS)
Meascom Output for PROCESSH Entity
Meascom Output for USERDEF Entity
Meascom Output for TMF Entity
Remote Database Facility (RDF)
Lab: TPDC
Onsite Delivery Equipment Requirements
NonStop server with four processors and six disk volumes G06.28, H06.15, J06.04 or
later with Measure, TPDC, and RPM installed
Private class requests:
Might require up to two days set-up time on a customer system prior to the class
Access to a super.group logon for the instructor
