In the Migration Analyzer window, when the SQL Analyzed folder is selected in the left pane, the following information displays in the right pane.
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.
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.
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.
Displays general information about the SQL statement and the database settings on the current database at the time of the analysis.
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.
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
Select the SQL statement in the left pane.
Click SQL Information section of the right pane. This enables the Save Abstract Plan button.
In the Save to group field, select the abstract plan group.
To create a Migration Analysis
The New Analysis wizard has four pages for selecting the options for creating an analysis.
After making the selections from these four tabs, click OK.
To abort the Migration analysis
Select Analysis | Abort Analysis.
When the analysis is finished, the Migration Analysis Details window displays with information the retrieve of the query plan for each SQL statement.