Castelle Office Direct OfficeDirect Storage Server Installation Manual download pdf (Page 97)

Sage Sage Intergy 7.00 Install Guide 5 - 5

Chapter 5: Database Tuning

number of Sage Intergy users. This value is used to calculate other parameters as

described below.

• # Blocks in DB buffer - For all new installations, use 100,000 as the parameter value.

For post-installation tuning, you must obtain two values from the Sage Intergy

database server to calculate this parameter. Use the Windows task manager to

observe the amount of physical memory that is unallocated during peak database

usage. Then calculate the memory usage of the DB Buffer blocks by multiplying the

current value of this parameter by 4 KB. Add these two numbers to find out the

memory usage in the table below. This number corresponds to a parameter setting

that indicates the correct number of DB Buffer blocks that should be entered in the

Sage Intergy Database Properties window. If the number in the table does not match

the number used to calculate memory usage, change this parameter value.

For example, a customer site may be configured with 100,000 DB Buffer blocks and

is leaving 1.3 GB of memory unused during peak operation. 100,000 DB Buffer

blocks multipled by 4 KB equals 400 MB, for a total of 1.7 GB. This memory usage

number corresponds to the fourth line of the table, and that value indicates that the

DB Buffer blocks setting should be increased to 125,000

• # Lock table entries - This setting controls how many records can be locked in the

database for each transaction. It should be set to 200,000 for all environments.

However, there is a possibility that users may observe an error that indicates the lock

table overflow parameter should be increased. In this case, this number should be

doubled to 400,000 or 800,000 in order to resolve the error message. At no time

should the number of lock table entries exceed 800,000.

• Spin lock retries - This value determines the number of times a database process

will attempt to try accessing shared memory during each CPU cycle. If set incorrectly,

users will observe slow response from the application. By default, the spin lock retry

value is set to one in an untuned database and should be changed manually. To

maximize performance, calculate the spin lock value by multiplying the number of

CPU cores in the Sage Intergy database server by 50,000. For example, a database

server with a quad-core Xeon processor would have four CPU cores, and you would

therefore enter ‘200000’ for the spin lock retry value.

Table 1: Number of blocks in DB buffer setting

Unallocated physical memory +

(DB Buffer blocks x 4 KB)

Number of blocks

512 MB or less 25,000

Up to 1 GB 50,000

Up to 1.5 GB 100,000

Up to 2 GB 125,000

Up to 3 GB 150,000

Up to 4 GB 175,000

Over 4 GB 200,000

1 2 ... 92 93 94 95 96 97 98 99 100 101 102 ... 283 284

Comments to this Manuals

No comments

Castelle Office Direct OfficeDirect Storage Server Installation Manual Page 97

Comments to this Manuals

Related products and manuals for Servers Castelle Office Direct OfficeDirect Storage Server