Sqlserver Analysis Services handles Memory Errors in dimensions
Error description:
This operation cannot be completed because the estimated memory quota (xxxxmb) exceeds the amount of memory available by the system (1330 MB.
Error cause:
This problem occurs because sqlserver expects that the Processing Memory exceeds the configured maximum memory. I did not find the correct solution on the Internet at first, including no results after consulting with the official team. Finally, I carefully studied the OLAP configuration file OLAP/config/msmdsrv. ini.
Solution:
Modify two nodes in the INI File
If processplan/memorylimiterrorenabled is 0, no memory limit is imposed.
Processplan/memorylimit is 65 by default. That is, 65%. The so-called 1330m limit can be broken by increasing the limit.
Other nodes also optimize the space. For example, you can modify the number of maxthreads with multiple CPUs, which is not covered in this article.
Increase System Virtual Memory settings and restart the computer
Of course, this change also relies on sufficient hardware support.