The Configuration page consists of a single grid—the Configuration Parameter grid.
The parameters listed on this grid are from the parameter groupings that impact memory use for the Adaptive Server.
Selecting a row will return an explanation of the parameter in the text box at the bottom of the page.
You can test the impact to memory for a parameter change by inputting the Speculative Value in the field below the grid and selecting OK. The text box will display the change the value would have on memory if implemented. (You can implement the change with a tool such as ISQL with sp_configure.)
The following table describes the columns on the grid:
|
Column |
Description |
|
Parameter Name |
Name used to reference the value. |
|
Group Name |
Group(s) that the parameter is a member of. |
|
Memory Used |
Amount of memory used (in Kilobytes) for the current run value. |
|
Run Value |
Value the Adaptive Server is using. The units this value represents are found in the "Unit" column. |
|
Config Value |
The most recently configured value for this parameter. If the parameter is static, this value will not go into effect until the server is rebooted. The units this value represents are found in the "Unit" column. |
|
Default Value |
The default value for the parameter. The units this value represents are found in the "Unit" column. |
|
Default Set |
True if the parameter is currently set to the default value. Use this to determine what values may have been changed from their default settings by sorting on this column. |
|
Unit |
Unit of measurement for the parameter settings. |
|
Type |
Dynamic or static. Dynamic parameters take effect when set. Static parameters only become active after the Adaptive Server is rebooted. |
|
Shared Value |
True if the memory allocation for the parameter is included in another parameter's totals. |
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center
