HP ProLiant DL980 G7 Server - Manual (Page 18)

Figure 15 Database Page
File Growth
The File Growth option specifies the method of incremental allocation applied when an operating
system file is extended. Possible values are OFF, KB, or % (Percent). SQL Server files can grow
automatically from their originally specified size. When you define a file, you can specify a specific
growth increment. Every time the file is filled, it increases its size by the growth increment. If there
are multiple files in a file group, they will not automatically grow until all the files are full. Growth
then occurs in a round-robin fashion. If necessary, the tool recommends allocation of larger space
in the file and turns off automatic file growth.
Database File on System Drive
HP ESO recommends that you store the database file in a different location than the system or OS
drive. If a database file is found on the system drive, HP ESO's recommendation to relocate the
file displays on this page.
Multiple Database File on a Drive
HP ESO also recommends that the database files are located on a dedicated drive. If multiple
database files are found on a drive, HP ESO's recommendation for relocating them on separate
drives displays on this page.
CPU
The CPU page displays SQL Server and IO affinity settings and recommendations for each SQL
instance in the system. To carry out multitasking, Microsoft Windows sometimes moves process
threads among different processors. Although this is efficient from an OS point of view, this activity
can reduce SQL Server performance under heavy system loads, as each processor cache is
repeatedly reloaded with data. Assigning processors to specific threads can improve performance
under these conditions by eliminating processor reloads and reducing thread migration across
processors (thereby reducing context switching). Such an association between a thread and a
processor is called processor affinity.
18 Using HP ESO