> I have one fbserver.exe. I have multiple databases though, one with high > load, the others with very low load .
fbserver.exe = SuperServer (SS). With several databases, the CPU utilization makes sense then, even under SuperServer. But still, SuperClassic or Classic might even utilize the CPU environment more, even for a single database. With SS, you are roughly speaking bound to a single CPU/core per database, shared across all connections for that database. -- 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:34 PM, "Thomas Steinmaurer" <t...@iblogmanager.com > <mailto:t...@iblogmanager.com>> wrote: > > __ > > > 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> > > <mailto: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. > > > > > > > > > > > >
