> 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?
Then you are not using SuperServer, or SuperServer not serving a single database but several databases. What Firebird related processes do you see in the Windows Task Manager? - fbserver.exe - Single fb_inet_server.exe - Multiple fb_inet_server.exe -- With regards, Thomas Steinmaurer http://www.upscene.com/ Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc. > On Feb 11, 2014 8:15 PM, "Thomas Steinmaurer" <t...@iblogmanager.com > <mailto: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. > > > >