January 25, 2012 at 8:09 am
Hi,
While processing particular dimesion of my cube , i am getting error as mentioned below.
memory error the operation cannot be completed because the memory quota estimate (3569MB)exceeds the available system memory (1331MB)
My Server has 4 GB RAM and has installed 32bit Windows Server 2003 operating system .
About my dimension processing , I am processing one dimension at a time through SSIS Package dynamically.
There will be around 20 millions of record. There are 10 columns for each record.
Please anybody help me to resolve this issue .
Thanks in advance !
January 25, 2012 at 11:26 pm
Get a 64-bit OS and put in more RAM?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 27, 2012 at 8:07 am
Hi,
I can not afford 64bit operating on server at this moment .
Could you please suggest any other option ?
Thanks in advance !
January 29, 2012 at 12:15 am
Prashant Mhaske (1/27/2012)
Hi,I can not afford 64bit operating on server at this moment .
Could you please suggest any other option ?
Thanks in advance !
Process the data in smaller chunks instead of everything at the same time.
edit: sorry, partitioning is for measure groups, not dimensions. Ignore my advice.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 29, 2012 at 6:32 am
What else (except for SQL Server Database & Analysis Services) is running on the box? Please stop unnecessary services.
If you read the error message, it’s pretty much clear SSAS is trying to consume 3.5 GB RAM (80% of Physical Memory, DEFAULT configuration) but only 1 GB is available for its operation. So setting up memory options for SSAS will help. It would be slow but won’t estimate much memory.
More: (Search for 'TotalMemoryLimit')
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply