HP ProLiant DL980 G7 Server - Manual (Page 23)

Maximum Server Memory (in MB)
The Maximum Server Memory option specifies the maximum amount of memory SQL Server can
allocate when it starts and while it runs. Set this option to a specific value if you know there are
multiple applications running at the same time as SQL Server and you want to guarantee these
applications have sufficient memory to run. If these other applications, such as Web or e-mail
servers, request memory only as needed, then do not set the option because SQL Server will release
memory to them as needed. However, applications often use whatever memory is available when
they start and do not request more if needed. If an application that behaves in this manner runs
on the same system at the same time as SQL Server, set the option to a value that guarantees the
memory required by the application is not allocated by SQL Server.
Check Point
The Check Point option writes all dirty pages for the current database to disk. Dirty pages are data
pages that have been entered into the buffer cache and modified, but not yet written to disk. Check
points save time during a later recovery by creating a point at which all dirty pages are guaranteed
to have been written to disk.
Database
The Database page contains parameters related to database files in each SQL Server instance.
Figure 23 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, MB, 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.
Optimizations Pages 23