Hp ProLiant DL980 G7 Server Bedienungsanleitung PDF herunterladen (Seite 38)

SQL Server database instance parameters

Information about some parameters might not be displayed, depending on the availability of the

components to which the parameters apply.

NOTE: Cluster-related parameters (Cluster Network Name, Computer Name, Status, and Computer

Role) are described in “Clustered SQL Server instance” (page 48).

Max 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 (MAXDOP) option

to limit the number of processors to use in parallel plan execution.

Lightweight Pooling

Use the Lightweight Pooling option to reduce system overhead associated with the excessive context

switching sometimes seen in symmetric multiprocessing (SMP) environments. When excessive

context switching is present, lightweight pooling can provide better throughput by performing the

context switching inline, thus helping to reduce user/kernel ring transitions.

Priority Boost

Use the Priority Boost option to specify whether Microsoft SQL Server should run at a higher

Windows Server 2008, Windows Server 2008 R2, or Windows Server 2012 scheduling priority

than other processes on the same system. If you set this option to 1, SQL Server runs at a priority

base of 13 in the scheduler. The default is 0, which is a priority base of 7.

Min Server Memory (in MB)

Use the Min Server Memory option to specify whether SQL Server should start with at least the

minimum amount of allocated memory and not release memory below this value. Set this value

based on the size and activity of your SQL Server instance. Always set the option to a reasonable

value to ensure the operating system does not request too much memory from SQL Server and

inhibit Windows performance.

Max Server Memory (in MB)

The Max 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.

Recovery Interval

The Recovery Interval 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.

Lock Page

Lock Page is a setting for use on 64-bit operating systems. When this setting is enabled, Windows

retains the SQL Server process working set (the committed, buffer pool memory) in physical memory

until the application in use frees the memory or exits. The Windows operating system prevents the

38 Using HP ESO

1 2 ... 33 34 35 36 37 38 39 40 41 42 43 ... 80 81

Kommentare zu diesen Handbüchern

Keine Kommentare

Hp ProLiant DL980 G7 Server Bedienungsanleitung Seite 38

Kommentare zu diesen Handbüchern

Verwandte Produkte und Handbücher für Computerhardware Hp ProLiant DL980 G7 Server