| |
Home |
![[Table of Contents]](/dwicons/b_toc.gif)
|
System Administration Guide (Online Only) |
![[-]](/dwicons/i_colpse.gif)
| Chapter 5 Setting Configuration Parameters |
Chapter 5
This chapter describes the Adaptive Server configuration parameters. A configuration parameter is a user-definable setting that you set with the system procedure sp_configure. Configuration parameters are used for a wide range of services, from basic to specific server operations, and for performance tuning.
| Adaptive Server configuration parameters |
|
| What are configuration parameters? |
| The Adaptive Server configuration file |
| How to modify configuration parameters |
| Who can modify configuration parameters? |
| Unit specification using sp_configure |
| Getting help information on configuration parameters |
|
| Using sp_configure |
![[+]](/dwicons/i_expand.gif)
| Syntax elements |
|
| Using sp_configure with a configuration file |
| The parameter hierarchy |
|
| User-defined subsets of the parameter hierarchy: display levels |
| The reconfigure command |
| Performance tuning with sp_configure and sp_sysmon |
| Output from sp_configure |
|
| The sysconfigures and syscurconfigs tables |
| Querying syscurconfigs and sysconfigures: an example |
|
| Details on configuration parameters |
| Renamed configuration parameters |
| Replaced configuration parameter |
|
| Backup and recovery |
|
| Cache manager |
|
| Component Integration Services administration |
|
| Disk I/O |
|
| DTM administration |
|
| Error log |
|
| Extended stored procedures |
|
| General information |
|
| Java services |
|
| Languages |
|
| Lock Manager |
|
| Memory use |
|
| Metadata caches |
|
| Network communication |
|
| O/S resources |
|
| Parallel queries |
|
| Physical memory |
|
| Processors |
|
| RepAgent thread administration |
|
| SQL server administration |
|
| Security related |
|
| Unicode |
|
| User environment |
|
|