FB TraceManager by Upscene Productions is a premium graphical user interface (GUI) tool designed to manage, parse, and analyze Firebird database audit logs. While Firebird includes a native command-line utility called fbtracemgr, it only outputs raw, semi-structured text. FB TraceManager unlocks the full power of Firebird’s built-in Audit and Trace Services API by turning that raw text stream into structured, actionable intelligence. Core Capabilities
Context-Based Parsing: Automatically transforms raw, hard-to-read Firebird log text into a structured, tabular format.
Centralized Storage: Logs the parsed trace data directly into a dedicated Firebird database (FBTM.fdb) for persistent storage and historical analysis.
Hotspots Analysis: Aggregates executed statements on-the-fly to pinpoint slow queries, heavy procedures, or runaway triggers.
Event Processing: Allows you to write script-based rules that trigger instant alerts (such as email notifications via SMTP) when specific conditions are met in the log.
Visual OLAP/Pivot Reporting: Features a built-in report designer to visually construct ad-hoc queries, chart trends, and analyze high-level database activity. Master Log Management: Two Tracing Modes
Firebird’s architecture supports two types of tracing, both of which can be managed natively or imported into FB TraceManager: 1. System Audit
Purpose: Continuous, long-term security and engine monitoring.
Execution: Started automatically by the Firebird engine upon server startup.
Configuration: Activated via the AuditTraceConfigFile parameter in the firebird.conf file.
Log Behavior: Permanently writes to physical server files and can be set to rotate automatically when reaching a maximum size limit. 2. User Trace FB TraceManager 2 – Documentation – Upscene
Leave a Reply