sp_configure output

The sample output below shows the type of information sp_configure prints if your display level is comprehensive, and you execute sp_configure with no parameters. The values it prints vary, depending on your platform and on what values you have already changed.

sp_configure
Group: Configuration Options

Group: Backup/Recovery

Parameter Name        Default Memory Used Config Value Run Value Unit Type
--------------        ------- ----------- ------------ --------- ---- ----
allow remote access         1          0          1         1    switch dyn
print recovery info         0          0          0         0    switch dyn
recovery interval in m      5          0          5         5    minutes dyn
...

Where:

• The “Default” column displays the default value. If you do not explicitly reconfigure a parameter, it retains its default value.

• “Memory Used” shows the amount of memory, in kilobytes, used by the parameter at its current value. Some related parameters draw from the same memory pool. For instance, the memory used for stack size and stack guard size is already accounted for in the memory used for number of user connections. If you added the memory used by each of these parameters separately, the sume is more than the amount actually used. Parameters that “share” memory with other parameters are marked with a hash mark (“#”).

• “Config Value” displays the most recent value to which the configuration parameter has been set. When you execute sp_configure to modify a dynamic parameter:

  • The configuration and run values are updated.

  • The configuration file is updated.

  • The change takes effect immediately.

  When you modify a static parameter:

  • The configuration value is updated.

  • The configuration file is updated.

  • The change takes effect only when you restart Adaptive Server.

• “Run Value” displays the value Adaptive Server is currently using. It changes when you modify a dynamic parameter’s value and, for static parameters, after you restart Adaptive Server.

• “Unit” displays the unit value of the configuration parameter. Adaptive Server displays information in the following units:

  Name of unit	Unit description
  number	Number of items.
  clock ticks	Number of clock ticks.
  microseconds	Number of microseconds.
  milliseconds	Number of millisecond.s
  seconds	Number of seconds.
  minutes	Number of minutes.
  hours	Number of hours.
  bytes	Number of bytes.
  days	Number of days.
  kilobytes	Number of kilobytes.
  megabytes	Number of megabytes.
  memory pages (2K)	Number of 2K memory pages.
  virtual pages (2K)	Number of 2K virtual pages.
  logical pages	Number of logical pages. This value depends on the logical page size your server is using: 2, 4, 8, or 16K.
  percent	Value of the configured parameter as a percentage.
  ratio	Value of the configured parameter as a ratio.
  switch	Value of the parameter is either TRUE (the parameter is turned on), or FALSE.
  id	ID of the configured parameter you are investigating.
  name	Character string name assigned to the run or configure value of the parameter. For example, “binary” appears under the “Run Value or “Config Value” column for the output of sp_configure "lock scheme".
  row	Number of rows

• “Type” displays whether the configuration option is static or dynamic. Changes to static parameters require that you restart Adaptive Server for the changes to take effect. Changes to dynamic parameters take effect immediately without having to restart Adaptive Server.