>>> of course it can happen that some user executed a query that's
>>> extremely slow and sometimes this causes the server to respond very
>>> slowly so it may look as if he died (to the other users).
>>> My question is whether it's possible to access the queries/other tasks
>>> the server is currently processing. A way to terminating the tasks
>> would be extremely handy, too.
>>
>> Something like this possible, somehow?
>
>> Monitoring tables in Firebird 2.1
>
>Monitoring is nice , but
>how about killing the Task ?
>or closing the long running left open transaction of a dead client ?

Firebird 2.1 allows you to kill a running statement.

A left open transaction should be rolled back automatically.

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com