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

SQL Anywhere 10.0.1 » SQL Anywhere Server - Database Administration » Running the Database Server » Some common options » Threading in SQL Anywhere

Tasks on Windows and Linux Next Page

Controlling threading behavior

There are five main factors that control threading behavior, each of which are governed by a server option. Not all of these options are supported on every platform.

Threading tips
Processor use and threading example

The following example explains how the database server selects CPUs based on the settings of -gt and -gtc. For the purpose of the following examples, assume you have a system with 4 processors, with 2 cores on each processor. The physical processors are identified with letters, and the cores with numbers, so this system has processing units A0, A1, B0, B1, C0, C1, D0, and D1.

ScenarioNetwork database server settings
A single CPU license or -gt 1 specified
  • -gt 1
  • -gtc 2
  • -gn 20

Threads can execute on A0 and A1.

No licensing restrictions on the CPU with -gtc 5 specified
  • -gt 4
  • -gtc 5
  • -gn 20

Threads can execute on A0, A1, B0, C0, and D0.

A database server with a 3 CPU license and -gtc 5 specified
  • -gt 3
  • -gtc 5
  • -gn 20

Threads can execute on A0, A1, B0, B1, and C0.

No licensing restrictions on the CPU with -gtc 1 specified
  • -gt 4
  • -gtc 1
  • -gn 20

Threads can execute only on A0.