I've been working on an application that exhibits inconsistent performance under load. There is a suspicion that the database is causing some of the performance problems, however I need to categorically prove that.

Is there a way that I can get hibernate to identify exactly how much time is taken for each SQL statement that it executes on the database? Obviously I can put code around my HQL calls, but this doesn't tell me whether the inconsistencies aren't occurring in Hibernate's Java code (as a result say, of poor app-server configuration or garbage collection).

I'm hoping that this is a common question with a simple answer?

Have you had a look at Statistics? You will have to do some manual work for it though...

http://www.javalobby.org/java/forums/t19807.html