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

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

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.

User

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

All SQL

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)

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

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

Related Documents