By default, the Activity Log is disabled.
during the SQL optimization process and query plan retrieval,
To start recording the activities
Click .
Select the Activity Log tab.
Specify the activity to be logged by selecting the SQL optimization and/or the Query plan generation checkboxes. If no option is selected, the activity log is disabled.
Specify the information to be collected by selecting the SQL text and/or Query plan checkboxes.
Note: Only activities executed in the SQL Optimizer window are logged.
The following information is recorded automatically for each activity logged:
PC user name.
Database logon name.
Adaptive Server name.
The Activity Log directory is used to store the log file created while recording the activities. Select the Directory Setup / Linkage tab to change the directory where the log is written. The default is the installed directory.
For example C:\Documents and Settings\User\Application Data\Quest Software\SQL Optimizer
Note: It is advisable not to change the Activity Log directory after selection, as log file is saved to this directory.
You can save or print the information in the report.
To print or view information stored in the activity log
Select Report | Activity Log to open the Activity Log Report Criteria window.
Select the information to view.
Click OK to generate the report.
The following information may be displayed depending on the criteria you select.
Item | Description |
PC User |
Windows user name used to logon to the PC. |
Logon Name |
Database logon name. |
Server Name |
Adaptive Server name. |
User |
Database user. |
Database |
Database name. |
Item | Description | ||||||||||||||
Date |
Date of when the activity was executed. | ||||||||||||||
Activity |
Activity type SQL optimization (OP) Query plan generation (EP) | ||||||||||||||
Original SQL Type |
The SQL Classification of SQL the original SQL (Simple, Complex or Problematic). | ||||||||||||||
The information below is repeated for ALL RECORDS and FIRST RECORD. | |||||||||||||||
Status |
The current status of the activity.
| ||||||||||||||
Original SQL Time |
The run time of the original SQL statement. | ||||||||||||||
Best Alternative Time |
Best run time from the alternative SQL statements. | ||||||||||||||
Times of Improvement |
Calculates how much faster the alternative is in comparison to the original SQL statement. |
Note: The activity log information is retrieved from the Activity Log directory; therefore if any changes are made to this directory the information may not be retrieved.
To purge the activity log data
Click the .
Select the Activity Log tab.
Under the Housekeeping section, select either Whole Log to remove all information or specify a date range to remove logs between these dates.
Click Purge Now.
To stop recording activities to the activity log:
Click .
Select the Activity Log tab.
Under the Activity to be logged, de-select the SQL optimization and Query plan generation checkboxes to disable the activity log.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Nutzungsbedingungen Datenschutz Cookie Preference Center