Chat now with support
Chat with Support

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

Start Recording Activities to the Activity Log

By default, the Activity Log is disabled.

during the SQL optimization process and query plan retrieval,

To start recording the activities

  1. Click image\B_Preferences.gif.

  2. Select the Activity Log tab.

Activity to be logged

Specify the activity to be logged by selecting the SQL optimization and/or the Query plan generation checkboxes. If no option is selected, the activity log is disabled.

Information to be logged

Specify the information to be collected by selecting the SQL text and/or Query plan checkboxes.

Note: Only activities executed in the SQL Optimizer window are logged.

The following information is recorded automatically for each activity logged:

PC user

PC user name.

Logon name

Database logon name.

Server

Adaptive Server name.

Activity Log directory

The Activity Log directory is used to store the log file created while recording the activities. Select the Directory Setup / Linkage tab to change the directory where the log is written. The default is the installed directory.

For example C:\Documents and Settings\User\Application Data\Quest Software\SQL Optimizer

Note: It is advisable not to change the Activity Log directory after selection, as log file is saved to this directory.

 

Related Topics

View Activity Log Report

You can save or print the information in the report.

To print or view information stored in the activity log

  1. Select Report | Activity Log to open the Activity Log Report Criteria window.

  2. Select the information to view.

  3. Click OK to generate the report.

The following information may be displayed depending on the criteria you select.

User Information

Item Description

PC User

Windows user name used to logon to the PC.

Logon Name

Database logon name.

Server Name

Adaptive Server name.

User

Database user.

Database

Database name.

Activity Information

Item Description

Date

Date of when the activity was executed.

Activity

Activity type

SQL optimization (OP)   

Query plan generation (EP)   

Original SQL Type

The SQL Classification of SQL the original SQL (Simple, Complex or Problematic).

The information below is repeated for ALL RECORDS and FIRST RECORD.

Status

The current status of the activity.

PGC

Plan generation completed

OPA

Optimization aborted

OWT

Optimization without any test run

TAI

Improvement found (after test running all SQL alternatives)

TAN

No improvement (after test running all SQL alternatives)

WAI

Improvement found (without testing running all SQL alternatives)

WAN

No improvement (without testing running all SQL alternatives)

 

Original SQL Time

The run time of the original SQL statement.

Best Alternative Time

Best run time from the alternative SQL statements.

Times of Improvement

Calculates how much faster the alternative is in comparison to the original SQL statement.

Note: The activity log information is retrieved from the Activity Log directory; therefore if any changes are made to this directory the information may not be retrieved.

 

Related Topics

Purge Activity Log Data

To purge the activity log data

  1. Click the image\B_Preferences.gif.

  2. Select the Activity Log tab.

  3. Under the Housekeeping section, select either Whole Log to remove all information or specify a date range to remove logs between these dates.

  4. Click Purge Now.

 

Related Topics

Stop Recording Activities

To stop recording activities to the activity log:

  1. Click image\B_Preferences.gif.

  2. Select the Activity Log tab.

  3. Under the Activity to be logged, de-select the SQL optimization and Query plan generation checkboxes to disable the activity log.

 

Related Topics

Related Documents