立即与支持人员聊天
与支持团队交流

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

Generate Scanned Jobs Reports

You can generate a scanned jobs report in SQL Scanner. The scanned jobs report provides information about the SQL statements for a selected scan job that includes:

  • Chart for SQL Classification

  • SQL conversion

  • Temp table dependencies

  • SQL position

  • SQL Text

  • Execution Plan

    Tip: You can display execution plans in text mode, grayscale graphic mode, or full color graphic mode.

  • SQL Classification

To generate a scanned jobs report

  1. Select the Scan SQL tab in the main window.

  2. Create a scan job using the Add Scanner Jobs wizard. See Scan SQL for more information.See Scan SQL for more information.

  3. Select a group in the Scanner node in the Task pane.

  4. Select the scan job that you want to create a report for in the Job List pane.

  5. Click .

    Tip: You can also generate a selected SQL report by selecting a scan job from the Group node of the Task pane and clicking in the SQL List pane.

  6. Select the checkboxes for the criteria you want to include in the report.

  

Related Topics  

Manage Scan Jobs

Generate Group Summary Reports

Manage Plan Guides

You can use Manage Plans to manage plan guides deployed from Optimize SQL.

SQL Plan Guides

You can use the SQL Plan Management feature introduced in SQL Server 2005 to tune execution plans without changing the original source code. Plan control mode in Optimize SQL creates plan guides and deploys them to Manage Plans.

The Plan Guide Management feature in Manage Plan Guides helps you organize and manage plan guides deployed from Optimize SQL. You can enable, disable, fix, or delete plan guides for each SQL statement and search for plan guides by SQL text.

  

Related Topics

Manage Plan Guides

Create Manage Plan Guides Session

About Managing Plan Guides

You can use Manage Plans to manage plan guides deployed from Optimize SQL.

SQL Plan Guides

You can use the SQL Plan Management feature introduced in SQL Server 2005 to tune execution plans without changing the original source code. Plan control mode in Optimize SQL creates plan guides and deploys them to Manage Plans.

The Plan Guide Management feature in Manage Plan Guides helps you organize and manage plan guides deployed from Optimize SQL. You can enable, disable, fix, or delete plan guides for each SQL statement and search for plan guides by SQL text.

  

Related Topics

Manage Plan Guides

Create Manage Plan Guides Session

Select Connection

This topic may not include a description for every field in the screen or dialog.

To select a connection

  1. Select Manage Plan Guides.
  2. Click .

  3. Review the following for additional information:

    Select Connection Description

    Connection

    Click to select a previously created connection.

    Tip: Click to open the Connection Manager to create a new connection. See Connect to SQL Server for more information.

    Select Database and User Description

    Database

    Click to select the database to match your SQL statement.

  

Related Topics  

相关文档

The document was helpful.

选择评级

I easily found the information I needed.

选择评级