|Subject||RE: [firebird-support] monitoring firebirdsql with opensource tool ?|
|Author||Svein Erling Tysvær|
> * other interesting requests ? to prevent or diagnose quickly problems ?I sometimes use (well, I don't actually include any ORDER BY, but would if there were lots of simultaneous activity going on)
where mon$transaction_id <> current_transaction
order by mon$timestamp
to find statements that are currently running (typically statements that I've issued without taking a proper look on the plan or where I notice an error while it is executing so that I want to terminate that particular request). I think it could be used to find candidates for being long-running queries. Though I use Fb 2.5 and don't know whether it will work or not on 2.1.