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
http://www.upscene.com/

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