CODEWITHSUNDEEP
performancejprofiler
Sean Adkinson
Sean Adkinson

Reputation: 8615

Can JProfiler tell me how long queries are taking?

Wouldn't it be nice if I could drill down into the JProfiler CPU View, and find a percentage of time running a certain query against the database? Does anyone know if this is possible?

Upvotes: 1

Views: 2802

Answers (1)

Ingo Kegel
Ingo Kegel

Reputation: 48090

The call tree in JProfiler shows JDBC queries with the default settings:

enter image description here

If this is not the case, open the session settings, go to the probe settings, select the JDBC probe and ensure that "Enabled", "Record on startup" and "Annotate JDBC calls in call tree" are selected:

enter image description here

Another way to look at JDBC query strings is the "hot spot" view of the JDBC probe:

enter image description here

Upvotes: 2

Related Questions