MEA Center of Expertise

We are a 120+ technology enthusiasts helping Microsoft customers around Middle-East & Africa region. We bridge Microsoft tools & technologies to their businesses.

Cannot start the columnstore index build; What is Wrong ?

Cannot start the columnstore index build; What is Wrong ?

  • Comments 3
  • Likes

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
  • Thanks for sharing I'm sure many people will have problems with this.

  • Thanks it works!

  • 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? Regards Gurpreet S Sethi

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment