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" <t...@iblogmanager.com> 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. > >