Online Tools for Firebird
Create Free Account or Login
FirebirdSQL Configuration Calculator:
create optimal configuration files (firebird.conf, databases.conf) for Firebird database, using parameters of your hardware/virtual machine (RAM, CPU cores, etc) and load profile (number of users, database size, etc).
use raw trace output to view and analyze SQL queries to see peaks of loads: top of slow queries, top of frequent queries, etc. For each query you can see its SQL text, plan, list of parameters, and performance statistics.
Advanced Monitoring for high load Firebird servers:
see SQLs, transactions, IO metrics, details RAM usage per application, CPU/Load average, firebird.log and replication.log. It requires installation monitoring agent (Windows or Linux).