Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » SQL Anywhere Server - Database Administration » Starting and Connecting to Your Database » The database server » Database server options


-gt server option

Sets the maximum number of physical processors that can be used (up to the licensed maximum). This option is only useful on multiprocessor systems.

{ dbsrv11 | dbeng11 } -gt integer ...
Applies to

Windows (except Windows Mobile), Linux, and Solaris.


With per-seat licensing, the network database server uses all CPUs available on the computer (the default). With CPU-based licensing, the network database server uses only the number of processors you are licensed for. In addition, the personal database server and runtime database server are both limited to a single processor.

When you specify a value for the -gt option, the database server adjusts its affinity mask (if supported on that hardware platform) to restrict the database server to run on only that number of physical processors. If the database server is licensed for n processors, the server will, by default, run on all logical processors (hyperthreads and cores) of n physical processors. This can be further restricted with the -gtc option.

Valid values for the -gt option are between 1 and the minimum of:

If the -gt value specified lies outside this range, the lower or upper limit is imposed. For the personal database server (dbeng11) the server uses a -gt value of 1.

See also