SQL Server Error Msg 35386 – Unable to allocate %I64d KB for columnstore compression because it exceeds the remaining memory from total allocated for current resource class and DWU. Please rerun query at a higher resource class, and also consider increasing DWU. See ‘https://aka.ms/sqldw_columnstore_memory’ for assistance.

In this blog post, let’s learn about the error message “35386 – Unable to allocate %I64d KB for columnstore compression because it exceeds the remaining memory from total allocated for current resource class and DWU. Please rerun query at a higher resource class, and also consider increasing DWU. See ‘https://aka.ms/sqldw_columnstore_memory’ for assistance.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.

SQL Server Error Message

35386 – Unable to allocate %I64d KB for columnstore compression because it exceeds the remaining memory from total allocated for current resource class and DWU. Please rerun query at a higher resource class, and also consider increasing DWU. See ‘https://aka.ms/sqldw_columnstore_memory’ for assistance.

Reason for the Error

To be update soon…

Solution

To be update soon…