One SSAS Job is failing with high memory utilization.

Question

One SSAS job in SQL Server failing with high memory utilization even after increasing the memory size it keeps on failing and resulting us the job to fail. Can you please suggest what we can do as we are increasing the size every time the job is failing with same error as high memory utilization. Please find the below error.

Error:

$warningAction -InformationAction $informationAction '. Correct the script and reschedule the job. The error information returned by PowerShell is: '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. Database consistency checks (DBCC) failed while checking the 'Quarter End Prelim' database. '.

Note: We are using 64-bit version.

Answer 1

You are using SSAS in "Tabular Mode", right?

Tabular is an in-memory engine and holds the complete database(s) + cube(s) in memory.

Therefore you have to increase memory size or decrease cube size.