Course ID 00071763
HP product number U4195S
Course format ILT
Course length 5 days
Skill level Expert
Delivery languages English
Related certifications
In preparation for these exams
Selected items from this course are included in these exams:
Register for this course.
Find this course in the Training calendar and click the “Register” link in the last column to begin your registration.

Course description

This course covers the system load balance approach and performance tuning concepts for the HP NonStop system. Learn how to capture and analyze performance data, then adapt the adjustments to maximize performance and increase system utilization. Topics include Measure, Measure Subsystem Entities, queuing theory, TPM, RPM, ViewSys, Web ViewPoint practical approaches to system tuning, and using performance tools. The course is 60 percent lecture and 40 percent hands on labs using NonStop servers.

Who should attend

• System managers, technical support, and performance analysis personnel
• Systems and application designers and developers

Prerequisites

For complete prerequisites and requirements to achieve any of the related certifications or upgrade paths, see the certification description on the HP ExpertOne website.

Topics

  • 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

Objectives

After completing this course, you should be able to do the following:
  • 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

How to register

View the HP ExpertOne Global Training Calendar to register for the trainings offering that best meets your needs.

Policies, fees and cancellations

Course fees may vary and are established and collected by the training center delivering the course. Cancellation fees may apply. Contact your HP Authorized Training Partner for their respective policies.