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.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center