# Database Configuration Parameters

The Database Configuration Parameters dialog box enables you to modify database configuration parameters. For more information about tuning database parameters, consult the database specific Infor LN - Performance, Tracing and Tuning Guide for SQL Server.

## AutoGrow

The AutoGrow option, controls whether database files (data, log) will grow automatically as needed when their existing space is exhausted.

For performance reasons, it is recommended to allocate the appropriate database size upfront and let the database grow with large chunks in order to prevent fragmentation.

Compress Database Tables will enable page compression on complete tables and indexes in SQL Server. Ensure you use a SQL Server edition that supports compression.

## SQL Server Database Collation

This drop down box is filled with several collations. The collation list depends on the choice you made earlier in the Locale dialog. The database will be created with the collation setting you select here.

See the Infor Enterprise Server - Technical Reference Guide for Microsoft SQL Server Database Driver for more specific information.