Jump to: navigation, search

Difference between revisions of "EclipseLink/UserGuide/JPA/Advanced JPA Development/Performance/Performance Monitoring and Profiling/Query Monitoring"

m
m
(3 intermediate revisions by the same user not shown)
Line 8: Line 8:
 
* [http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/tools/profiler/QueryMonitor.html QueryMonitor]
 
* [http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/tools/profiler/QueryMonitor.html QueryMonitor]
 
}}
 
}}
 +
 
=Query Monitoring=
 
=Query Monitoring=
  
Line 15: Line 16:
  
 
* Set the System property <tt>org.eclipse.persistence.querymonitor=true</tt>.
 
* Set the System property <tt>org.eclipse.persistence.querymonitor=true</tt>.
* Set the <tt>persistence.xml</tt> property <tt>eclipselink.profiler=QueryMonitor</tt>.
+
* In <tt>persistence.xml</tt>, set <tt><property name="eclipselink.profiler" value="QueryMonitor"/></tt>
  
 
The monitor dumps the number of query cache hits and executions (misses) once every 100 seconds.  
 
The monitor dumps the number of query cache hits and executions (misses) once every 100 seconds.  

Revision as of 11:16, 21 February 2011

EclipseLink JPA

link="http://wiki.eclipse.org/EclipseLink"
EclipseLink
Website
Download
Community
Mailing ListForumsIRC
Bugzilla
Open
Help Wanted
Bug Day
Contribute
Browse Source

Elug api package icon.png Key API


Query Monitoring

Use the Query Monitor to measure query executions and cache hits. This can be useful for performance analysis in a complex system.

Enable the Query Monitor in either of these ways:

  • Set the System property org.eclipse.persistence.querymonitor=true.
  • In persistence.xml, set <property name="eclipselink.profiler" value="QueryMonitor"/>

The monitor dumps the number of query cache hits and executions (misses) once every 100 seconds.

For more information about querying, see Querying.

Eclipselink-logo.gif
Version: 2.2.0 DRAFT
Other versions...