HP ProLiant DL980 G7 Server User Manual

Page 53

Advertising
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

Advertising