Tchater maintenant avec le support
Tchattez avec un ingénieur du 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

General Information

SQL Inspector > Add/Modify Inspector > 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)

SQL Inspector > Add/Modify Inspector > 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)

SQL Inspector > Add/Modify Inspector > 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

Schedule Settings (Monitoring tables)

SQL Inspector > Add/Modify Inspector > Schedule Settings (Monitoring tables)

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

Item Description

Start date

Specifies the inspection start date.

End date

Specifies the inspection end date.

Repeat method

Once

Inspect only once.

Day(s) of the Week

Inspect on the selected days of every week. Select one or more days

Week(s) of Month

Inspect on the selected week. Select the week or weeks of the month and the day of the week for the Inspector to run.

Day of Month

Select the day of the month for the Inspector to run.

Run at (HH:MM) (Default = current time)

Specify the starting time in hours and minutes.

Until

Time (Default = Start Time + 5 minutes)

Specify the ending time.

Duration (Default = 5 minutes)

Specify the length of time the Inspector runs in hours and minutes.

Interval (Default = 15000 milliseconds which is 15 seconds)

Specify how frequently the Inspector collects the statistics in milliseconds.

Notes:

  • Decreasing the interval time may affect database server performance and network traffic.
  • Ad-hoc inspecting does not use the start, until or duration time. The Inspector process starts instantly and is terminated by clicking Abort Inspector image\B_AbortInspect.gif.

 

Related Topic

Documents connexes

The document was helpful.

Sélectionner une évaluation

I easily found the information I needed.

Sélectionner une évaluation