HP ProLiant DL980 G7 Server - Manual (Page 45)

Figure 39 RSS settings in Network Affinity page
SQL Startup Option page: Viewing and enabling startup options
A set of default startup options is written to the registry during SQL Server installation. Trace flags
are one form of these startup options. Use trace flags to temporarily set specific server characteristics,
or to switch particular SQL Server behaviors on or off. Trace flags can be used for a variety of
purposes. Many of them, if set appropriately for your environment and workload, can enhance
performance of the SQL Server.
Figure 40 (page 45) shows an example of the SQL Startup Option
page. The subsections that follow describe the trace flag startup options.
Figure 40 SQL Startup Option page
This Startup Option page provides a tab for each particular SQL instance. Clicking a tab displays
the trace flags available for that particular SQL instance.
Trace flags are very sensitive to the SQL Server edition and versions. Only trace flags supported
by the SQL instance are shown on the page with status. The page displays a description of each
supported trace flag.
Optimizations pages 45