Sets the stack size per worker in the database server.
{ dbeng12 | dbsrv12 } -gss { integer[ k | m ] } ...
All operating systems and servers. For Windows, this option is supported on Windows XP and later.
The -gss option allows you to lower the memory usage of the database server in environments with limited memory.
The size is the amount of memory to use, in bytes. Use k or m to specify units of kilobytes or megabytes, respectively.
A stack of the size specified by -gss is allocated for each database server worker. The maximum number of workers is specified by the -gnh option for network servers and the -gn option for personal servers. If you set a large -gss value, and a large value for the maximum number of workers, then the database server may not be able to start, or the size of the cache can be limited significantly. For example if you specified -gss 16M and -gnh 100 when starting the network database server, then 1.6 GB of server address space would be reserved for stacks.
The minimum, maximum, and default stack sizes per worker are as follows:
Platform | Minimum | Default | Maximum |
---|---|---|---|
Unix (32-bit) | 512 KB | 512 KB | 4 MB |
Unix (64-bit) | 1 MB | 1 MB | 8 MB |
Windows (32-bit) | 64 KB | 1 MB | 16 MB |
Windows (64-bit) | 64 KB | 4 MB | 256 MB |
Windows Mobile | 64 KB | 96 KB | 512 KB |
Discuss this page in DocCommentXchange.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |