Subject Re: [firebird-support] Firebird slowdowns while resources are available
Author Mezei Zoltan

2.5 should behave pretty well on SMP systems, at least according to the release notes. Windows task manager shows that CPU load is distributed among the available cores. Am I missing something here?

On Feb 11, 2014 8:15 PM, "Thomas Steinmaurer" <ts@...> wrote:

> I have a strange slowdown problem with a Firebird database. During the
> daily use of the database the clients experience significant slowdowns
> while the system still have lots of resources available. Some
> information about the environment:
> - 64 bit Firebird 2.5.2 server running in SuperServer mode
> - the database is running on a 64 bit Windows 2008 R2 server OS
> - the server OS is running in a VMware 4.1 VM with 4 CPU cores and 16 GB of RAM
> - the database size is around 37 GB and the number of concurrent
> connections to the database is around 150.
> While observing the slowdowns:
> - the CPU usage on the machine is between 40-60% without higher spikes
> and the load is nicely distributed among all 4 cores

With SuperServer on a single database? I doubt.

The most obvious switch is to a SMP-capable architecture like
SuperClassic or Classic.

Then there is some general tuning/tweaking away from default settings
necessary, but this all depends on your particular case ...

With regards,
Thomas Steinmaurer

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.