ProfilerSqlQueries

(Difference between revisions)
m
m
Line 5: Line 5:
The SQL Queries profiling mode tracks SQL queries executed using the JDBC API, execution times, invocation counts and call trees, enabling to analyze the traffic between a Java process and database instance. Use this profiling mode to realize what queries are being executed and identify performance bottlenecks or bad design patterns like not using prepared statements. See [[ProfilerFirstSession|First Profiling Session]] for details on starting a profiling session.
The SQL Queries profiling mode tracks SQL queries executed using the JDBC API, execution times, invocation counts and call trees, enabling to analyze the traffic between a Java process and database instance. Use this profiling mode to realize what queries are being executed and identify performance bottlenecks or bad design patterns like not using prepared statements. See [[ProfilerFirstSession|First Profiling Session]] for details on starting a profiling session.
 +
 +
===SQL Query Profiling Modes===
 +
[[image:profiler_selected_methods.png|thumb|right|Profiling modes]]
 +
* '''All queries''' collects all executed SQL queries. This mode is selected by default and doesn't require any additional configuration.
 +
 +
* '''Defined queries''' collects executed SQL queries containing the provided case-insensitive substring.
__NOTITLE__
__NOTITLE__
__NOTOC__
__NOTOC__

Revision as of 13:49, 5 September 2016

Profiling SQL Queries

This page describes the SQL Queries profiling mode.

File:Profiler_sql_queries.png

The SQL Queries profiling mode tracks SQL queries executed using the JDBC API, execution times, invocation counts and call trees, enabling to analyze the traffic between a Java process and database instance. Use this profiling mode to realize what queries are being executed and identify performance bottlenecks or bad design patterns like not using prepared statements. See First Profiling Session for details on starting a profiling session.

SQL Query Profiling Modes

Profiling modes
  • All queries collects all executed SQL queries. This mode is selected by default and doesn't require any additional configuration.
  • Defined queries collects executed SQL queries containing the provided case-insensitive substring.


Not logged in. Log in, Register

By use of this website, you agree to the NetBeans Policies and Terms of Use. © 2012, Oracle Corporation and/or its affiliates. Sponsored by Oracle logo