SQL Optimizer for SAP ASE 3.9

Item		Description
Start date		Specifies the inspection start date.
End date		Specifies the inspection end date.
Repeat method	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.
Run at (HH:MM) (Default = current time)		Specify the starting time in hours and minutes.
Until	Time (Default = Start Time + 5 minutes)	Specify the ending time.
Until	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 $image\B_AbortInspect.gif$ .

Retrieval Criteria (QP Metrics)

SQL Inspector > Add/Modify Inspector > Retrieval Criteria (QP Metrics)

View Add Inspector - Retrieval Criteria Page

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.
User	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.
Group IDs	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.
Number of SQL returned	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.

Inspect

SQL Inspector > Inspect

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 $image\B_Inspect.gif$ .

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 $image\B_AbortInspect.gif$ .

Note: If you have already executed the Inspect function for an Inspector, re-executing the Inspect function will erase all existing information.

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.

Please select your product:

To serve you better, please complete the Purpose of your Chat:

Recommended Solutions for Your Problem

SQL Optimizer for SAP ASE 3.9 - User Guide

Schedule Settings (Monitoring tables)

Retrieval Criteria (QP Metrics)

Schedule Time (QP Metrics)

Inspect