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

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

SQL Server from paging (swapping) the data to virtual memory on disk or from trimming the data.

However, the Windows operating system can still page out the nonbuffer pool memory within the

SQL Server process. Locking pages in memory can improve server performance and responsiveness

when paging memory to disk occurs. By default, this setting is turned off on 64-bit systems.

NOTE: If the Database Engine instance is running under a local system account, Microsoft

Windows does not support turning off Lock Page.

Max Worker Threads

This parameter applies to the Data Warehouse Database engine only. Use this option to configure

the number of worker threads available to Microsoft SQL Server processes. Thread pooling helps

optimize performance when large numbers of clients are connected to the server. Usually, a separate

operating system thread is created for each query request. However, with hundreds of connections

to the server, using one thread per query request can consume large amounts of system resources.

The Max Worker Threads option enables SQL Server to create a pool of worker threads to service

a larger number of query request, which improves performance.

Xp_CmdShell

This parameter applies to the SAP Database Engine only. Some SAP transactions such as those

made by the database monitor need to execute the stored procedure xp_cmdshell. This fails

unless you have set the SAP Database Engine Xp_CmdShell configuration option to 1. To execute

the stored procedure, select On (this is equivalent to setting it to 1) at the drop down box, as shown

in Figure 34 (page 40).

Figure 34 Setting the Xp_CmdShell option

Analysis Services instance parameters

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

components to which the parameters apply.

Flight Recorder

SQL Server Analysis Services Flight Recorder provides a mechanism to record server activity into

a short-term log. Information captured by Flight Recorder can be helpful for troubleshooting specific

issues; however the load placed on the server when capturing the snapshots and trace events can

have a small impact on overall performance. For optimal performance, the flight recorder should

be disabled unless attempting to capture diagnostic information relevant to troubleshooting a

specific problem.

Random File Access

A Boolean property that indicates whether database files and cached files are accessed in random

file access mode. This property is disabled by default. By default, Analysis Services does not set

the random file access flag when opening partition data files for read access. On high-end systems,

particularly those with large memory resources and multiple NUMA nodes, it can be advantageous

40 Using HP ESO

1 2 ... 35 36 37 38 39 40 41 42 43 44 45 ... 81 82

Keine Kommentare

Hp ProLiant DL980 G7 Server Bedienungsanleitung Seite 40