SSAS TABULAR: Not enough memory

Question

Troilus83 on Mon, 08 Apr 2013 21:26:42


Hello everybody, I have an instance of SSAS Tabular that when I build reports from an Excel Pivot Table, sometimes i got the error: "The operation has been cancelled because there is not enough memory available for the application. If using a 32-bit version of the product, consider upgrading to the 64-bit version or increasing the amount of memory available on the machine." I read some posts about this error but I think that it could be a different problem, the system is a 4x2 core and got 32 GB RAM, when you go to the pivot table and build any report by an aggregation level, the response time is very fast but when I go to the lowest granularity level on the fact (product id) and try to obtain product id on a report aggregate by 3 dimensions and 1xMeasure I got this error. The fact table actually have about 30 million records and that dimension (product id) contains a large number of records (around 5-7 millions). The same report but with filtered values takes about 3 minutes to get the result. The Tabular has the default configuration properties. Any tip or help would be appreciate. Thanks in advance. Cheers.





Replies

Olaf Helper on Tue, 09 Apr 2013 06:08:10


 using a 32-bit version of the product, consider upgrading to the 64-bit advance.

Hello,

A 32 bit application can only use max 3 GB memory, even if more free memory is available.

Troilus83 on Tue, 09 Apr 2013 07:17:13


Hello Olaf,

Thanks for your response, the server is 64-bit and this kind of reports consumes all the RAM until it exceeds the HardMemoryLimit.

Cheers.

Elvis Long on Wed, 10 Apr 2013 03:06:12


Hello Olaf,

Thanks for your response, the server is 64-bit and this kind of reports consumes all the RAM until it exceeds the HardMemoryLimit.

Cheers.

Hi Troilus83,

What's the version of your Office Excel? Is it 32-bit version? Please take a look at the following articles:
Memory Considerations about PowerPivot for Excel: http://sqlblog.com/blogs/marco_russo/archive/2010/01/26/memory-considerations-about-powerpivot-for-excel.aspx
What happens when a SSAS Tabular model exceeds memory? http://www.jamesserra.com/archive/2012/05/what-happens-when-a-ssas-tabular-model-exceeds-memory/

Regards,