To add an Inspector
Click .
To Modify an Inspector
Select the Inspector row.
Click .
Note: If you have already executed the Inspector, modifying the Inspector criteria erases any existing 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. |
The Monitor Process page of the Add/Modify Inspector wizard consists of the following settings:
Item |
Description |
Monitor all SQL statements currently running from the database server. | |
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. | |
Monitors all currently running SQL statements with the specified login name, host name, database name, and/or program name. |
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.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center