Use
the Run All Single-Query Advisors and Analysis
Tools page of the Invoke section
to run the analysis tools and advisors on a single SQL statement.
Procedure
To open the Run All Single-Query Advisors and
Analysis Tools page of the Invoke section:
- Immediately after capturing an SQL statement: In the page of the Capture section
that you used to capture an SQL statement, right-click the statement
and select Run All Advisors and Tools.
- To run advisors and tools on an SQL statement
again: Click
the Invoke tab. If the Run All Single-Query
Advisors and Analysis Tools page is not open, select Run
All Advisors and Analysis Tools on the left side of the
workflow assistant.
- To run advisors and
tools on an SQL statement that is
saved in a project:
- In the Project
Explorer, expand the project that the
SQL statement is saved in until you find the statement.
- Right-click the statement and select Open.
- In the workflow assistant for query tuning,
click the Invoke tab.
If the Run All Single-Query Advisors and Analysis Tools page
is not open, select Run All Advisors and Analysis Tools on
the left side of the workflow assistant.
What to do next
You can set options for the advisors
before you run them,
choose which tools and advisors to run, and generate reports. For
help with these options, click the Help icon (
),
or click in a portion of the page and type F1.