Chat now with support
Chat with Support

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

Retrieval Criteria (QP Metrics)

SQL Inspector > Add/Modify Inspector > Retrieval Criteria (QP Metrics)

When using the QP Metrics, the Retrieval Criteria page of the Add/Modify Inspector wizard consists of the following settings:

Item Description

Target Database

Specific the database from which to retrieve the SQL statements and the run time statistics. This information is retrieved from the database.dbo.sysquerymetrics view.


All User

Specify to retrieve the SQL statements and Transact SQL executed by all users.

Selected User

Select the specific user from the Available User ID column

Group IDs

All Group IDs

Specify to retrieve the SQL statements and transact SQL saved in all groups.

Selected Group IDs

Select the specific group IDs from the Available Group ID column.

Number of SQL returned


Retrieve all SQL from the sysquerymetrics view.

Select Top "value" SQL with highest "criteria"

Select the number of SQL you want to be retrieved and the criteria for select those SQL statements from the drop-down boxes.


Related Topic

Schedule Time (QP Metrics)

SQL Inspector > Add/Modify Inspector > Schedule Time (QP Metrics)

The Schedule Time page of the Add/Modify Inspector wizard consists of the following settings:

Item Description

Start inspecting now

Specify to start the inspection as soon as you click the Inspect button.

Start inspecting at date

Time (HH:MM)

Specify the date and time you want the inspection to run.

Start inspecting in (HH:MM)

Specify the time to start the inspection in hours and minutes.

Schedule on

Shows the date that you scheduled to run the inspection.


Related Topic


SQL Inspector > Inspect

After adding or modifying an Inspector in the SQL Inspector window, SQL statements and statistics from the monitoring tables are retrieved by executing the Inspect function.

To start the inspecting process

Click image\B_Inspect.gif.

If the start time of the Inspector has not been reached, the SQL Inspector waits until it is time to begin. During and at the end of the inspecting, information is updated on the SQL Inspector window. Inspect terminates automatically once the end time is reached, except for ad-hoc inspecting. The ad-hoc inspecting process has no ending time so it must be terminated manually.

To abort the inspecting

Click image\B_AbortInspect.gif.

Note: If you have already executed the Inspect function for an Inspector, re-executing the Inspect function will erase all existing information.


Related Topics

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.


Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating