SQL Trace Tool Introduction
The SQL Trace function is an on-demand log of selected SQL statements that are issued against the database through the Open SQL Engine. The SQL Trace can be switched on or off dynamically. The log format is database independent. Besides the SQL statement text, each log record contains information about the point in time when the statement was executed, its duration, its input parameters and results (where applicable) as well as context information.
FeaturesThe SQL Trace is especially useful for:
SQL Trace can help JDO, enterprise beans, servlet and JSP developers to learn which kind of database accesses their code produces.
Typically, performance issues are caused by inefficient database accesses. In this case SQL Trace can be used to show the issued SQL statements and their duration, thus helping to identify inefficient SQL statements.
ActivitiesTypically, you should use the SQL Trace when you need to check the behavior of a particular application. This is the following scenario:
You launch the SQL Trace application.
You activate the SQL Trace. You run the application that you want to trace.
You deactivate the SQL Trace.
You set filters optionally.
You evaluate the trace.
You can also evaluate a trace that already exists.
The SQL Trace also provides functions for file administration.
SQL Trace is less suitable for detecting general performance issues. Therefore, we do not recommend that you keep it constantly activated, as it consumes additional resources.