Chat now with support
Chat mit Support

SQL Optimizer for SAP ASE 3.8 - User Guide

Introduction Tutorials Preferences Editor Functions SQL Information and Functions Performance Monitor SQL Inspector SQL Collector for Monitor Server SQL Scanner Index Advisor SQL Optimizer
SQL Optimizer Overview Optimization Engine Common Coding Errors in SQL Statements What Function Should l Use to Retrieve the Run Time? Unsatisfactory Performance Results SQL Optimizer Functions SQL Editor Optimized SQL Activity Log
SQL Worksheet SQL Formatter Database Explorer Code Finder Object Extractor SQL Repository Index Impact Analyzer Index Usage Analyzer Configuration Analyzer Migration Analyzer Abstract Plan Manager User-Defined Temp Tables SQL History Legal Information

New Analysis Wizard: Analyzer Page

Migration Analyzer > Create a Migration Analysis > New Analysis Wizard: Analyzer Page

The Analyzer tab is used to name the analysis and to select the folder where the SQL statements that you want to analyze are stored.

Creating a new Analyzer and select SQL to be analyzed

Select this option to create a new analysis using a different set of SQL statements.

Continuing an existing Analyzer using the Analyzer's selected SQL

Select this option to use the same set of SQL statements that is stored in an existing Analyzer. This option adds another Scenario under an existing Analyzer and does not retrieve a new set of query plans for the SQL statements. It uses the query plans that were originally saved with the SQL statements.

Do not rollback changes to the ASE configuration parameters

Specific to leaves the database configuration changes that you select under the Configuration tab after the analysis is finished. Otherwise, these changes are rolled back at the end of the analysis processing. After the analysis is complete, the Apply/Undo Changes button displays at the top of the Migration Analyzer window which displays the Apply Changes and the Undo Changes panes. These panes contain the scripts to make changes to the Adaptive Server configuration parameters.

Item Description

Name

Enter the name for the analysis.

Description

Enter the description for the analysis.

Last modified

Displays the last modified date and time.

Save location

Displays the folder in the tree where the analysis is saved. In the bottom pane, select the folder where you want to save the analysis.

To create a new folder

Click Add Folder image\B_AddFolder.gif.

 

Related Topic

New Analysis Wizard: Select SQL Page

Migration Analyzer > Create a Migration Analysis > New Analysis Wizard: Select SQL Page

The Select SQL page is used to select the SQL statements whose query plans you want to analyze when various database parameters are changed.

Select SQL to check for performance changes:

Select SQL from

The SQL statements used in an analysis can be taken from the SQL Repository and the SQL Scanner. If you select SQL statements from the SQL Scanner, these statements are added to the SQL Repository.

SQL query plans will be analyzed:

In the Migration Analyzer, the query plans for the selected SQL statements current database are compared to the query plans in the database for the migration. The following options allow you to determine the "before" query plans.

Using existing query plan saved with the SQL

This option uses the query plan that was saved with the SQL statement when it was saved in the SQL Repository or 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.

 

Related Topic

New Analysis Wizard: Migration Page

Migration Analyzer > Create a Migration Analysis > New Analysis Wizard: Migration Page

The Migration tab is used to specify the database connection to retrieve the query plans for the selected SQL statements from the Adaptive Server instance for the migration in order to analysis the changes in the query plans that result from migrating to a new Adaptive Server instance.

Item Description

Name

Enter a name for this Scenario.

Description

Enter a description for this Scenario.

Login name

Enter the name of the login for the destination Adaptive Server instance.

Password

Enter the password of the login.

Server name

Enter the database server you are logging into from the drop down field, or enter the name directly.

Use default database and user

Select this option if you would like to login with the default database and user information and privileges.

Specify database and user

Select this option if you would like to set the user to one with different credentials or privileges. Enter the database and user.

Note: The new query plans from the Adaptive Server instance for the migration are compared to the query plans that were retrieved either when the selected SQL was saved or that are retrieved using the current logon.

 

Related Topic

New Analysis Wizard: Destination Configuration Page

Migration Analyzer > Create a Migration Analysis > 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

Verwandte Dokumente

The document was helpful.

Bewertung auswählen

I easily found the information I needed.

Bewertung auswählen