SNMP monitoring of Firebird locking behavior

Hi folks,

How much interest is there in an SNMP agent for monitoring Firebird
1.5.x lock statistics?

I've been using Firebird as an admin for >5 years supporting a line-of-biz
application using 1.5.x Classic Server as a database backend, and I
think we're getting killed with lock contention. Buying faster and faster
hardware doesn't contribute that much to better performance, which causes
no small amount of chagrin to the small companies using this software.

My discovery of fb_lock_print and Ann's wonderful paper on the same has
been a real eye opener, but there is only so much I can do from a tuning
point of view: at some point I have to involve the vendor.

Loving the fb_lock_print data but wanting to see it over time and correlated
with other system performance data, I created a Firebird MIB that loads into
Net-SNMP's snmpd and reports on a coupla dozen parameters. Though the code is
still kinda rough, it's graphing reliably on several systems right now with
the Cacti monitoring system.

An annotated sample showing mutex waits -vs- CPU & context switch time:

        http://www.unixwiz.net/misc/fbperf.gif

(this was researching some pathological behavior).

I'm new enough to Firebird development (and this list) that I don't know
how well this might "fit" here. I think it probably works with Classic
or Super Server, but probably not with 2.0.

I don't know if 1.5.x is so old that nobody cares any more -- I just
know that *our* app requires it.

Happy New Year.

Steve

--
Stephen J Friedl | Security Consultant |  UNIX Wizard  |   +1 714 544-6561
www.unixwiz.net  | Tustin, Calif. USA  | Microsoft MVP | steve@...

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel