Document Outline

• HP Neoview Performance Analysis Tools
• 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
  • Uninstall the Neoview Performance Analysis Tools
  • Start the Neoview Performance Analyzer
  • Start the Neoview Query Viewer
  • Start the Neoview Query Workbench
  • Execute Queries in Neoview Command Interface
  • 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
    • 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
  • Processing Node Utilization
  • Processing Node Queue Length
  • Memory Usage
  • Cache Hits
  • System I/O Activity
  • 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 Options
  • 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
  • Configuring Neoview WMS Services and Rules With Live View
    • Monitoring Queries
      • 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
  • Neoview WMS Services Configuration
    • Services Details Log File
    • Neoview WMS Configuration
    • WMS Configuration Dialog
      • 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
        • 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
• 6 Use the Triage Space Pane
  • The Triage Space Pane At a Glance
  • Triage Space Settings
    • Switching Repositories
  • Query Candlestick Graph
    • Query Candlestick Graph Right-Click Menu
  • Triage Space Button Panel
  • Filter the Queries
  • Triage Space Data Grid
    • Triage Space Data Grid Right-Click Menu
  • Triage Space Query Details
  • Triage Space Statement Counters
  • Load Queries from the Triage Space to Query Workbench
• 7 Use the Query Workbench
  • Query Workbench Pane in NPA = Neoview Query Workbench
  • The Query Workbench At a Glance
  • Query Workbench Settings
  • Query List
    • Difference Between Checked or Selected Queries
  • SQL Text
    • Execute or Explain the Selected Query
    • Enter a New Query
    • Schema Drop Down
    • Maximum Rows Fetched
    • Rename the Query
  • 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
• 8 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
• 9 Keyboard Shortcuts
  • General Shortcuts
  • Menu Shortcuts
  • Workspace Shortcuts
  • View Shortcuts
  • Triage Space Shortcuts
• Glossary
• Index