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

SQL Optimizer for SAP ASE 3.8 - User Guide

Introduction Tutorials Preferences Editor Functions SQL Information and Functions Performance Monitor SQL Inspector SQL Collector for Monitor Server SQL Scanner Index Advisor SQL Optimizer
SQL Optimizer Overview Optimization Engine Common Coding Errors in SQL Statements What Function Should l Use to Retrieve the Run Time? Unsatisfactory Performance Results SQL Optimizer Functions SQL Editor Optimized SQL Activity Log
SQL Worksheet SQL Formatter Database Explorer Code Finder Object Extractor SQL Repository Index Impact Analyzer Index Usage Analyzer Configuration Analyzer Migration Analyzer Abstract Plan Manager User-Defined Temp Tables SQL History Legal Information

Add SQL Inspectors (Add Jobs Wizard)

SQL Scanner > Add Scanner Jobs > Add SQL Inspectors (Add Jobs Wizard)

(For Adaptive Server 15.0 and later)

You may want to scan the SQL Inspector to identify the SELECT, INSERT, UPDATE and DELETE SQL statements with their query plan, abstract plan and trace on information (if available). This enables you to review the query plan and helps to give a better understanding of which SQL statement is causing the performance problem within the database server.

To add a SQL Inspector

  1. Click the SQL Inspector page. The left-hand list field displays a list of available Inspectors. If you have not yet created any Inspectors, this list field is blank.

  2. Select an Inspector and click image\B_AddDatabaseObjects.gif or drag the Inspector you want to scan over to the right-hand list field.

  3. Use the Use Database and Set User drop-down lists to select the database and user that corresponds with the SQL that you are scanning.

 

Related Topic

Add Source Code (Add Jobs Wizard)

SQL Scanner > Add Scanner Jobs > Add Source Code (Add Jobs Wizard)

The SQL Scanner can scan through any source code stored as a text or a binary file to identify SQL statements.

To add sources code files

  1. Select the Source Code page.

  2. Select the file type and click image\B_Add.gif.

    Files Types

    Description
    Text/Binary Source code saved in text or binary format.

    COBOL

    COBOL source files.

  1. Use the Use Database and Set User drop-down lists to select the database and user that corresponds with the SQL that you are scanning.

 

Related Topic

Summary (Add Jobs Wizard)

SQL Scanner > Add Scanner Jobs > Summary (Add Jobs Wizard)

Use Current DB & User

Enables you to select specific Jobs to scan using the current database and user connection

Note: When you close the Add Jobs wizard, the newly added Jobs are automatically marked in the SQL Scanner window with a black checkmark image\I_BlackCheckmark.gif in the far left of the row.

 

Related Topic

Scan

SQL Scanner > Scan

To prepare a Job for scanning

Mark the Job on the SQL Scanner window by clicking the row to be scanned. The image\I_BlackCheckmark.gif black checkmark prefixes the File / Database Object column. Multiple Jobs can be marked.

To start scanning

Click image\B_Scan.gif.

During scanning, information is updated on the SQL Scanner window. The time required to scan a Job depends on the processor speed of your computer, the file size, the number of valid and invalid SQL statements identified, and the time it takes to retrieve the query plan for each SQL statement.

To abort the scan

Click image\B_AbortScan.gif.

 

Related Topics

相关文档

The document was helpful.

选择评级

I easily found the information I needed.

选择评级