Hi,
Last time I have been forced to administrate Firebird in version 1.5. My main problem was that lack of knowledge what this system actually is doing, what kind of SQL is executed, which machines request server to response. Unfortunatelly, my internet explorations about this gave me clear answer: Firebird in this version is “blackbox”.

My own solution to this inconvenience was operating system tool called strace and thanks to these instructions I was able to see much more…

pgrep -u firebird -f fbserver | xargs strace -s 512 -v -tt -e trace="accept,recv,select" \
-o /tmp/strace-fbserver -p ;
tail -f /tmp/strace-fbserver | sed 's/\\0//g' | sed 's/\\//g' | \
grep -e "select\|execute"

While reading some articles about MySQL I found a very interesting solution on base of view of network traffic. Source: mysqlperformanceblog

tcpdump -i eth0 -s 0 -l -w - dst port 3050 | strings | perl -e '
while(<>) { chomp; next if /^[^ ]+[ ]*$/;
if(/^(SELECT|UPDATE|DELETE|INSERT|SET|COMMIT|ROLLBACK|CREATE|DROP|ALTER)/i) {
if (defined $q) { print "$q\n"; }
$q=$_;
} else {
$_ =~ s/^[ \t]+//; $q.=" $_";
}
}'