When you collect SQL currently executing my monitoring an application our a user during a specific period, the Monitoring Period page of the Add Inspector wizard displays:
Item | Description | |
Start Date | Specify the start date of the monitoring period. | |
End Date | Specify the end date of the monitoring period. | |
Interval (minutes) |
Specify how frequently the Inspector monitors SQL in milliseconds. |
When you collect SQL currently executing by an application or a user at a specific moment, the Target Time page of the Add Inspector wizard displays:
Item | Description | |
Capture immediately the currently executing SQL when the Inspect button is clicked |
Click Inspect button to start capture immediately. | |
Capture SQL executing at: |
Date |
Specify the date you want to capture executing SQL. |
Time (HH:MM): |
Specify the time you want to capture executing SQL in hours and minutes. | |
Wait for some time and then capture what SQL are executing: |
Wait time (HH:MM): |
Specify the time you want to wait before you capture executing SQL in hours and minutes. |
When you collect SQL currently executing, the Target Applications and Users page of the Add Inspector wizard displays:
Client Applications |
Description |
All Applications |
Monitor all applications currently running. |
Selected Application |
Monitor a specific application. |
Selected Agent ID |
Displays Agent ID for the selected application. |
Users | Description |
All Users |
All available users. |
Selected User |
Use the arrows to select from Available Users. |
After adding or modifying an Inspector in the SQL Inspector window, SQL statements and statistics from the database are retrieved by executing the Inspect function. Only one Inspector can be started at a time.
To start the inspecting process
Select an Inspector job.
Click .
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 .
Note: If you have already executed the Inspect function for an Inspector, re-executing the Inspect function will erase all existing information.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback 利用規約 プライバシー Cookie Preference Center