I'm using 32bit box with 32GB of RAM, half of that available to Analysys
Services.

While processing a dimension, I received the following error:

Memory error: The operation cannot be completed because the memory quota
estimate (2006MB) exceeds the available system memory (1996MB).


I thought the 3GB memory limit for Analysis Services was removed in
2005...is it still there? Anyway I can get around this?

Hi Jesse,

If you are using a 32bit machine, you will not be able to use more then
3GB of RAM. This is an OS restriction rather then SSAS restriction.
Consider moving to a 64bit machine to utilize more then 3GB of RAM.

Jesse O. wrote:

Thank you.

Our prod box is a 64bit machine and has a bunch of available RAM. However,
this is my dev box.

So there's no way I'll be able to process this large dimension on a 32bit
machine?


<yaniv.mor (AT) mail (DOT) com> wrote

Apparently you haven't turned on /3GB on your machine -- if you turn it on,
you should be able to increase the available process memory to 3 GB instead
of 2GB (the error below shows 1996MB) and this may make it possible to
process the dimension.

There are lots of articles available on the net on enabling the /3GB
switch...

HTH,
Akshai
--
Try out the MSDN Forums for Analysis Services at:
http://forums.microsoft.com/MSDN/Sho...ID=83&SiteID=1

This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"Jesse O." <jesperzz (AT) hotmail (DOT) com> wrote

So once the dimension exceeds 3GB I'll have no other option besides going to
64bit?



"Akshai Mirchandani [MS]" <akshaim (AT) online (DOT) microsoft.com> wrote

will let you process this dimension (not sure here, just an educated
guess). However, as mentioned earlier, you will not be able to use more
then 3GB, that's a given with 32bit OS.

It's not the total size of the dimension that matters here -- it is the
amount of memory that the server needs to process an attribute or hierarchy
in that dimension. So if a particular attribute/hierarchy needs a lot of
memory then you may run into this issue.

There was also an issue fixed in SP1 about the calculation of the memory
required for deep parent/child hierarchies. So if you are seeing this
problem with a parent/child dimension then you may find that SP1 will solve
the problem for you.

In case you haven't heard, SP1 is now publicly available.

Thanks,
Akshai
--
Try out the MSDN Forums for Analysis Services at:
http://forums.microsoft.com/MSDN/Sho...ID=83&SiteID=1

This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"Jesse O." <jesperzz (AT) hotmail (DOT) com> wrote

Hi Akshai,

I'm also getting the same error:

Memory error: The operation cannot be completed because the memory
quota estimate (3254MB) exceeds the available system memory (1330MB).

I've checked on my machine and it already has SP1 installed. Right
after the memory error it tells me that it failed processing one of my
measures.

Does this imply i really do not have enough memory as SP1 only fixes up
this memory calculation for Dimensions, or does it apply to Measures as
well?

Found the hotfix at the address below:
http://support.microsoft.com/default...en-us%3B914595

The issue I mentioned applied only to parent/child dimensions. If you don't
have any, then it probably makes no difference to you...

This error should never happen for measures -- it can happen to a partition,
and perhaps this is what you mean?

If your dimensions are very large then yes, you could see this when
processing a partition -- but frankly I have never seen this happen even
with very large cubes.

Try to split up the processing steps -- first process dimensions, then each
partition and see if you can isolate the problem.

Thanks,
Akshai

<Chong007 (AT) gmail (DOT) com> wrote

Currently I am using windows 2003 enterprise edition and SQL 2005
Analysis Services + SP1 with 4GB RAM on the environment i am working
on. I have seen on this link that
(http://msdn2.microsoft.com/en-us/library/ms175672.aspx) there is a 3GB
limit to what Analysis Services can utilise in my envrionment.

Rather than changing the platform so that analysis services can use
more than 3GB is there anyway i can break up the processing of a
measure group to something smaller? Currently i am encoutering this
problem while trying to process 1 measure group. If it is possible to
break up the processing of this measure group into smaller chucks then
hopefully this would work?

Akshai Mirchandani [MS] wrote: