Configuration Analyzer Tutorial
The Configuration Analyzer evaluates the effect on SQL performance when changing Adaptive Server parameter settings. It enables you to analyze whether the database performance may improve before you make configuration parameter changes permanent.
-
Click
.
-
Click
. If this is your first time in the Configuration Analyzer, the New Analysis wizard automatically opens.
Analyzer Page
-
In the New Analysis wizard, under the Analyzer page, specify if you want to check the effects of configuration changes by either Creating a new Analyzer or Continuing an existing Analyzer.
-
Give the analysis a name and description for easy reference.
-
If you would like to create a folder for better organization of your analysis, click
.
Select SQL Page
-
Select the source of the SQL statements for Analysis: SQL Repository or SQL Scanner.
-
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
.
-
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. This current query plan is compared to the query plan that is retrieved after executing the configuration changes.
Configuration Page
-
Select to view the configuration parameters for the various options within Adaptive Server.
-
Make any parameter changes by inserting a value in the New Value column.
-
Click Finish to perform the analysis.
Reviewing Configuration Analyzer Results
-
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.
-
In the right pane for the Scenarios, click Prognosis to see overall performance changes and SQL details.