I am trying to create some indexes a SQL Server 2008 database but am getting the following error message.
Msg 8606, Level 17, State 1, Line 1 This index operation requires 1024 KB of memory per DOP. The total requirement of 2048 KB for DOP of 2 is greater than the sp_configure value of 704 KB set for the advanced server configuration option "index create memory (KB)". Increase this setting or reduce DOP and rerun the query.
Currently the index creation memory setting is set to 794KB and the minimum memory per query is set to 1024KB. What would be the impact of changing these values? Especially with regards to performance. Should I change them, create the index and change them back or should I set it to 0?