Running a SQL Trace

Run a SQLTrace and review the transaction for SQL statements that have a long processing time.

The duration column (Dur= ) in a SQL trace displays this information. If the duration is greater than 100 milliseconds, you may be able to make this SQL statement run faster. Work with your database administrator to tune the SQL.