Index Create Memory (KB)

The index create memory (KB) setting is used to limit the amount of memory SQL Server will use when creating an index. Setting this limit too low can result in failure to create indexes.

Suggested Action

Change the index create memory (KB) setting back to the default of zero to allow self-configuration of the memory used when creating indexes.

Any suggestion from Aireforge should be thoroughly tested before being implemented into production.