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

Figure 36 Database page

The following subsections describe database parameters and recommendations that might be seen

on the Database optimization page. Parameters pertaining to Availability Groups and database

mirroring are described in “Viewing high availability and disaster recovery configurations and

recommendations” (page 46). Cluster-related parameters (Cluster Network Name, Computer

Name, Status, and Computer Role) are described in “Clustered SQL Server instance” (page 49).

SQL Server Database Engine properties

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

components to which the parameters apply.

Growth

The Growth option specifies the method of incremental allocation (autogrowth) applied when an

operating system file is extended. To disable autogrowth, select OFF. To enable autogrowth, specify

the method of incremental allocation: either MB or % (Percent). SQL Server files can grow

automatically from their originally specified size. When you define a file, you can specify a specific

growth increment. Every time the file is filled, it increases its size by the growth increment. If there

are multiple files in a file group, they will not automatically grow until all the files are full. Growth

then occurs in a round-robin fashion. If necessary, the tool recommends allocation of larger space

in the file and turns off automatic file growth.

Auto Create Statistics

This parameter applies to the SAP Database Engine only. When you enable the

AUTO_CREATE_STATISTICS option (select ON), the Query Optimizer creates statistics on individual

columns used in a predicate, if these statistics are not already available. These statistics are

necessary to generate the query plan. They are created on columns that do not have a histogram

in an existing statistics object. To disable this parameter, select OFF.

Auto Update Statistics

This parameter applies to the SAP Database Engine only. Updates query optimization statistics on

a table or indexed view. Possible values are ON or OFF. By default, the query optimizer already

updates statistics as necessary to improve the query plan; in some cases, you can improve query

performance by using UPDATE STATISTICS or the stored procedure sp_updatestats to update

statistics more frequently than the default updates.

44 Using HP ESO

1 2 ... 39 40 41 42 43 44 45 46 47 48 49 ... 81 82

Keine Kommentare

Hp ProLiant DL980 G7 Server Bedienungsanleitung Seite 44