Enable SQL Trace

Use SQL Trace to log information for all executed SQL to a file or the Output window. You can review execution times for each statement to determine which statements are performing poorly.

Note: Because this trace logs information for each execution, it can slow performance on your computer.

To enable SQL Trace

Select Tools | Execution Trace and then select whether to generate a log file or display the output in a window.

If you selected a log file, the file is stored by default in:

Windows^® 2003: C:\Documents and Settings\username\Local Settings\Application Data\Quest Software\Toad for database version\ConnectionTrace.log

Windows Vista^® or later OS: C:\Users\username\AppData\Roaming\Quest Software\Toad for database version\ConnectionTrace.log

You can view the log file in the Editor by selecting Tools | Execution Trace | Show Logfile.

Note: To locate your Application Data directory, select Help | About and click Application Data Directory in the About dialog.