Tchater maintenant avec le support
Tchattez avec un ingénieur du support

SQL Optimizer for SQL Server 10.1.2 - User Guide

Welcome to SQL Optimizer Optimize SQL
Create Optimize SQL Sessions Open Optimize SQL Sessions Rewrite SQL Plan Control Use Temporary Tables
Optimize Indexes Find SQL Scan SQL Manage Plan Guides Configure Options Tutorials About Us

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 tabSee 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

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.

Pane Description

Batch Text

Displays text of the selected batch.

Right-click SQL text to view additional options.

Batch Statistics

View Statistics—click the link to select one of the following:

  • Value and Percentage in Server
  • Value
  • Percentage in Server

Top Batches

View Statistics—click the link to select one of the following:

  • Value and Percentage in Server
  • Value
  • Percentage in Server

Expand the batch node to view the SQL in the batch.

Select SQL to view SQL text and statistics. The SQL is shown highlighted in the batch text.

Click View Summary Chart to return to the Results page.

  

Related Topics

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.

Pane Description

Database Object Text

Displays text of the selected object.

Right-click SQL text to view additional options.

Object Statistics

View Statistics—Click link to select one of the following:

  • Value and Percentage in Server
  • Value
  • Percentage in Server

Top Database Objects

View Statistics—Click link to select one of the following:

  • Value and Percentage in Server
  • Value
  • Percentage in Server

Expand the object node to view the SQL in the object.

Select SQL to view SQL text and statistics. The SQL is shown highlighted in the object text.

Click View Summary Chart to return to the Results page.

  

Related Topics

Documents connexes

The document was helpful.

Sélectionner une évaluation

I easily found the information I needed.

Sélectionner une évaluation