立即与支持人员聊天
与支持团队交流

SQL Optimizer for SAP ASE 3.8 - User Guide

Introduction Tutorials Preferences Editor Functions SQL Information and Functions Performance Monitor SQL Inspector SQL Collector for Monitor Server SQL Scanner Index Advisor SQL Optimizer
SQL Optimizer Overview Optimization Engine Common Coding Errors in SQL Statements What Function Should l Use to Retrieve the Run Time? Unsatisfactory Performance Results SQL Optimizer Functions SQL Editor Optimized SQL Activity Log
SQL Worksheet SQL Formatter Database Explorer Code Finder Object Extractor SQL Repository Index Impact Analyzer Index Usage Analyzer Configuration Analyzer Migration Analyzer Abstract Plan Manager User-Defined Temp Tables SQL History Legal Information

Directory (2)

Preferences > Directory Setup Tab > 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

Preferences > 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.

 

Related Topic

SQL History Tab

相关文档

The document was helpful.

选择评级

I easily found the information I needed.

选择评级