I'm having a problem with memory usage on my Analysis Server box.



The box has 4GB of memory and /3GB is enabled.



I have tried many different combinations of the memory
configuration options in Analysis Server but the working set never
gets over 1GB or so.



When processing a large partition with a distinct count measure, it
starts writing to the temp files even though AS is only using ~1GB
of memory.



Current Configuration:

Minimum Allocated Memory: 2047

Memory conservation threshold: 2764

Read-ahead buffer size: 4

Process Buffer size: 2047



When AS starts, it's only using 104MB. Shouldn't this be 2047 based on
the above?



When processing the partition, memory usage will grow to ~1GB while
reading the data, then stabilizie and/or start to decrease while
creating aggregations, even thought it is writing to temp files at this
time. Also, the box starts to page quite a big (>100 Pages / sec)



Based on my understanding of AS memory, I would think that the following
should occur:



1. On startup, AS Working Sets is ~2GB

2. When aggregating, AS Working Set should grow to ~2.7GB prior to using
temp files.

3. Pages / sec should be minimal since there's plenty of memory left
for OS / SQL Server etc. and the aggregation processing uses its own
temp file.



What am I missing here?


--
Randy Knight
Senior Database Engineer
Match.com


Posted via http://dbforums.com