One of the best enhancements included in System 11 is the addition of the
editable configuration text file. This allows you to change the server's configuration
using any text editor, and makes switching configuration files a snap.
Notable configuration parameters:
- Total memory - memory allocated to SQL Server in 2K pages. This memory includes all
memory used by the server process, including: data cache, procedure cache, program memory, and connection
- Procedure cache - percent of cache allocated for stored procs. Decrease this value if stored
procedures are not use frequently by your application. The default is 30.
- User connections - user connection take about 60K each. Set this parameter sparingly,
as it takes more memory than most of the other config values.
- Sort order - set this parm as soon as possible. A sort order id of 50 is default, which
is the case-sensitive type. Recommended: 52, this setting is not case-sensitive.