dbTalk Databases Forums  

OLAP process doesn't release memory

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


Discuss OLAP process doesn't release memory in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Yashrah [Xavor]
 
Posts: n/a

Default OLAP process doesn't release memory - 09-06-2004 , 05:47 AM






Hi,
My application uses 32 bit SQL Server 2000 Analysis
Services in a clustered environment. There are 2 DTS
packages that process the dimensions and the cubes after
every 30 mins. now the problem is at the Analysis Server
side, after these dts have run sucessfully, the olap
process (msmdsrv) doesn't release all the acquired memory.
the physical and virtual memory consumption this way keeps
incerementing after each dts run and after a week or so,
OLAP throws error message that the server is out of
memory.

On Analysis Services restart, all the memory is released
but soon it gets consumed after dts runs.

any help regarding memory leak in OLAP Process ?

regards
yashrah

Reply With Quote
  #2  
Old   
Jéjé
 
Posts: n/a

Default Re: OLAP process doesn't release memory - 09-06-2004 , 09:00 AM






look at:
http://support.microsoft.com/?kbid=831045

do you use the SP3?
how do you process your cube? what tool do you use?

"Yashrah [Xavor]" <ymasood (AT) xavor (DOT) com> a écrit dans le message de news:
056001c493fe$dc3c92b0$a401280a (AT) phx (DOT) gbl...
Quote:
Hi,
My application uses 32 bit SQL Server 2000 Analysis
Services in a clustered environment. There are 2 DTS
packages that process the dimensions and the cubes after
every 30 mins. now the problem is at the Analysis Server
side, after these dts have run sucessfully, the olap
process (msmdsrv) doesn't release all the acquired memory.
the physical and virtual memory consumption this way keeps
incerementing after each dts run and after a week or so,
OLAP throws error message that the server is out of
memory.

On Analysis Services restart, all the memory is released
but soon it gets consumed after dts runs.

any help regarding memory leak in OLAP Process ?

regards
yashrah



Reply With Quote
  #3  
Old   
Bas Kersten [MSFT]
 
Posts: n/a

Default RE: OLAP process doesn't release memory - 09-08-2004 , 03:10 AM



Hi,

I recommend that you install one of the latest builds we fixed some issue
that look like this. Just let me know if you need a build to test with.

cheers,
Bas

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


Reply With Quote
  #4  
Old   
Rukmani
 
Posts: n/a

Default RE: OLAP process doesn't release memory - 10-20-2004 , 09:56 PM



Hi Bas,

What do you mean by builds ? Service Packs ?
Where can I get a list of builds and the software itself ?

Thanks,
Rukmani.

""Bas Kersten [MSFT]"" wrote:

Quote:
Hi,

I recommend that you install one of the latest builds we fixed some issue
that look like this. Just let me know if you need a build to test with.

cheers,
Bas

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



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.