Subject 100% CPU Usage
Author caduvix2003
Dear Friends;

I run Firebird Superserver 1.5.1 in a Dell Server Intel Pentium
2,4Ghz / 1.256Mb RAM. This server hosts a single database which has,
in the main table, around 30.000 registries.

It's an excelent machine and the number of simoultaneous users are
quite low (average of 25 to 35 users).

However I'm having, too frequently, CPU usage reports with peaks of
100% CPU usage for a period of 10-20 seconds, in simple queries,
which is affecting the system performance in the client machines. For
your information I don't have other relevant services running in the
same server.

Recently I have installed a Firebird's configurator tool and did
several changes in the database's caching parameters. These changes
resulted in a little performance's improvement but did not solve the
problem of the peaks.

In my tests I rebooted the server and started uniquelly the database
service. Then, connected from a workstation (Duron 1,2Ghz, Windows
2000 Pro, in a LAN environment 100Mbits) and performed a simple
query. The server responded normally (60% CPU usage, < 1 sec).

So I conected from another workstating (Duron 1,2Ghz, Windows 2000
Pro, LAN environment too) while I kept the first client in IDLE (not
using the system). Once I tried to perform the same query which I did
before, the server used 100% of the CPU and took 10 seconds to reply.

As you can see when I have 2 simoultaneous connections the CPU
behaves annormaly slow.

Anyone can help me?

Best regards
Carlos Eduardo