El 15/07/2013, a las 18:23, "trskopo" <trskopo@...> escribió:

>
>
> --- In firebird-support@yahoogroups.com, Jesús García <jegaza@...> wrote:
> >
> > El 15/07/2013, a las 16:31, "trskopo" <trskopo@...> escribió:
> >
> > > Hi all,
> > >
> > > I have Superserver Firebird 2.5.1 installed on Win7 pro 64 bit on I7 2600K.
> > >
> > > When data grows, Firebird Server starting to slow down. I shutdown Firebird Server, starting again without changing anything and Firebird Server became smooth again.
> > >
> > > Any ideas, what is the problem with this? Firebird.conf mostly on its default values except for cpuaffinity set to 15 and DefaultDbCachePages set to 4096.
> > >
> > > Anto
> > >
> > >
> > Probably is long running transactions. I have had this issue in two scenarios. One is long running transactions that makes db slowdown and the other one is when an auto sweep starts, because a long running transaction, there is an issue (that will be solved in 2.5.3) that makes Firebird run sweep several times.
> >
> > I have databases of 30 gb running fine for months without issues except when there is a long running transaction. The last issue was because gbak was out space and the gbak's transaction was opened for days. Our customer called us because the slowdown and we killed the gbak process and then auto sweep started. The sweep runned more than 2 hour (i think because the bug in 2.5.2) and after that all was running fine. (When i run a manual sweep in that database takes 20 minutes and does not slowdown the engine like when auto sweep is started)
> >
> > Jesús
> >
> > >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
> Thanks for your reply.
>
> How do I check that there is a long transaction running?
>
> Anto
>

Select * from mon$transactions for example

>

[Non-text portions of this message have been removed]