TotalMemoryLimit, AggregationMemoryLimit and BufferMemoryL..

There are 3 SSAS 2005 memory configuration points which are confusing to me:

* Memory\TotalMemoryLimit
* OLAP\Process\AggregationMemoryLimit
* OLAP\Process\BufferMemoryLimit

I have read documents that state they all take either a percentage or a set
amount of total physical memory. So if let's say the TotalMemoryLimit is set
to 40, AggregationMemoryLimit is 80 and BufferMemoryLimit is 60, would that
mean SSAS will try to use 40+80+60=180% of the total memory? Is there one
setting that says "you get X % of memory and everything else uses memory from
that".

This is all very confusing. SQL Server is much cleaner.

I recommend articles below.

http://www.microsoft.com/technet/prodtechnol/sql/2000/reskit/part6/c26...mspx?mf
http://download.microsoft.com/download/8/5/e/85eea4fa-b3bb-4426-97d0-7...51b2011

Ohjoo

"Shahryar G. Hashemi" wrote
in message
> There are 3 SSAS 2005 memory configuration points which are confusing to
> me:
>
> * Memory\TotalMemoryLimit
> * OLAP\Process\AggregationMemoryLimit
> * OLAP\Process\BufferMemoryLimit
>
> I have read documents that state they all take either a percentage or a
> set
> amount of total physical memory. So if let's say the TotalMemoryLimit is
> set
> to 40, AggregationMemoryLimit is 80 and BufferMemoryLimit is 60, would
> that
> mean SSAS will try to use 40+80+60=180% of the total memory? Is there one
> setting that says "you get X % of memory and everything else uses memory
> from
> that".
>
> This is all very confusing. SQL Server is much cleaner.