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

Migration Analyzer Window

Migration Analyzer Window

The Migration Analyzer window displays performance analysis information about the SQL statements and query plans analyzed between two Adaptive Server versions. For each performance analysis selected from the tree view in the left pane, overall performance change metrics and details on query plan changes are provided in the right pane.

Left pane - Analyzer List

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

Migration Information

This folder displays performance analysis information for migration 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.

You can display information for the following:

Analyzers

Scenarios Analyzed Folder

Scenario

SQL Analyzed Folder

SQL Statements

 

Related Topics

Right Pane for Analyzers

In the Migration Analyzer window, when an Analyzer is selected from the tree 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 Migration 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 from the current Adaptive Server instance and from the destination Adaptive Server instance for the migration.

Charts button

Charts the total Estimated I/O Cost of the SQL statements from the current Adaptive Server instance and from the destination Adaptive Server instance for the migration.

 

Related Topic

Related Documents