Document Outline

• HP Enterprise SQL Optimizer (HP ESO) 3.6 User Guide
• Contents
• 1 Introduction
  • Benefits of using HP ESO
  • Main features of HP ESO
  • New features in release 3.6
  • New features in release 3.5
  • New features in release 3.0
  • New features in release 2.0 and 2.1
• 2 Installing HP ESO
  • Software requirements
  • Installing the software
  • Uninstalling the software
  • Upgrading the software
  • Silent installation
• 3 Configuring user accounts to enable access to SQL Server and Analysis Services instances
  • Set user account privileges in Database Engine security
  • Set user account privileges in Analysis Services security
• 4 Using HP ESO
  • Getting started
    • Launching HP ESO
    • Getting Started pages
      • HP ESO Introduction page
      • HP ESO SQL Login page
    • Quick start: Tasks performed in a typical HP ESO user session
    • Floating help for items on a page
    • Starting an authenticated Administrator Session (Admin Session)
    • SQL Login page: Setting credentials and logging in to SQL Server and Analysis Services instances
    • Modifying the Admin Session timeout value
  • Settings pages: Setting parameters for data collection
    • Data Collection page: Collecting data for analysis and optimization recommendations
  • Optimizations pages: Viewing and controlling optimization recommendations
    • Summary page: Viewing recommended optimization values for settable parameters obtained from all optimization pages; generating a PowerShell script for setting these recommended values
      • Modifying how the Summary page displays and generates recommended values
      • Downloading the PowerShell script
    • SQL Server page: Viewing and controlling SQL Server and Analysis Services parameters and optimization recommendations
      • SQL Server database instance parameters
        • Max Degree of Parallelism
        • Lightweight Pooling
        • Priority Boost
        • Min Server Memory (in MB)
        • Max Server Memory (in MB)
        • Recovery Interval
        • Lock Page
        • Max Worker Threads
        • Xp_CmdShell
      • Analysis Services instance parameters
        • Flight Recorder
        • Random File Access
        • Low Memory Limit
        • Total Memory Limit
        • Coordinator Query Balancing Factor and Coordinator Query Boost Priority Level
        • Enable Rolap Distinct Count On DataSource
        • Process Min Threads
        • Vertipaq Memory Limit
        • Resource Monitor
        • Server modes (Multidimensional Mode, Tabular Mode, Sharepoint Mode)
    • Database page: Viewing and controlling database parameters and optimization recommendations
      • SQL Server Database Engine properties
        • Growth
        • Auto Create Statistics
        • Auto Update Statistics
        • Auto Update Statistics Async
      • Analysis Services properties
        • Tabular Compatibility Level Number
        • Data Dir
        • Temp Dir
        • Log Dir
        • Measure Group
        • Partition
        • Estimated Rows
        • Estimated Size
        • Proactive Caching
      • ESO database recommendation statements
        • Database File on OS Drive
        • Multiple Files
        • Create Column Store Index
        • tempdb Data File
        • Split the Partition
        • Enable Proactive Caching
      • Viewing high availability and disaster recovery configurations
        • Availability Group
        • Mirrored database
        • Clustered SQL Server instance
          • Cluster Network Name
          • Computer Name
          • Status
          • Computer Role
    • CPU page: Viewing and controlling CPU assignment parameters and optimization recommendations
      • Database Engine Processor Affinity
        • Viewing and understanding Database Engine Processor Affinity
        • Modifying and setting Database Engine Processor Affinity
      • Analysis Services Process GroupAffinity
    • SQL Startup Option page: Viewing and controlling SQL Server startup options
      • Trace flag 8048
      • Trace flag 834
      • Trace flag 1117
      • Trace flag 1118
      • Trace flag 2371
      • Trace flag 2549
      • Trace flag 2562
    • Storage page: Viewing and controlling storage parameters and optimization recommendations
      • Database RAID level
      • User Write Cache Setting
      • Cache Power Protection
      • Drive free space
      • Volume mount point
      • Drive Latency
    • Network page: Viewing and controlling network parameters and optimization recommendations
      • NUMA Node Affinity and Interrupt Policy
      • Port affinity
      • Receive-Side Scaling
      • NIC teaming
        • Configuring a NIC team
        • Modifying a NIC team
        • Deleting a NIC team
        • Viewing NIC teaming information and recommendations on the Network page
    • System page: Viewing and controlling system parameters and optimization recommendations
      • PCI Controller Information
      • Software Discovery
      • System software and firmware status
  • Reports pages: Viewing workload/performance data and saving/restoring SQL configurations
    • Workload and Performance History
    • Save/Rollback Configuration
  • Help pages: Viewing and searching help topics
    • Accessing online help
    • Using the online help Welcome page
    • Using the help search facility
  • Using a PowerShell script to apply all recommended optimization values of settable parameters and to initialize software discovery
    • Using the PowerShell script to apply HP ESO optimization recommendations for all settable parameters
    • Using the PowerShell script to initiate software discovery
• 5 Troubleshooting
  • HP ESO is not found on the SMH page and HP Enterprise SQL Optimizer is in Disabled state in the service list
  • Access to SQL Server or Analysis Services instance is denied
  • PowerShell script fails
• 6 Support and other resources
  • Contacting HP
    • Before you contact HP
    • HP contact information
    • Subscription service
  • New and changed information in this edition
  • Related information
  • Typographic conventions
• 7 Documentation feedback