SQL Server Error Code – 8606 this index operation requires %i64d kb o

AbundantCode 3 weeks ago in SQL Server 0

In this blog post, you’ll learn more about the SQL Server Error Code 8606 and the error message description that is shown

SQL Server Error Code

8606

SQL Server Error Description for the Code :8606

This index operation requires %I64d KB of memory per DOP. The total requirement of %I64d KB for DOP of %lu is greater than the sp_configure value of %lu KB set for the advanced server configuration option “index create memory (KB)”.  Increase this setting or reduce DOP and rerun the query.

Tags :

Leave Your Comment