Chat now with support
Chat with Support

SQL Optimizer for SAP ASE 3.8 - Release Notes

New Analysis Wizard: 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 tab. The query plans for the selected SQL statements are retrieved after the parameters are changed in order to analyze the effect changing Adaptive Server configuration parameters will have on the performance of the SQL statements on the destination Adaptive Server instance.

Item Description

Name

Enter a name for this Scenario.

Description

Enter a description for this Scenario.

Show configuration parameters for

You can narrow the selection of parameters available in the parameter grid by selecting the parameter category from this drop-down list.

Show configuration parameters for

You can narrow the list of Adaptive Server configuration parameters available in the parameter grid by selecting the parameter category from this drop-down list.

Parameter settings grid

Enter the new settings for the parameters you want to analyze and what effect changing them will have on the performance of your SQL statements on the destination Adaptive Server instance. This grid displays the parameter name, the default parameter value, the current value, unit of measurement for the parameter and if you must restart the database before the parameter change can take affect. Enter the new parameter setting in the New Value column.

Minimum and Maximum value

Displays the lowest and the highest value that you can enter for the selected parameter.

Monitor Information

Displays the following information. This information is only available for some of the Adaptive Server configuration parameters.

num_free

Amount of scan descriptors, both metadata and auxiliary, which are not currently in use.

num_active

Amount of scan descriptors, both metadata and auxiliary, which are installed in cache and therefore are in use.

pct_act

Percentage of the total number of scan descriptors that are installed in cache and therefore are in use.

Max_Used

Maximum amount of scan descriptors, both metadata and auxiliary, which were in use at any one time since starting the server was started.

Num_Reuse

Number of scan descriptors reused.

 

Description

Provides an explanation of the function of the selected Adaptive Server configuration parameter.

 

Related Topic

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating