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:
When using the QP Metrics, the Retrieval Criteria page of the Add/Modify Inspector wizard consists of the following settings:
Item | Description | |
Target Database |
Specific the database from which to retrieve the SQL statements and the run time statistics. This information is retrieved from the database.dbo.sysquerymetrics view. | |
User |
All User |
Specify to retrieve the SQL statements and Transact SQL executed by all users. |
Selected User |
Select the specific user from the Available User ID column | |
Group IDs |
All Group IDs |
Specify to retrieve the SQL statements and transact SQL saved in all groups. |
Selected Group IDs |
Select the specific group IDs from the Available Group ID column. | |
Number of SQL returned |
All SQL |
Retrieve all SQL from the sysquerymetrics view. |
Select Top "value" SQL with highest "criteria" |
Select the number of SQL you want to be retrieved and the criteria for select those SQL statements from the drop-down boxes. |
The Schedule Time page of the Add/Modify Inspector wizard consists of the following settings:
Item | Description |
Start inspecting now |
Specify to start the inspection as soon as you click the Inspect button. |
Start inspecting at date Time (HH:MM) |
Specify the date and time you want the inspection to run. |
Start inspecting in (HH:MM) |
Specify the time to start the inspection in hours and minutes. |
Schedule on |
Shows the date that you scheduled to run the inspection. |
After adding or modifying an Inspector in the SQL Inspector window, SQL statements and statistics from the monitoring tables are retrieved by executing the Inspect function.
To start the inspecting process
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. Nutzungsbedingungen Datenschutz Cookie Preference Center