Subject 100% CPU Usage
Author Carlos Eduardo V. Oliveira (GER_ENS)
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).

Howver 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 everytime I have 2 simoultaneous connections despite of the
weight of the database, the CPU behaves annormaly slow.

Anyone can help me?

Best regards
Carlos Eduardo

[Non-text portions of this message have been removed]