Importing Statements to SQL Tuner

SQL Profiler enables you to submit one or more statements into SQL Tuner. This enables you to take advantage of Tuner’s hint-based and transformation-based suggestions if you want to tune a problem statement that you detected over the course of a profiling session.

Context menu commands in SQL Profiler enable you to import statements to a tuning job directly from the Profiler interface.

Import a statement from SQL Profiler into SQL Tuner

To import a statement from SQL Profiler into SQL Tuner

• Select one or more statements in Profiler, right-click, and then select Tune from the context menu. SQL Tuner opens and contains the selected statements in a new tuning job. You can now proceed to tune the problematic statements.