Memory Questions

I am running SSAS 2005 SP1 on a machine with Windows 2003 Server R2 and 2 GB of memory.I have approximately 30 analysis databases defined on this machine.

When I process one of my analysis databases, MSMDSRV.EXE gradually takes over 1 GB of virtual memory and does not release it once processing is completed.Once processing completes, MSMDSRV.EXE continues to take up 5-15% of CPU to process something.This goes on for hours.

Let’s say I go into BIDS on this machine and try to open an analysis database by entering the server name then attempting to select a database from the database drop down.It takes about 10 minutes for the list of databases to appear on the screen, and you can watch MSMDSRV.EXE take up more and more virtual memory until it takes over 1 GB of virtual memory.

- Why is SSAS taking up so much virtual memory to perform these operations? Is it metadata overload?

- Is there any way to get MSMDSRV.EXE to release the virtual memory it has taken?

- Once database processing has been completed, what is MSMDSRV.EXE doing that would take 5-15% of CPU?

- Is there a recommended solution to improve memory handling and performance in this situation?

Thanks in advance for your help.

Wendell G.

Is this a recent event or a continual event?

Is the server recognizing the 2gig's of RAM and the full capacity of the processor(s)?

How old is the server?

Adamus

|||

This has been a continual event and has appeared to get worse as more analysis services databases are added to the server.

The server is recognizing the 2 GB ram and is less than one year old.

Wendell G.

|||

Not knowing your situation, the immiteate suggestion is to increase memory of your machine.

2 Gb looks litte on the lower side.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||I have exactly the same situation but I have 12G RAM
each process of the cube increases the memory of the msmdsrv.exe by 2G
eventualy after 4 / 5 processings it fails with a page file % nearly full and the users cannot access. CPU useage by is 13% constant build of sql is 3054 on test server and 3152 on live server both servers have same issue.

Was there an answer to the above appart from more RAM i.e. should the memory be released?

Firts process of cube useage = 951M ,
Second process of cube usage starts at 951M and completes at 2,951M
Third process starts at 2,951 and increases etc and so on till memory all used
Thanks