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

Comments (4)

  1. Anonymous says:

    Hi, I am also facing the same problem but in my case previously resouce governor was enabled but we disabled it later and restart SQL Instance. I am still facing this error, any idea?

    Gurpreet S Sethi

  2. Anonymous says:

    Thanks for sharing I'm sure many people will have problems with this.

  3. Darek says:

    Thanks it works!

  4. Thanasit says:

    Thank you, It works.