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. Feedback Términos de uso Privacidad Cookie Preference Center