SQL Optimizer for SQL Server 10.1

立即与支持人员聊天

获得即时帮助
完成注册

登录

请求定价

联系销售人员

Tutorial: SQL Scanner View SQL Classification Send to Optimize SQL Tutorial: Find SQL from Plan Cache Tutorial: Find SQL from SQL Trace

Optimize SQL Statements and Execute Alternatives

Tutorial: SQL Optimizer Automatically Optimize SQL Statements Automatically Optimize Using Plan Guide Execute SQL Alternatives About Generating Index Alternatives Tutorial: Index Alternatives Tutorial: User-Defined Temp Tables

Compare SQL Alternatives Generate Reports

Generate Scanned Jobs Reports Generate Group Summary Reports Generate Optimize SQL Resolution Report

Optimize Indexes Tutorial

Manage Scan Jobs

SQL Scanner displays scan jobs you create using the Add Scanner Jobs wizard in the Job List pane. You can use the Job List pane to manage scan jobs in a selected group.

Note: This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.

To start a scan job

Select the Scan SQL tab in the main window.
Create a scan job using the Add Scanner Jobs wizard. See "Scan SQL" in the online help for more information.
Select a group in the Scanner node of the Task pane to view a scan job.

Tip: Select a scan job in the Job List pane to view job properties in the Job Detail Information pane.
Right-click a scan job and select Scan to start the scan job.

Tips:

You can change the database by clicking the entry in the Set Database column and selecting a different database before starting the scan job.
You can change the user credentials by clicking the entry in the Set User column and selecting different user credentials before starting the scan job.
Select the Eliminate Duplicate SQL checkbox to eliminate duplicate SQL statements while scanning.
Click to stop all scan jobs in the selected group.

Note: Right-click a scan job and select Delete to delete the job.

请选择您的产品：

为向您提供更好的服务，请填写'Purpose of your Chat'（联系目的）：

针对您的问题建议的解决方案

SQL Optimizer for SQL Server 10.1 - User Guide

Manage Scan Jobs