-gt dbeng12/dbsrv12 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.

Syntax

{ dbeng12 | dbsrv12 } -gt num-processors ...

Allowed values

num-processors This integer can be a value between 1 and the minimum of:
- the number of physical processors on the computer
- the maximum number of CPUs that the server is licensed for if CPU-licensing is in effect

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

The personal database server is always limited to a single processor. 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. The number of CPUs that the network database server can use may also be affected by your SQL Anywhere edition. See Editions and licensing.

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, by default, runs on all logical processors (hyperthreads and cores) of n physical processors. This behavior can be further restricted with the -gtc option.

-gt dbeng12/dbsrv12 server option

Syntax

Allowed values

Applies to

Remarks

See also