Document Outline

• HP Neoview Performance Analysis Tools User Guide
• Table of Contents
• Learn About This Document
  • Publishing History
  • New and Changed Information in This Edition
  • Intended Audience
  • Related Documentation
    • Neoview Customer Library
  • Resources on the Web
  • Send Feedback to HP
• 1 Install and Start the HP Neoview Performance Analysis Tools
  • What are the HP Neoview Performance Analysis Tools?
  • Install the Neoview Performance Analysis Tools
  • Start the Neoview Performance Analyzer
  • Start the Neoview Query Viewer
  • Start the Neoview Query Workbench
  • Execute Queries
  • Exit Any Neoview Performance Analysis Tool
• 2 Use the Workspace
  • Neoview Performance Analyzer Workspace
    • What is a Workspace?
  • Content Area of the Neoview Performance Analyzer Workspace
    • The Neoview Pane
      • The Workspace Toolbox
    • The Live View Pane
    • The Triage Space Pane
    • The Query Workbench Pane
  • Create a New Workspace
  • Start a Workspace
  • Define the Layout for the Workspace
  • Save a Workspace Layout
  • Close a Workspace
  • Open a Workspace
  • The Workspace At a Glance
    • Workspace Title
    • Menu Bar Commands
      • Use the Workspace Menu Options
      • Use the Edit Menu Options
      • Use the Tools Menu Options
      • Use the Windows Menu Options
      • Use the Display Menu Options
      • Use the Help Menu Options
    • Task Toolbar
    • Workspace Toolbox
  • Rename a Workspace
  • Lock a Workspace
  • Set Workspace Options
  • Add Another Workspace
  • Connect to the Neoview Platform
  • Disconnect/Reconnect to the Neoview Platform
• 3 Use the Workspace Toolbox
  • The Workspace Toolbox At a Glance
    • Add Tools
    • Aggregate Functions
  • System Metrics Tool
  • Processing Node Utilization Tool
  • Processing Node Queue Length Tool
  • Memory Usage Tool
  • Cache Hits Tool
  • System I/O Activity Tool
  • Workload Metrics
  • Timeline Controller
    • Select Time Periods From the Timeline Controller
• 4 Use the Neoview Pane
  • Neoview and Customized Views
  • The Neoview Pane At a Glance
  • Select Content to Analyze
  • Adjust Time Settings
  • Delete Tools and Graphs
  • Add a Customized View
  • Rename a Customized View
  • Delete a View
  • Other Tasks on Graphs
• 5 Use the Live View Pane
  • Live View Pane in NPA = Neoview Query Viewer
  • The Live View Pane At a Glance
  • Configure Live View
  • Customize the Live View
  • Kill Queries
  • Actions on Live View Queries
  • Notification Bubbles
  • Pause the Display
  • Load Queries from Live View to the Triage Space
  • Thresholds and Alerts
    • Client Thresholds Rule Manager
    • Threshold Rule Creation Wizard
      • Workspaces Tab
      • Conditions Tab
      • Actions Tab
    • Running Threshold Rules
• 6 Neoview Workload Management Services (WMS) Configuration
  • Configuring Neoview WMS Services and Rules With Live View
    • Monitoring Queries
      • Session Statistics
      • Time-Based Metrics
      • Rate-Based Metrics
      • Compile-Time Metrics
      • Run-Time Metrics
      • Miscellanous Facts
      • Rule Warnings
      • Per-Table Statistics
      • Get Query Text
    • At-A-Glance System Summary Information
      • Statement Counter Summary Information
      • Service Counters Summary Information
      • Platform Status Counters Information
    • Statement and Service Counter Details
  • Services Details Log File
  • Neoview WMS Configuration
  • WMS Configuration Dialog
    • Neoview WMS System Configuration Fields
    • View or Alter the WMS System Configuration
  • Managing Services
    • View Summary of All Services
      • Services User Interface
    • Add a New WMS Service
    • Alter an Existing WMS Service
    • Delete a WMS Service
    • Start a WMS Service
    • Stop a WMS Service
    • Hold a WMS Service
    • Release a WMS Service
  • Managing Rules
    • View Summary of All Rules
      • Rules Summary Interface
        • Fields in the Rules Summary Dialog Box
      • Add a New Rule
        • Add a New Connection Rule
        • Add a New Compilation Rule
        • Add a New Execution Rule
        • Alter Existing Rule
        • Delete a Rule
    • Associate Rules to Services
  • Managing Admin Roles
    • View Summary of All Admin Roles
      • Admin Role Summary Interface
      • Add Admin Role
      • Delete Admin Role
    • Save/Export WMS Configuration
    • Character Set Support
• 7 Use the Triage Space Pane
  • The Triage Space At a Glance
  • Triage Space and Query Viewer Settings
    • Switching Repositories
  • Query Candlestick Graph
    • Query Candlestick Graph Shortcut Menu
  • Triage Space Button Panel
  • Filter the Queries
  • Triage Space Data Grid
    • Triage Space Data Grid Shortcut Menu
  • Triage Space Query Details
  • Triage Space Statement Counters
  • Load Queries from the Triage Space to Query Workbench
• 8 Use the Query Workbench
  • Query Workbench Pane in NPA = Neoview Query Workbench
  • The Query Workbench At a Glance
  • Query Workbench Settings
  • Query List Box
    • Difference Between Checked or Selected Queries
  • SQL Text Box
    • Execute or Explain the Selected Query
    • Enter a New Query
    • Schema Drop Down
    • Maximum Rows Fetched
    • Rename the Query
  • Statistics
  • Table Statistics
  • Query Workbench Query Details
    • Explain Plan
      • Operator Groups
    • Analyze the Explain Plan Through the Grid
    • About the ESP_EXCHANGE and HYBRID_HASH_JOIN Operators
    • Process Boundaries
      • Process Architecture For a Query
    • Plan Summary and Operator Details
    • Execute Output
• 9 Tips for Query Plan Performance Improvements
  • Determine the Base Table Access Strategy
  • When to Change the Default Aggregate Function
  • Improve File Scan Performance
  • Improve Index Scan Performance
  • Significance of Hash Key Columns
  • Significance of Primary Key Columns
• 10 Keyboard Shortcuts
  • General Shortcuts
  • Menu Shortcuts
  • Workspace Shortcuts
  • View Shortcuts
  • Triage Space Shortcuts
• Glossary
• Index