This section covers the most common performance and size related tuning for Adaptive Server Anywhere. Most of this information is also available on the Sybase Web site.
The server command line switches allows for the configuration of ASA at start up. For simplicity, only sizing relevant properties are included. Cache sizing options are not included since Adaptive Server Anywhere provides automatic resizing of the database cache that minimizes the impact to system resources by requesting memory only when it is required and returning memory to the system when it is not being used.
-gm – defines
the number of concurrent database connections to the server. This
option should reflect the number of database connections defined
in global.properties.xml. The syntax is:
[dbsrv8 | dbeng8] -gm integer...
-gn – sets
the maximum number of execution threads to be used in the database
server. Each connection uses a thread for each request, and when the
request is completed, the thread is returned to the pool for use
by other connections. Increase this option if the number of total
requests (active + unscheduled) is often larger than the
number specified by the -gn option. The
syntax is:
[dbsrv8 | dbeng8] -gn integer...
