You can use IBExpert to analyze all of the triggers and stored
procedures in your database and show you all of the non-indexed queries.
It is not a SQL-Monitor that runs on the server, though.

-steve

On Wed, 2005-11-23 at 14:55 +0100, Ralf ter Veer wrote:

> 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
>
>
> ------------------------ Yahoo! Groups Sponsor
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>


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