Non-Default Index Create Memory Setting

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

šŸ’” Aireforge Advisor can automatically generate a script for this.

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

How to Reset Index Create Memory Back to Default (0)

EXEC sys.sp_configure N'show advanced options', N'1' 
GO
RECONFIGURE
GO
EXEC sys.sp_configure N'index create memory (KB)', N'0'
GO
RECONFIGURE
GO

Further Reading

Configure the index create memory Server Configuration Option | Microsoft Docs