Cannot start the columnstore index build; What is Wrong ?

you’re trying to build a ColumnStore Index and Increased the DOP or using multiple columns on the Index and you did received this error message

“cannot start the columnstore index build because it requires at least 760040 KB, while the maximum memory grant is limited to KB per query in workload group 'default'”

Well don’t decrease your Columns. Simply it’s a Resource Governor modification “even if it’s not enabled” as the default workgroup is created by default with 25% of Memory per Query…!!!

1. Go To Resource Governor under Management

2. enable it and change the default workgroup in the memory granted to 100RG2

3. try building again the index it’ll succeed