Processor Affinity Syntax

By: Ben Matterson

Abstract: How to specify which processor InterBase will use in an SMP system.

What is the syntax for specifying processor affinity?

CPU_AFFINITY

This parameter (introduced in version 6.5) in IBCONFIG specifies the processors to be used by the InterBase server on an SMP machine. This parameter is only available on MS Windows O.S. The default value is 1. The InterBase server will use the 1st CPU on the system by default. Here are some other variations:

To use CPU 0:
CPU_AFFINITY 1

To use CPU 1:
CPU_AFFINITY 2

To use CPU 1 and 2:
CPU_AFFINITY 3

Server Response from: ETNASC03