Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
How to: Configure the index create memory Option (SQL Server Management Studio)
Collapse the table of content
Expand the table of content

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

  1. In Object Explorer, right-click a server and select Properties.

  2. Click the Memory node.

  3. 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.

Community Additions

ADD
Show:
© 2015 Microsoft