index create memory

Type: Advanced, self-configuring

Default value: 0

The index create memory option is used to control the amount of memory used by index creation sorts. It is a self-configuring option and usually doesn’t need to be adjusted. However, if you are having problems with the creation of large indexes, you might want to try specifying a KB value here that will contain the sort portion of the index create. Zero (0) means “self-configuring” by SQL Server.

The following is an example of this option:

exec sp_configure 'index create memory', 1000goRECONFIGUREgo

Get Microsoft SQL Server 2014 Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.