HP ESO 3.0 User Guide

NOTE: With the current version of ESO, the Save/Rollback SQL Configuration feature only covers
the following parameters in the SQL Server page and the Network page:
SQL Server page
• MaxWorkerThreads
• Maximum Degree of Parallelism
• Lightweight Pooling
• Priority Boost
• Minimum Server Memory (MB)
• Maximum Server Memory (MB)
• CheckPoint
• Lock Pages in Memory
• Flight Recorder
• ResourceMonitoringEnabled
• Random File Access
• LowMemoryLimit
• TotalMemoryLimit
• CoordinatorQueryBalancingFactor
• CoordinatorQueryBoostPriorityLevel
• EnableRolapDistinctCountOnDataSource
Network page
• RSS Status
• Base RSS Processor
• Max RSS Processors
The following parameters are not covered by the Save/Rollback SQL Configuration feature:
• SQL Server — Xp_CmdShell
• Database — Auto Create Statistics
• Database — Auto Update Statistics
• Database — Auto Update Statistics Async
• Database (Database File) — AutoGrowth
• CPU — CPU Affinity
• SQL Server Startup — All trace flag status
• Storage — User Write Cache Setting
• Storage — Cache Power Protection
• Network — NUMA Node Affinity
• Network — Interrupt Affinity
• Network — Port Affinity
• Network — RSS Ring/Queue
Reports pages 53