Learn more about Toad for SQL Server
at Quest.com

Find solutions and downloads at the
Toad for SQL Server Support Portal

< To bookmark a page, right-click the Page Title and select Add to Favorites / Bookmark This Page

Toad for SQL Server 5.7

You are here: Troubleshoot > Enable SQL Trace

Enable Execution 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 and XP: 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.