Chat now with support
Chat with Support

SQL Optimizer for SAP ASE 3.8 - Release Notes

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

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating