Migration Analyzer Window
View 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:
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.
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.
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 Execute