JDBC Profiling Tools

Question

We need to profile the JDBC operations of several web applications, the number of requests, the time spent, the returned rows, ...

Do you use any free / commercial JDBC profiling tool? What are your impressions?

Thank.

Answer 1

I never used it, but met Elvyx . Again, it has not been updated recently.

Answer 2

The only JDBC profiling tool I know is P6Spy . Ancient but still working.

Answer 3

JAMon (Java Application Monitor). , .

Answer 4

IntelliJ IDEA Fluid HTTP JDBC. , -, .

Answer 5

There is a JDBC profiler built into JProfiler (go to Hotspots view -> JDBC), the best I've seen so far ...

Answer 6

You can use Jdbc spy: https://github.com/lbaeumer/jdbcspy .
It can be configured very easily and will provide information on which operators are executed, what are the operators with the greatest duration, additional statistics about your connections, which operators are executed so often, etc.