Versioning monitoring tables in Firebird 2.1/2.5

Firebird 2.1 added the long-awaited monitoring tables. By querying special system tables starting with MON$, you get a snapshot of the current activities in your database like who is connected to your database, which transactions and statements are running and so on. You even can cancel a running query by executing a DELETE statement on MON$STATEMENTS. Firebird 2.5 will also allow you to cancel an entire attachment via a DELETE on MON$ATTACHMENTS.

Read More on Thomas Steinmaurer’s Blog

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)

Leave a Reply