New Analysis Wizard: Configuration Page
View New Analysis Wizard - Configuration Page
The Configuration page is used to change the database parameters. The query plans for the selected SQL statements are retrieved after the parameters are changed in order to analysis the effect changing database parameters will have on the performance of the SQL statements.
Each set of configuration parameters used in an analysis is called a Scenario. When you create an analysis, you can create one Scenario. Additional Scenarios can be created after the analysis is created.
| 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. | ||||||||||
|
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. 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.
| ||||||||||
|
Description |
Provides an explanation of the function of the selected Adaptive Server configuration parameter. |