Directory (1)
View Directory (1) page
Default directory for open and save dialog
This directory is the default for opening and saving files with the Open or Save commands from various locations through the modules. By default, it is C:\Documents and Settings\User\Application Data\Quest Software\SQL Optimizer.
Activity Log Directory
This directory specifies the location where the Activity Log file is created. By default, it is C:\Documents and Settings\User\Application Data\Quest Software\SQL Optimizer.
SQL History directory
This directory is used to store the data file that stores the SQL history information. The default is C:\Documents and Settings\User\Application Data\Quest Software\Quest SQL Optimizer\SQL_History.
SQL Scanner data directory
This directory is used to store the data files created while scanning. The default is the sub-directory DATA of the installed directory, for example: C:\Documents and Settings\User\Application Data\Quest Software\Quest SQL Optimizer\DATA. Changes to this directory cannot be made while SQL Scanner is active.
SQL Collector data directory
This directory is used to store the data files created while monitoring. The default is the sub-directory DATA of the installed directory, for example: C:\Documents and Settings\User\Application Data\Quest Software\Quest SQL Optimizer\DATA. Changes to this directory cannot be made while SQL Collector for Monitor Server is active.
SQL Inspector data directory
This directory is used to store the data files created while capturing SQL from the system tables. The default is the sub-directory DATA of the installed directory, for example: C:\Documents and Settings\User\Application Data\Quest Software\SQL Optimizer\DATA. Changes to this directory cannot be made while SQL Inspector is active.
Note: It is advisable not to change the data directory after selection, as files already created are kept in the original directory and are not moved to the new directory.
Directory (2)
SQL Repository data directory
By default, it is C:\Documents and Settings\User\Application Data\Software\Quest Software\SQL Optimizer.
Index Impact Analyzer data directory
By default, it is C:\Documents and Settings\User\Application Data\Software\Quest Software\SQL Optimizer.
Index Usage Analyzer data directory
By default, it is C:\Documents and Settings\User\Application Data\Software\Quest Software\SQL Optimizer.
Configuration Analyzer data directory
By default, it is C:\Documents and Settings\User\Application Data\Software\Quest Software\SQL Optimizer.
Migration Analyzer data directory
By default, it is C:\Documents and Settings\User\Application Data\Software\Quest Software\SQL Optimizer.
Activity Log Tab
Activity Log
Activity to be logged
The activity log records activities obtained from SQL optimization and query plan retrieval. If neither the SQL optimization nor Query plan generation checkbox is selected, then no activities are recorded in the activity log. By default, both of these checkboxes are unselected.
Information to be logged
To record the SQL text, the query plan information and the abstract plan information, select the desired checkboxes. By default the following information is recorded automatically: login user, OS user, database, all records and/or first record time, and SQL type.
Housekeeping
Show warning message when log file size exceeds (Default 5MB, Range = 1 to 500MB)
Use to indicate the maximum size in MB of the activity log file; the default is 5 MB. If the size of the activity log file exceeds the maximum value a warning message displays to inform you of this.
Purge activity log
Use to remove information from the activity log. Select either Whole Log to remove all information or Dated from and specify a date range to remove logs between these dates. Click Purge Now to remove the desired logs.