Hp ProLiant DL980 G7 Server Manual de usuario descargar pdf (Pagina 16)

• New Value ⇒ This field contains the new parameter value to be applied to the system. By

default, this field contains the recommended value. However, you can change this value if

desired.

• SET ALL button ( ) ⇒ Sets all of the parameters shown in the New Value fields on the

page. Click this button to make the changes take effect immediately. Changes requiring a

system or SQL Server service restart are indicated after the changes are applied.

• SET button ( ) ⇒ Sets the specific parameter shown beside it. Click this button to make

the change take effect immediately. Changes requiring a system or SQL Server service restart

are indicated after the change is applied.

• Enable Parameter Change check box ( ) ⇒ When checked, allows the corresponding

parameter to be changed. When unchecked, the parameter retains its current value after

clicking the SET or SET ALL buttons.

• Select/Unselect All check box ( ) ⇒ When checked, causes the parameter changes

enablement check boxes under its section to toggle between Selected and Unselected.

• Expand and Collapse buttons ( and ) ⇒ Expand or Collapse a section in a page.

SQL Server

The SQL Server page contains recommendations for setting SQL Server parameters.

Figure 14 SQL Server Page

Maximum Degree of Parallelism

When SQL Server runs on a system with more than one microprocessor or CPU, it detects the best

degree of parallelism. Specifically, it recognizes the number of processors employed to run a single

statement, for each parallel plan execution. Use the Max Degree of Parallelism option to limit the

number of processors to use in parallel plan execution.

16 Using HP ESO

1 2 ... 11 12 13 14 15 16 17 18 19 20 21 ... 26 27

Sin comentarios

Hp ProLiant DL980 G7 Server Manual de usuario Pagina 16