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

Add/Modify Inspector

To add an Inspector

Click image\B_AddInspector.gif.

To Modify an Inspector

  1. Select the Inspector row.

  2. Click image\B_ModifyInspector.gif .

Note: If you have already executed the Inspector, modifying the Inspector criteria erases any existing information.

 

General Information

The General Information page of the Add/Modify Inspector wizard consists of the following settings:

Item Description

Inspector name

Enter a name for the Inspector.

Description

Enter a description for the Inspector.

Last modified

The date and time the Inspector was last modified.

Inspecting Approach

Monitor Tables

(ASE 15 or later)

Specify to extract the SQL statements and transact SQL from the Adaptive Server monitoring table. The monitoring tables are available in Adaptive Server 15 or later.

QP Metrics

(ASE 15 or later)

Specify to extract the SQL statement from QP Metrics (sysquerymetrics view). The QP Metrics are available in Adaptive Server 15 or later.

 

Related Topic

Monitor Process (Monitoring Tables)

The Monitor Process page of the Add/Modify Inspector wizard consists of the following settings:

Item

Description

Whole server

Monitor all SQL statements currently running from the database server.

Process ID

Monitor all SQL statements currently running which have the specified process ID (spid). The Process ID grid displays information about all current users and processes of the database server, displaying the process ID (spid), login name, server name, database name and the command type currently executing. Click the row of the grid to select the process ID you want to monitor. To select all the process IDs, click the Select all checkbox.

Connection identity

Monitors all currently running SQL statements with the specified login name, host name, database name, and/or program name.

 

Related Topic

Retrieval Criteria (Monitoring Tables)

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

Item Description

Retrieve only those records whose executions are after the scheduled start time

Specify that SQL statements executed before the Inspector starts will not be retrieved. All the records are retrieved from the start time and forward.

Retrieve records from nn minute(s) before the scheduled start time

(Range 1 to 99999 minutes (1666 hours or 69 days))

Specify that all records from a certain number of minutes before the Inspector starts are retrieved.

Retrieve records executed after (HH:MM) on the same date as the scheduled start date

Specify that only records from a specific time be retrieved.

Retrieve all records found in the monitoring tables

Specify that all records are retrieved when the Inspector starts. If you have a large volume of SQL statements in the monitoring tables, this option can take a long time to process the first inspecting interval.

The Adaptive Server monitoring tables may contain a large number of records when the Inspector starts. Therefore you may not want to retrieve all the existing records from the tables when the Inspector starts. The Retrieval Criteria page of the Add/Modify Inspector wizard allows you to specify which records are retrieved as the Inspector starts.

 

Related Topic

Related Documents