Chat now with support
Chat with Support

We are currently experiencing issues on our phone support and are working diligently to restore services. For support, please sign in and create a case or email for assistance

SQL Optimizer for SQL Server 10.1 - User Guide

Scan SQL

SQL Scanner extracts SQL statements embedded in database objects, captured from SQL Profiler, or stored in application source code and binary files. Use the Add Scanner Jobs wizard to create scan jobs using statements from any of these sources.

To create a scan job

  1. Select the Scan SQL tab in the main window.
  2. Click Add Scanner Job from the Welcome pane.

    Tip: You can navigate directly to the embedded SQL statement for a particular format by clicking one of the links from the Welcome pane.

  3. Select a connection to use for the scan job. Review the following for additional information:

    Select Connection Description


    Click to select a previously created connection.

    Tip: Click to open the Connection Manager to create a new connection.

    Select Database and User Description


    Click to select the database to match your SQL statement.

    Set User

    Click to select your user name.
  4. Select the page for the type of statement you want to add to the scan job. Review the following for additional information:

    Database Objects Page Description

    Database Objects

    Select a database object and click to add the object to scan.

    Tip: Click to browse for database objects to add.

    SQL Profiler Page Description

    Available trace files/table

    Click to add SQL Server Profiler trace files or trace tables to scan.


    Click to select the database of the SQL to scan.

    Set User

    Click to select your user name.
    Source Code Page Description

    Source code type

    Select Text/Binary files or COBOL programming source code to indicate the source code type.

    Add by file

    Click and browse to the files you want to scan.

    Add by directory

    Click and browse to the directories you want to scan.

    Note: Select the Include Sub-directory checkbox to scan sub-directories.

    Connection for scanning

    Select the database and user name settings.

    Note: SQL Scanner helps you manage scan jobs by organizing them into groups. Use the Group Information page to create a new group or to add the current scan job to an existing group.

  5. Select the Group for the scan job you created in the Scanner node of the Task pane once SQL Scanner finishes scanning.

  6. Select the scan job in the Group node.

  7. Identify problematic SQL statements in the SQL List pane. See View SQL Classification for more information.

  8. Select SQL statements to send to SQL Optimizer for optimization. See Send to Optimize SQL for more information.


Related Topics 

Manage Groups

Manage Scan Jobs


Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating