index create memory Option

Use the index create memory option to control the amount of memory used by index creation sorts. The index create memory option is self-configuring; and should work in most cases without requiring adjustment. However, if you experience difficulties creating indexes, you may want to try increasing the value of this option from its run value. Query sorts are controlled through the min memory per query option.

The default value for this option is 0 (self-configuring).

index create memory is an advanced option. If you are using the sp_configure system stored procedure to change the setting, you can change index create memory only when show advanced options is set to 1. The setting takes effect immediately (without a server stop and restart).

To set the index create memory option

See Also