I have a client where I have the minimum allocated memory set to 2047 and
memory conservation threashold at 2861. I have read ahead buffer size at
300mb and Process buffer size at 600 mb. However I only see around 139 mb
being used in task manager when running a report. The report takes 12
minutes and their is plenty of ram on the machine (8gb). I have 3gb switch
enabled in boot.ini also. (Standard edition of sql)
Any way to increase the memory allocated to OLAP?

Analysis Services only uses the amount of memory it needs. While the name
"Process Buffer" sounds like a fixed allocation, in reality it is more of
"threshold" which will instruct the system to do something different if the
threshold is crossed, like starting to trim back cache, or shift to a
different aggregation calculation algorithm or something like that. Believe
me, if the system needs the memory it will take it :-)
--
Dave Wickert [MS]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Practices Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Will Byron" <WillB (AT) CEPSystems (DOT) com> wrote