Gerhard Knapp wrote:

> ...
> cpu_affinity = 1 -> the first cpu is going to 100%
> cpu_affinity = 2 -> then second cpu is going to 100%
> cpu_affinity = 0 -> both are running nearly synchroneus and not going to
> 100%, BUT
> the IBServer-Process reaches often 100% ?!?!?!

This (... not going to 100% ...) is because the IBserver process is moved
from one processor to the other, neither will go above 50% - a problem that
cpu_affinity=1 (or =2) will solve.
Why do processors go to 100%? Maybe because of some spesific query, or
sweep, or ...

> -----------------------------------------------

What is the page size, and how many cache pages did you specify?

Maybe PII and 2 400MHz processors is too weak for 70 users? It depends on
what they are doing (if anything!). How much RAM is there? Are there
several opened databased (at the same time)?


Regards,
Aage J.