Subject RE: [firebird-support] Who's guilty?
Author Alan McDonald
> I'm running a quite big (over 1GB) database. There are several
> programs and more than 100 users connected to that DB.
> My problem is the database started to work really, really slow (%
> processor usage maxed out throughout the day)
> This obviously looks like an unoptimized query got through to one of
> the client programs (I am doing a large refactoring of the programs
> recently)
> My question is: are there any ways to identify what user or query is
> hammering an Interbase DB down? I mean *anything* that could give
> even a slightest trace. Users are totally upset with the performance
> and I'm stuck. Help! :-)))
> Thanks,
> Marcin

Don't think there's a way of seeing that but I would look very closely at
any reports which have been added since before the problem arose. That may
uncover the culprit very quickly.