en
brFBMonLogger
FBMonLogger is a tool to analyse monitoring tables output in Firebird and find problems with slow queries, wrongly designed transactions and identify problematic applications. FBMonLogger can quickly connect to Firebird database with performance problems and identify what is the reason of slowness: what attachments, SQL queries or transactions cause the problems. FBMonLogger supports Firebird 2.1, 2.5 and 3.0 – for older Firebird versions or InterBase please use FBScanner.
FBMonLogger shows you:
- Top attachments and statements with highest number of IO operations, non-indexed and indexed reads
- Long-running transactions, transactions with erroneous isolation level, read/write transactions, and related information: when they started, what applications started it, from what IP address
- Attachments and statements with the most intensive garbage collection actions
After connection to the database where you want to find performance problems, several snapshots of monitoring tables should be done – click on «Get Snapshot» to take snapshot.
Aggregated performance statistics for attachments
At the first screen we can see aggregated statistics for connections, and identify connections with biggest problems:
