Know of any Firebird profilers and/or stress tester app's?

I'm looking for som testing programs for a firebird db server, to stress-test and find bottlenecks.

Something like DB-Optimizer, only for firebird would be nice开发者_Python百科. Can also be separate programs, one for stress-testing and one for profiling.

You may look :

• sinatica monitor
• IBSurgeon tools
• IBExpert

and you can also just request monitoring tables (Firebird 2.1)

Just complementing Hugues answer:

Sinatica monitor uses monitoring tables from Firebird 2.1, so will not work very well on FB2.0 or below.

IBExpert have his own type of monitoring tables to help you in this task.

If you are using FB 2.5 you can look also Firebird Trace Manager.

To make some stress tests using your own application you can always look for AutoHotkey. Just be careful... Sometimes you can really mess things with it.

Jmeter may work rather well, as it's fairly easy to setup a basic DB request test, and can be incredibly flexible.

• Overview
• Manual

You may look at Firebird profiler to trace the queries