Subject | Who's guilty? |
---|---|
Author | turbomenda |
Post date | 2003-12-01T17:43:23Z |
Hi,
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
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