Starting and using the sQLProxy tool

Logs are generated for all database operations when the log level is set to TIMER or higher.

About this task

To begin tracing, execute the API or agent after setting the log level. The trace files are generated in the location specified in the proxyLogDir property. The following details are included in the files:

*.log file gives component name, start and end system times, operation execution times (individual and cumulative), operation name, SQL statement, java class name
*.tail file helps in understanding the long running queries (used mostly in performance testing)