Subject | How can I see running statements causing high server load? |
---|---|
Author | Ralf ter Veer |
Post date | 2005-11-23T13:55:55Z |
Hi!
I'm getting perfomance problems on an high-end-server with 200
concurrent users. The server is an optimized gentoo with FB 1.5.2
classic style and SMP-Kernel. Database size is >10GB.
As the hardware is reaching its limits I'm searching for a server based
SQL-Monitor-like Tool which shows active SQL statements. Do you have any
suggestions on this?
I'd like to figure out what parts of our software cause the most load
and if there may be an index missing somewhere..
Thanks for your attention!
Regards,
Ralf
I'm getting perfomance problems on an high-end-server with 200
concurrent users. The server is an optimized gentoo with FB 1.5.2
classic style and SMP-Kernel. Database size is >10GB.
As the hardware is reaching its limits I'm searching for a server based
SQL-Monitor-like Tool which shows active SQL statements. Do you have any
suggestions on this?
I'd like to figure out what parts of our software cause the most load
and if there may be an index missing somewhere..
Thanks for your attention!
Regards,
Ralf