Chat now with support
Chat with Support

SQL Optimizer for SAP ASE 3.9 - 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

Ad-hoc Inspect

SQL Inspector > Ad-hoc Inspect

Ad-hoc inspect allows the retrieval of the SQL performance statistics without considering or setting the scheduled start date and time.

To start an ad-hoc inspection

  1. Mark an Inspector by clicking the Inspector row. A green checkmark image\I_GreenCheckmark.gif is prefixed to the Inspector Name column to indicate that the Inspector is marked.

  2. Right-click and select Ad-hoc Inspect.

The process will not stop until you click image\B_AbortInspect.gif.


Abort Inspect

SQL Inspector > Abort Inspect

After the Inspect function has been executed from the SQL Inspector window, it can be aborted at any time.

To abort the inspecting

Click image\B_AbortInspect.gif.

It may take several seconds for all the events to close down.


Related Topics

Scan Inspector

SQL Inspector > Scan Inspector

The SQL statements collected by the Inspector can be scanned in the SQL Scanner to classify the SQL statements to help identify which SQL statements are likely to be causing performance problems.

To scan an Inspector from the SQL Inspector window:

  1. Mark an Inspector by clicking the Inspector row.

  2. Right-click and select Scan.

The selected Inspector is copied to the SQL Scanner window for scanning. If the SQL Scanner window is not opened then you will need to first select or create a job group from the Group Manager window. Once added, the scanning starts automatically.


Related Topics

Find Inspector

SQL Inspector > Find Inspector

To search for a specified text in all Inspectors

  1. Select Inspector | Find Inspector.

  2. Enter the search text string

  3. Click Find.


Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating