Advantage Developer Zone

 
 
 

Advantage Knowledgebase Item




Ref No:
100607-2325
Last Modified:
Monday, June 7, 2010
Product:
Advantage Database Server ( General )
Category:
Configuration
Title:
Advantage Database Server 64-bit Memory Usage
Problem Description:
How much memory will the Advantage Database Server (ADS) 64-bit use? Should the memory usage be limited?
Solution:
The memory usage of the server will very depending on load and types of operations, however as a general rule:

- ADS will never exceed 85% of the total physical memory.
- ADS will never exceed the current available physical memory minus some buffer.

So if a machine has 10GB physical memory, the very upper limit would be 10*.85 = 8.5 GB as the very maximum. It would almost certainly be less than that, though. Typically a large portion of the memory used will be for caching. If, in this example, ADS was using 2GB already and other processes are using 5GB total, then the cache limit would be set at around 2 GB.

If Advantage is installed on a server and the server is shared with other applications the above can help understand how much memory Advantage may use. The cache system can be controled via a registry or configuration file setting if it is desired to decrease the memory usage.

To set a specific amount of memory for the Advantage Database Server to use for caching, perform one of the following where "x" is replaced by the actual integer memory amount in megabytes (MB). To disable the cache system, specify a value of zero.

For NetWare:
Add or modify the following line in the Advantage Database Server configuration file (ADS.CFG):
MAX_CACHE_MEMORY=x

For Windows NT/2000/2003:
Add or modify the following DWORD value using the Registry Editor (REGEDIT.EXE):
\\HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\Advantage\Configuration\MAX_CACHE_MEMORY=x

For Linux:
Add or modify the following line in the Advantage Database Server configuration file (adsd.conf):
MAX_CACHE_MEMORY=x
Was This Item Helpful?