|Subject||Re: [firebird-support] Firebird slowdowns while resources are available|
> I have a strange slowdown problem with a Firebird database. During theWith SuperServer on a single database? I doubt.
> 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
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 ...
Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.