How to: Configure the index create memory Option (SQL Server Management Studio)
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 usually works without requiring adjustment. However, if you experience difficulties creating indexes, consider increasing the value of this option from its run value.
To configure the index create memory option
In Object Explorer, right-click a server and select Properties.
Click the Memory node.
Under Index creation memory, type or select the desired value for the 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, consider increasing the value of this option from its run value. Query sorts are controlled through the min memory per query option.
See Also
Concepts
index create memory Option
min memory per query Option