CODEWITHSUNDEEP
javajdbcprofiling
fglez
fglez

Reputation: 8552

JDBC profiling tools

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

Have you used any free/commercial JDBC profiling tool? What are your experiences?

Thank you.

Upvotes: 3

Views: 7113

Answers (7)

Kanishka Dilshan
Kanishka Dilshan

Reputation: 734

Now VisualVM supports JDBC profiling as well. Just have a look https://visualvm.github.io/download.html

enter image description here

Upvotes: 5

BullyWiiPlaza
BullyWiiPlaza

Reputation: 19195

IntelliJ IDEA has a plugin called Fluid for HTTP and JDBC libraries. It seems to be actively developed.

Upvotes: 1

Amit Bhati
Amit Bhati

Reputation: 5649

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

Upvotes: 0

Břetislav Wajtr
Břetislav Wajtr

Reputation: 338

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

Upvotes: 0

Aaron Digulla
Aaron Digulla

Reputation: 328624

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

Upvotes: 2

Mark
Mark

Reputation: 29129

I have never used it but have come across Elvyx. Again it has not been updated recently.

Upvotes: 0

Peter Štibraný
Peter Štibraný

Reputation: 32893

Check out JAMon (Java Application Monitor) too. Also older, but works.

Upvotes: 1

Related Questions