ASA Database Administration Guide
Running the Database Server
Some common options
Several options can have a major impact on database server performance, including:
Cache size The -c
option controls the amount of memory that Adaptive Server Anywhere uses as a cache. This can be a major factor in affecting performance.
Generally speaking, the more memory made available to the database server, the faster it performs. The cache holds information that may be required more than once. Accessing information in cache is many times faster than accessing it from disk. The default initial cache size is computed based on the amount of physical memory, the operating system, and the size of the database files. On Windows operating systems, and UNIX the database server takes additional cache when the available cache is exhausted.
For more information about performance tuning, see Monitoring and Improving Performance.
For information on controlling cache size, see Cache size.
Number of processors If you are running on a multi-processor machine, you can set the number of processors with the -gt
option.
For more information, see -gt server option and Controlling threading from the command line.
Other performance-related options There are several options available for tuning network performance, including -gb
(database process priority), and -u
(buffered disk I/O).
For more information about startup options, see The database server.