Configuration parameters are user-definable settings that control various aspects of Adaptive Server’s behavior. Adaptive Server supplies default values for all configuration parameters. You can use configuration parameters to tailor Adaptive Server for an installation’s particular needs.
Read this chapter carefully to determine which configuration parameters you should reset to optimize server performance. Also, see the Performance and Tuning Guide for further information on using sp_configure to tune Adaptive Server.
WARNING! Change configuration parameters with caution. Arbitrary changes in parameter values can adversely affect Adaptive Server performance and other aspects of server operation.
