My system runs on Win2k-Server, 4 GB RAM, Analysis-Service Enterprise-Edition. My database is of around 2 GB size. To process the database I need to restart the service before. Otherwise error 123 (Server is out of memory) occurs. I wanted to a test database of same size. Then I couldn't even process one of them without that error. Is this possible? How much physical memory is needed for Analysis-Service? What do you recommend? What else informations do you need

Thanks a lot and greetings from switzerland

This whitepaper addresses the topic in detail. There is an appendix that
discusses memory usage by Analysis Services.

http://www.microsoft.com/technet/pro.../64btdwc4.mspx

Also see the following whitepaper on Analysis Services performance.

http://www.microsoft.com/technet/pro.../ansvcspg.mspx


--
Sean

--
Sean Boon
SQL Server BI Product Unit

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.

"Olaf Fries" <anonymous (AT) discussions (DOT) microsoft.com> wrote

database I need to restart the service before. Otherwise error 123 (Server
is out of memory) occurs. I wanted to a test database of same size. Then I
couldn't even process one of them without that error. Is this possible? How
much physical memory is needed for Analysis-Service? What do you recommend?
What else informations do you need?