beautypg.com

HP ProLiant DL980 G7 Server User Manual

Page 53

background image

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