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.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center