Chapter 5: Setting Configuration Parameters  The Adaptive Server configuration file

Chapter 5: Setting Configuration Parameters

What are configuration parameters?

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 more 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.





Copyright © 2005. Sybase Inc. All rights reserved. The Adaptive Server configuration file

View this book as PDF