Chat now with support
Chat with Support

SQL Optimizer for SAP ASE 3.9.1 - 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

Configuration Analyzer Window

The Configuration Analyzer window displays the information about the SQL statements that are saved in the Configuration Analyzer. The display in the right section of the window depends on what is selected in the left pane.

Left pane - Analyzer List

Provides a tree view of the Analyzers that provide performance analysis information for different configuration Scenarios. For each Analyzer two folders are provided. Review the following for additional information:

Migration Information Displays performance analysis information for configuration Scenarios
SQL Analyzed Displays the SQL statements selected from the SQL Repository for analysis and the query plans for each of the Scenarios.

Right Pane

The right pane displays a variety of different information depending upon what is selected from the tree diagram in the left pane. Review the following for additional information:

Analyzers .Right Pane for Analyzers
Scenarios Analyzed Folder Right Pane for Scenarios
Scenario Right Pane for Scenarios
SQl Analyzed Folder Right Pane for SQL Analyzed Folder
SQL Statements Right Pane for SQL Statement

 

Related Topics

Right Pane for Analyzers

In the Configuration Analyzer window, when an Analyzer is selected in the left pane, the following information displays in the right pane.

Properties Button

Displays general information about the analysis, information on the connection used to retrieve the query plans and the SQL statements used in the analysis.

 

Related Topic

Right Pane for Scenarios Analyzed

In the Configuration Analyzer window, when Scenarios Analyzed is selected in the left pane, the following information displays in the right pane.

Summary button

Provides a summary of the Estimated I/O Cost and SQL classification for the SQL statements before and after the configuration parameters were changed.

Chart button

Charts the total Estimated I/O Cost of the SQL statements before and after the configuration parameters were changed.

 

Related Topic

Right Pane for Scenarios

In the Configuration Analyzer window, when a specific Scenario is selected in the left pane, the detailed information about the Scenario displays in the button pages in the right pane. The buttons for displaying specific information are found at the top of this pane.

Properties button

Displays general information about the SQL statement and the database settings at the time of the analysis.

Prognosis button

Displays 3 panes in the right section of the window.

Charts and Summary tabs [Top right pane]

The Chart tab displays five charts of the comparison information for the query plans from before the analysis and during the analysis.

The Summary tab displays summarized statistics for the Scenario,

SQL Classification and Plan Change Comparisons [Middle right pane]

A grid displays the information about each query plan from before the analysis and during the analysis in a comparison format.

SQL Text and SQL Information tabs [Bottom right pane]

The SQL statement that is highlight in the middle right pane is the one that displays in this pane.

The SQL Text tab displays the text of the SQL statement.

The SQL Information tab displays two SQL Information panes, one for the SQL information before the analysis and one for the SQL Information with the parameter changes.

Configuration Parameters button

Displays the database parameter changes used in this analysis displaying the parameter name, the value during the analysis and the old value for the parameters that were changed.

Apply/Undo Changes button

Displays the scripts for changing the configuration parameter on Adaptive Server. Click Executeimage\B_Execute.gif located at the right of the Configuration Analyzer window to run the script.

 

Related Topic

Related Documents