How to tell if InterBase is using Additional Processor License

By: Tom Gardner

Abstract: This FAQ show how to determine if InterBase is using multiple CPUs

The simplest way to determine if InterBase is set up to use multiple CPUs is to look at the license certificates. For those that say they have added an Additional Processor License and want proof that InterBase is using multiple CPUs here is a simple test to perform.

Open a command prompt window and attach to a database with isql. Open an additional command prompt window and attach to a database with isql. For this example the employee.gdb sample database included with InterBase is used. Start Windows Task Manager and select the Performance tab. You will need a query that takes a few seconds to execute so that you can observe the CPU usage with Windows Task Manager. The following join takes about 15 seconds (depending on your computer) to execute:

select count (*) from employee, employee, employee, employee;
Note: adding more than four instances of employee to the join can significantly increase the time for the query to execute.

Start one query and you will observe a spike in the CPU Usage History displayed for one of your CPUs on the Performance tab of Windows Task Manager. Start the other query from the other command prompt window and you should observe the CPU Usage History displayed for another of your CPUs on the Performance tab of Windows Task Manager. The illustration below demonstrates this test.

If you only have one processor licensed this same test would look like the illustration below.

Note that only only one CPU is shown as being used.

Server Response from: ETNASC03