SQL Optimizer for SQL Server 10.1.2 - User Guide

SQL by Classification

In Find SQL, SQL Optimizer groups the collected SQL into SQL Classification categories. The SQL by Classification page allows you to view the list of SQL for each classification category. You can also use this page to view the details of each statement.

To view SQL by Classification

1. On the Search Results page for a current or previously-saved Find SQL session, scroll down to the SQL Classification panel.
2. Click a color-coded classification category in the pie chart or the legend.
3. The SQL by Classification page opens displaying the list of SQL in that category.
4. Select a SQL statement to view SQL details.
   • View the selected SQL statement's execution plan in the Execution Plan tab.
   • Click to view the batch or object script. The selected SQL is shown highlighted within the script.
   • Click to show only the SQL text again.
   • Click View Batch or View Database Object to view batch/object statistics, as well as the other SQL statements in the batch/object.
     • Use the Classification Type column to see how many SQL statements of each type are in the batch or object.
   • Select the SQL Information tab to view the SQL classification rule used to classify the SQL.

5. The top-right corner of the window displays the classification category (Simple, Complex, Problematic, or Invalid).

   • To view a different category, click the link and select a different SQL classification type from the drop-down list. For descriptions of classification categories, see SQL Classification Categories.

   • Click Switch to filter by classification rules in the same drop-down list to filter SQL by rules you select. This method displays SQL in all applicable categories according to the rules selected.

     Note: Any rules that were not be used by SQL Optimizer to classify collected SQL in this Find SQL session are disabled in the drop-down list.

6. Click to return to the dashboard page.

Tip: You can enable/disable classification rules or define new rules in Options | General | SQL Classification. See SQL Classification Options for more information.

SQL Details Page

Review the following for additional information:

Pane	Description
SQL Text	Displays the SQL text of the selected SQL. Send to Optimize SQL by SQL Rewrite—Click to send the selected SQL to SQL Rewrite. Click the drop-down arrow to select Send to Optimize SQL by Plan Control. Click to show only the selected SQL text. Click to display the entire batch or object script, with the selected SQL highlighted within it. View Batch / View Database Object—Click to view details of the batch containing the SQL. Right-click SQL text to view additional options.
Execution Plan	Execution Plan tab—See About Execution Plans (Find SQL) for more information. SQL Statistics tab—View statistics minimum and maximum values. SQL Information tab—Displays classification and classification rules details.
Top SQL	Lists the Top n SQL. Select a SQL to view the SQL text and statistics. View Statistics—Click the link to select a different way to view statistics.

Click View Summary Chart to return to the Summary page.

Related Topics

Top SQL - Summary Chart View

Batch Details Page

When the Batch Details page opens, it displays details for the selected batch. Expand the batch node and select a SQL to show SQL details.

Click View Summary Chart to return to the Results page.

Related Topics

Top Batches - Summary Chart View

Database Object Details Page

When the Database Objects Details page opens, it displays details for the selected object. Expand the object node and select a SQL to show SQL details.

Click View Summary Chart to return to the Results page.

Related Topics

Top Database Objects - Summary Chart View