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

Right Pane for Scenarios

In the Migration 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 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 comparison information about the query plan from the current Adaptive Server instance and the query plan on the destination Adaptive Server instance for the migration.

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 on the current Adaptive Server instance and the query plan on the destination Adaptive Server instance for the migration.

Database Properties button

Displays the Adaptive Server database options and the devices from the current Adaptive Server instance and from the destination Adaptive Server instance for the migration.

Configuration Parameters button

Displays the Adaptive Server configuration changes used on the destination Migration Adaptive Server instance, showing the parameter name, the value applied during the analysis, and the old value for the parameters that were changed.

Note: The Configuration Parameters only displays if configuration changes were made for this analysis.

Apply/Undo Changes button

Displays the script that changes the configuration parameters for the migration database. Click Executeimage\B_Execute.gif located at the right of the Migration Analyzer window to run the script.

 

Related Topic

Right Pane for SQL Analyzed Folder

In the Migration Analyzer window, when the SQL Analyzed folder is selected in the left pane, the following information displays in the right pane.

Cost Summary button

Displays all the SQL statements and shows the Estimated I/O Cost from the current Adaptive Server instance and from the destination Adaptive Server instance for the migration.

Cost Classification button

Displays all the SQL statements and shows the SQL Classification (Simple, Complex, and Problematic) from the current Adaptive Server instance and from the destination Adaptive Server instance for the migration.

 

Related Topic

Right Pane for SQL Statement

Displays detailed information about the SQL statements used in the Analysis. 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 on the current database at the time of the analysis.

SQL Information button

Displays the SQL statement information for comparison of possible performance changes between the current Adaptive Server instance and on the destination Adaptive Server instance for the migration. The SQL text is in the top portion of the right pane. The bottom portion of the window has two SQL Information panes, for comparison of the query plans, abstract plans, Trace On information, SQL classification, and DDL for any temporary tables that are required by the SQL statement.

Saving the Abstract Plan

The abstract plan for a SQL statement can be saved from this pane. In order to save the abstract plan, it must be retrieved when the SQL was selected to be analyzed. This is done from the Abstract Plan page of the New Analysis wizard.

To save an abstract plan

  1. Select the SQL statement in the left pane.

  2. Click SQL Information section of the right pane. This enables the Save Abstract Plan button.

  3. Click Save Abstract Plan image\B_SaveAbstractPlan.gif.

  4. In the Save to group field, select the abstract plan group.

  5. Click Save.

 

Related Topic

Create a Migration Analysis

Related Documents