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

5 - 6 Sage Intergy 7.00 Install Guide Sage

Chapter 5: Database Tuning

To determine the number of virtual processors in a Windows system, open the

Windows Task Manager. In the View menu, make sure that the CPU history shows

one graph for each processor.

• Other server arguments - This field contains command line arguments that should

be changed by the installing technician. For all installs, enter the text

-basetable 1 -tablerangesize 1500 -shmsegsize 256 -napmax 250 to

set database timing and allow for logging of performance statistics.

• Service name or Port # - Set this value to ‘Intergy-db’ with no quotes.

• Maximum Servers per Broker - Accept the default value for this field. This value is

typically zero.

• Maximum Clients per Server - This value determines the number of client

connections allowed for each remote client server process. In most cases, the default

value of 4 should not be changed. On Sage Intergy servers with limited memory, this

number can be increased to allow for more client connections at the expense of

slower performance. This value may also need to be changed when setting the

maximum servers value.

• Minimum Clients per Server - This value should always be set to 1.

• Auto Calculate - Select this checkbox to activate the automatic calculation of the

Maximum Users and Maximum Servers fields. Use automatic calculation for Sage

Intergy 7.00 whenever possible.

• Maximum users - This setting represents the maximum number of database

connections, as opposed to the literal number of users. This is because client

workstations may establish multiple database connections when functions such as

reporting and imaging are used. This value is automatically configured when the Auto

Calculate checkbox is selected, and should be entered manually only for n-tier

environments or other special configurations of Sage Intergy.

When manually calculating this value, round up to the nearest integer value. Make

sure the maximum users setting is always larger than the multiplied product of the

Maximum Servers and the Maximum Clients Per Server values.

For sites where Intergy is installed without SIEHR, the base formula is

300 + (1.1 x 2a) where a is the number of serialized Sage Intergy users.

If SIEHR is installed and serialized, then the formula is 300 + (1.1 x 2a) + (1.1 x b/4)

where a is the number of serialized Sage Intergy users and b is the number of

serialized SIEHR users.

Example: A customer site has fifty Sage Intergy users and forty SIEHR users

serialized. The formula would be 300 + (1.1 x 2 x 50) + (1.1 x 40/4). The resulting value

of 421 would be entered in the Maximum Users field.

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

No comments

Castelle Office Direct OfficeDirect Storage Server Installation Manual Page 98