JDBC Profiler for JBoss / Distributed Applications

Question

I'm trying to eliminate a slow database being the cause of some performance issues for a distributed application I'm supporting. I've done local profiling of various facets of the application and performance monitoring of the server itself, leading me to suspect that the database is at least partially responsible for the poor performance.

Currently I'm using JBoss for the back-end (using a Hibernate / JDBC layer to connect to the database), but I only have source access to some of the code.

I've found Elvyx, but this project seems to have been abandoned in 2008. Is there a newer JDBC profiler available - what's the current 'de facto' standard for profiling a database in a distributed app?

Alternatively, can anyone suggest a better / alternative approach?

Answer 1

Try using YourKit, it supports a reasonable degree of JDBC profiling:

1. You can view executed SQL after you capture a CPU snapshot.
2. You can also enable JDBC probes and view multiple things live, such as timings, stack traces, threads, SQL statements and many more, see attached screen shot from my colleague's computer (looks like you'll need to open this image in another browser tab/window to see it full size):

Don't really want this to sound as an ad for YourKit, but get yourself a trial license and give it a go.

Answer 2

I too would recommend AppDynamics. The 'Lite' version was more than adequate for my purposes.

Our Java EE application runs within JBoss and we knew we had performance bottlenecks in certain areas. By quickly and easily (and I do mean easily) installing and spinning up AppDynamics, then running some load through the application, we were able to see straight away exactly where our performance hits were located. On the clean and concise dashboard we were able to drill right down the stack to see which class needed some improvement.

Highly recommended. Definitely check it out. I heat the 'Pro' version is even better.