HP ProLiant DL980 G7 Server - Manual (Page 60)

One effect of using this trace flag is that the space requirements for tempdb may increase. The
tempdb may grow to as much as 5% or more of the user database that is being processed by the
DBCC CHECKDB
command. Therefore, to avoid automatic growth when you use this trace flag,
which may slow down the performance of the DBCC CHECKDB command, HP recommends that
you pre-size tempdb to at least 5% of your database size. HP ESO recommends and displays this
flag for SAP instances only.
Storage page: Viewing and controlling storage parameters and optimization
recommendations
The Storage page displays recommendations for different storage parameters. Figure 48 (page 60)
shows an example of a Storage page.
Figure 48 Storage page
The following subsections describe some of the parameters affecting storage optimization.
Information about some parameters might not be displayed, depending on the availability of the
components to which the parameters apply.
Database RAID level
This parameter is for information purposes only; it is not settable using HP ESO. HP highly
recommends that tempdb files and log files for user databases be on physical disks with RAID 1
+ 0 or RAID 1.
User Write Cache Setting
This setting enables write caching to improve disk performance, but a power outage or equipment
failure might result in data loss or corruption.
Cache Power Protection
Some storage controllers provide an option to enable cache power protection. Using a backup
battery, a storage controller can keep data in volatile memory intact, even during power
interruptions. This protects cached data even during power failures.
Drive free space
This parameter is for information purposes only; it is not settable using HP ESO. When drive free
space reaches less than 20%, a Warning message displays, with a recommendation to either
move the file to a larger drive or free up more space on the current drive.
60 Using HP ESO