RE: OLAP process consuming a lot of memory

#1

If You use windows nt server standar edition and/or SQL standar
You mus
reduce the cube size /see size calculator/ in olap database

#2

Have you looked at the AS Performance Guide at:
http://www.microsoft.com/technet/pro...e/AnSvcsPG.asp
and the AS Operations Guide at:
http://www.microsoft.com/technet/pro...e/anservog.asp ?
Both of these have information on this topic.
--
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.

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

Quote:

Hi

The Sql Server analysis services server process "msmdsrv" is consuming a
lot of memory and when it reaches its threshold value it gives error "out of

memory" and automatically gets restarted.

Quote:

As far as i know all the dimensions for all the databases are loaded into
the memory.....if i cut short my databases then the process may consume less

memory. The only way to cut short my databases is that i archive the old
data BUT WILL I BE ABLE TO DO ANALYSIS ON THAT ARCHIVED DATA AND GENERATE
REPORTS FROM IT cause this data is business related and is very critical?

Quote:

if anyone knows plz reply.
regards
yashrah.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

RE: OLAP process consuming a lot of memory

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

RE: OLAP process consuming a lot of memory - 02-25-2004 , 04:46 AM

Re: OLAP process consuming a lot of memory - 02-25-2004 , 11:35 AM