HP ProLiant DL980 G7 Server - Manual (Page 19)

Figure 20 SQL Startup Option Page
This Startup Option page provides a tab for each particular SQL instance. Clicking on a tab
displays the trace flags available for that particular SQL instance.
Trace flags are very sensitive to SQL server edition and versions. Only trace flags supported by
the SQL instance are shown on the page with status. Detailed description on each supported trace
flag is displayed on this page.
To change the status of an individual trace flag, select a new value from the drop down box and
click SET.
CAUTION: Each trace flag covers a very specific field and requires certain conditions to work.
Caution should be used when turning a trace flag on or off.
Trace Flag 8048
Enable Trace flag 8048 (TF-8048) to use memory allocation at the CPU level in order to reduce
costs when you have too many CPUs per NUMA node.
Optimizations Pages
This Optimizations page provides links to various types of optimizations.
IMPORTANT: It is highly recommended that you run Data Collection before visiting or modifying
the Optimization links.
In all of the optimization pages, HP ESO displays the following values or controls:
•
N/A
⇒ No recommendation can be provided for the parameter at the current state and
environment.
•
Current Value
⇒ The current parameter value discovered in the system.
•
Recommended Value
⇒ The parameter value recommended by HP ESO.
•
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.
Optimizations Pages 19