Jump to content United States-English
HP.com Home Products and Services Support and Drivers Solutions How to Buy
» Contact HP
HP.com home
Education & Training  >  Find a course 

Performance Analysis and Tuning for HP NonStop Systems

» 

Education & Training
US & Canada

» Contact Us
» Register for a class
» Education Centers
» VILT/HP RAIL
» Onsite & Dedicated Training
» What's new
» Find a course
» Big Data
» Business Analysis & Project Management
» Cloud
» Data Center
» HP ExpertOne Customer
» HP ExpertOne Partner
» HP Integrity
» Graphic Solutions
» ITSM / ITIL
» Linux
» Microsoft
» HP Networking
» HP NonStop
» HP OpenVMS
» HP Project Odyssey
» HP ProLiant
HP BladeSystem
» Security
» HP Storage
» HP Tru64
» HP-UX
» Virtualization
» HP VISPEL-Video Training
» VMware
» HP Education Consulting
» Certification
» HP Virtual Rooms
» eLearning
» HP Software Education
Content starts here
At a glance
View schedule & enroll Sorted by: location or date
Course number U4195S
Length 5 days
Delivery method Remotely assisted instructional learning ( RAIL)
Instructor-led training ( ILT)
Onsite dedicated training ( OST)
Price USD $3,500
CAD $3,850

Course overview


Become familiar with the system load balance approach and performance tuning concepts for your 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 5-day course is 60 percent lecture and 40 percent hands-on labs using NonStop servers.

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

Ways to save


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

Next Steps


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

U4195S J.00
Privacy statement Using this site means you accept its terms Feedback to Education & Training
© 2014 Hewlett-Packard Development Company, L.P.