memory management

Hi all,

I'm probably missing something here but I need to know why AS2005 is not using the maximum memory available on our production server.

I have a 3.5 GB cube on our server and the process msmdsrv.exe is only using around 100 mb currently. When multiple users are hitting the server at the same time, msmdsrv.exe goes up to around 650 mb but will eventually return to 100mb.

There is actually 4 GB of memory available on the server, is there any way to maximize the memory used by AS2005 on this box and cach almost the whole cube ? AS2005 is the only thing running on this server.

Currently, we see a lot of disk access when users are querying the cubes.

Thanks,

By default Analysis Server allowed to use 80% of the physical memory avaliable on your machine. This controlled by TotalMemoryLimit server property ( set to 80).

For your users to see improved query performance you need to try and define aggregations. See this post: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=348980&SiteID=1 for discussion about cube performance.

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

|||

This is the reason why I'm asking this question...

If I have 3 GB of memory and AS2005 is allowed to use 80% of it... I would expect AS to be using around 2.4 GB of memory.

In our environment it is using 100 mb when idle and 650 mb when multiple users are querying the cubes...

This is what I need to understand.

BTW i really think that our aggregations are defined properly

Thanks,

Eric

|||

Analysis Server will go to the disk and will try to retrieve results if it cannot find any answers in a cache already. Analysis Server will always cache results from queries. But whether new query can be answered from the cache very much depends on several facts:

1. Queries are similar to the previous queries.
2. Calculation involved in a queries do not require going to the lowest level of granularity.
3. Attribute relationships defined correctly and new query can benefit from not exactly matching cache. ( for example you get answers from Months cache if you asked for Years )

You ultimate goal is not increase Analysis Server's memory footprint, but make your caches more effcient.

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

|||Dear All,

I'm having the same problem. When querying the OLAP by using ProClarity or SSMS (Management Studio), the response time is very low the CPU Utilization is below 10% and Memory Usage not more than 50%. When I check in the performance monitor, the I/O access is very high continuously 100% utilization when I are running query from ProClarity Analytics Server. Is there anything I can do to reduce I/O disk time ?

Thanks in advance.