|Subject||Re: [firebird-support] Firebird slowdowns while resources are available|
> I have one fbserver.exe. I have multiple databases though, one with highfbserver.exe = SuperServer (SS).
> load, the others with very low load .
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.
Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.
> On Feb 11, 2014 8:34 PM, "Thomas Steinmaurer" <ts@...
> <mailto:ts@...>> 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
> > 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
> Professional Tools and Services for Firebird
> FB TraceManager, IB LogManager, Database Health Check, Tuning etc.
> > On Feb 11, 2014 8:15 PM, "Thomas Steinmaurer"
> <ts@... <mailto:ts@...>
> > <mailto:ts@... <mailto:ts@...>>> 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.