Chat now with support
Chat with Support

SQL Optimizer for SAP ASE 3.9.1 - Release Notes

Migration Analysis Results

Upon completion of the migration analysis process, a summary of the analysis is the Migration Analysis Details window, which tells if any of the query plans retrieval failed for any of the SQL in the Scenario. The comparison of the query plans, estimated I/O cost, abstract plans, Trace On information, and SQL Classification displays in the right pane of the Migration Analyzer window.

Once the analysis is complete, the best way to compare the behavior of the SQL in the analysis is to select the Scenario from the left tree structure.

Properties Button

The initial view is of the Properties of the Scenario and it gives a basic summary of the analysis including the configuration parameters that were specified as different between the databases.

Prognosis Button

The Prognosis section of an analysis is the best way to analyze the results to see how the performance of the SQL statements will be affected by the migration. The Prognosis has two tabs in the top pane that provide the overview of the impact of the migration on SQL performance: Chart and Summary. Specific information about the individual SQL statements displays in the middle and bottom panes.

Click any portion of the chart and the SQL statements represented are highlighted in the grid below the charts.

Chart Tab

Total Cost Chart

This chart shows the overall Estimated I/O cost differences of the SQL statements when connected to the current Adaptive Server instance and when connected to the destination Adaptive Server instance.

SQL with Cost Change Chart

This chart represents those specific statements whose query plans undergo a change in Estimated I/O cost. Click any portion of the chart and the SQL statements represented are highlighted in the grid below the charts.

SQL with Plan Structure Change Chart

This chart represents those statements that experience a structure change in their query plan, regardless of any cost changes.

Classification Changes Chart

This chart indicates any SQL statements whose query plans undergo a change in classification (Simple, Complex, and Problematic). The statements that experience degradation in performance would be the best statements to work with to optimize before migrating to the new Adaptive Server instance, since they are the statements that could potentially cause performance problems.

SQL Classification Chart

This chart gives the aggregate view of the classifications of the SQL statements in the analysis.

Summary Tab

Presents a summary of the analysis in text format showing the statistics that are used in the charts.

Configuration Parameters Button

Displays the configuration parameters for the destination Adaptive Server instance. For each parameter it displays current value and the old parameter value before the analysis. The Configuration Parameters pane is only displayed if changes to configuration parameters were specified for the destination instance during the migration analysis.

Apply Changes

Displays the script for making the configuration parameters changes on Adaptive Server. Press Executeimage\B_Execute.gif to run the script.

 

Related Topic

Related Documents