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. | |
Monitor Process (Monitoring Tables)
View Add Inspector - Monitor Process Page
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. |
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.
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. | |
|
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. | |
|
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
.