SQL Optimizer for SAP ASE 3.8 - Installation Guide

Migration Analyzer Tutorial

The Migration Analyzer helps you to preempt performance degradation when performing database migrations, upgrades, and application rollouts. It ensures reliable database performance by tracking query plan and cost changes. You have an option to integrate abstract plan management to help stabilize SQL performance during migrations.

1. Click .

2. Click . If this is your first time in the Migration Analyzer, the New Analysis wizard automatically opens.

Analyzer Page

3. In the New Analysis wizard, under the Analyzer page, specify if you want to check the effects of database migration by either Creating a new Analyzer or Continuing an existing Analyzer.

4. Give your analysis a name and description for easy reference.

5. If you want to create a folder for better organization of your analysis, click .

Select SQL Tab

6. Select the source of the SQL statements for Analysis: SQL Repository or SQL Scanner.

7. Select the SQL statement(s) to add to the Analysis from your predefined SQL statements, or you may add a statement to this Analysis by clicking .

8. Under the SQL Query Plans will be analyzed section, select the options for retrieving your query plan.

   • Using existing query plan saved with the SQL
     This option uses the query plan that was saved with the SQL statement at the time that statement was saved to the SQL Repository, or scanned in the SQL Scanner.
   • Obtaining a new query plan under the current connection
     This option retrieves the query plan with the current database logon that is assumed to be the source Adaptive Server instance you are migrating from. This current query plan is compared to the query plan that is retrieved from the destination Adaptive Server instance for the migration.

Migration Page

9. Give a name and description to your Analysis Scenario (i.e. "Migration to ASE 15.0").

10. Specify the connection information of the destination Adaptive Server instance including login name, password, and server name. If you want to test the specified connection, click .

11. Select whether to use the default database and user or whether you want to login with different database and user information.

Destination Configuration Page

The Destination Configuration page is used to change the database parameters on the migration database and only available after you have entered your migrating database connection information on the Migration page.

12. You can switch the list of configuration parameters for Adaptive Server available in the parameter grid by selecting the parameter category from the Show configuration parameters for drop-down list

13. Make any parameter changes by inserting a value in the New Value column.

14. Click OK to perform the analysis.

Reviewing Migration Analyzer Results

15. After the analysis, you can see the overall results by clicking the Analyzer, and its related information, in the tree structure in the left pane and viewing the corresponding information in the panes to the right.

16. In the right pane for the scenario, click Prognosis to see overall performance changes and SQL details.

Related Topic

Migration Analyzer Overview