> 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.