Locked 1 post Page 1 of 1
Calculating & Reviewing CAPITAL Corporate Server Setting
  • COBS Tech Support
    Posts: 683
    Joined: Fri Sep 09, 2005 8:23 am

    Calculating & Reviewing CAPITAL Corporate Server Setting

    by COBS Tech Support » Thu Feb 16, 2006 8:13 am

    It is important to configure and then review the Advantage Database Server's database configuration settings in order to avoid client side run-time error messages or poor or less than optimal system performance.

    To access these configuration settings, from the server computer's Start menu select:

    All Programs
    Advantage Database Server
    ADS Configuration Utility

    Click on the Configuration Utility tab button.

    Number of Connections

    Assuming a 25 user site, calculating this number as 3 times the number of users who will be accessing the software simultaneously. E.g.,

    25 x 3 = 75

    Number of Work Areas

    Assuming a 25 user site, calculate this as 60 times the number of users who will be accessing the software simultaneously. E.g.,

    25 x 60 = 1500

    Number of Tables

    The recommended setting is 120 times the number of companies the business operates. If the company accesses 3 different companies, then the calculation would be:

    120 x 3 = 360

    Number of Index Files

    The recommended setting is 150 times the number of companies the business operates. If the company accesses 3 different companies, then the calculation would be:

    150 x 3 = 450

    Number of Data Locks

    The recommended setting is 40000.

    Miscellaneous Settings

    It should also be noted that if the "Worker Thread" count "Configured" reaches "Current" then under the Configuration Utility tab, Misc Settings, the "Number of Worker Threads" should be increased by one, to allow for better response times for individual users.

    Settings Review

    The above setting should be reviewed 7, 30 and 60 days after installation or when significant changes to user access to the database occurs. Settings may be increased or decreased based on actual usage, which is reported under the Max Used column on the console. Plenty of safety margin should always be added to ensure that client applications do not experience errors when accessing the database.
Locked 1 post Page 1 of 1

Who is online

Users browsing this forum: No registered users and 2 guests