Previous Topic: SQL Server/Windows Database CustomizationNext Topic: Distributing Data Files Across Disks


Adjusting Storage Parameters

To avoid performance degradation from tablespace fragmentation, or if you anticipate storing more than 500,000 objects in your encyclopedia, adjust the storage parameters for tables and their corresponding indexes.

The following are the key encyclopedia tables:

To increase storage parameters for these tables follow the SQL Server procedures for space management.