ASA Database Administration Guide
Running the Database Server
Some common options
Controlling threading from the command line
There are four database server options that control threading behavior. Not all of these options are required on every platform.
Number of tasks The -gn option controls the number of tasks used to process requests. Effectively, this is the number of requests that can be handled concurrently. Each request uses a task. When there are more requests than there are tasks, any outstanding requests must wait until a currently-running task completes. By default, there are 20 tasks for the network database server and 10 tasks for the personal database server. There is no benefit to setting a number of tasks that is greater than the maximum number of server connections.
For more information, see -gn server option.
Stack size per internal execution thread You can set the stack size per internal execution thread in the server using the -gss option. The -gss option allows you to lower the memory usage of the database server in environments with limited memory. This option has no effect on Windows operating systems.
For more information, see -gss server option.
Number of processors If you have more than one processor, you can control how many processors the threads exploit by specifying the -gt option. By default, all processors available on the machine are used.
For more information, see -gt server option.
Number of threads assigned to the database server process On Windows NT/2000/XP, the -gx option controls the number of threads that are dedicated to hosting fibers to service requests. By default, this is set to one more than the number of CPUs on the machine. On UNIX, NetWare, and Windows 95/98/Me where each task is its own thread, this option is not needed.
For more information, see -gx server option.