Udostępnij za pośrednictwem

Cannot start the columnstore index build; What is Wrong ?

  • Artykuł

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

  • Anonymous
    January 01, 2003
    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?RegardsGurpreet S Sethi

  • Anonymous
    January 01, 2003
    Thanks for sharing I'm sure many people will have problems with this.

  • Anonymous
    September 20, 2013
    Thanks it works!

  • Anonymous
    November 29, 2015
    Thank you, It works.