Subject Re: [firebird-support] Profiler for 2.1?
Author Tim Ward
Yes, we are planning a migration to 2.5, but we have to do more than one thing at a time, we can't afford to serialise all our projects! Not least because it'll be quite a while before we get all installations upgraded and we'll need to maintain the 2.1 installations in the meantime.

So does the sort of profiler I describe exist for 2.5, or is it a question of rolling one's own using the TraceAPI ... in which case I might as well roll my own using MON$CALL_STACK?

On 12/04/2015 10:17, Alexey Kovyazin ak@... [firebird-support] wrote:

Hi Tim,

2.1 series was discontinued, so nobody will invest in tools for it.
Instead of this, consider migration - 2.1 is pretty close to 2.5, where TraceAPI is available.

Alexey Kovyazin


I've just discovered MON$CALL_STACK, and it seems possible that one
could use this to produce a Monte Carlo type profiler - query it once
every so many seconds, and built up a tree of how often each path
through nested procedures has been hit, thus pointing at which paths
through the code are taking the time.

Do any of the available tools have this feature? - the output I'm after
is a graphical drill-down calling tree like the ones you get from
profilers for conventional languages.

Tim Ward

Tim Ward