Analysis Services eating memory and processor

B

Ben Howard

PS2007 fully patched, SQL 2005 SP2. Has anyone come across msmdsrv.exe
eating memory (by default upto 70% of the available memory) and 85-90% of the
processor. This occurs outside of the scheduled cube building process.
Normally msmdsrv.exe will use about 200KB of memory, rather than 1.5GB! This
appears to occur randomly during the day, and the only resolution appears to
restart SSAS!
 
P

pabeck

PS2007 fully patched, SQL 2005 SP2.  Has anyone come across msmdsrv.exe
eating memory (by default upto 70% of the available memory) and 85-90% ofthe
processor.  This occurs outside of the scheduled cube building process. 
Normally msmdsrv.exe will use about 200KB of memory, rather than 1.5GB!  This
appears to occur randomly during the day, and the only resolution appearsto
restart SSAS!

Ben, we had this issue with SQL Server 2005, and Cumulative Update 6
seemed to fix the problem by cutting off an inefficient join within
the cube building process.
 
B

Ben Howard

Thank you. I'll try this in a couple of weeks and get back to you - I'm
planning to install CU10 anyway to solve a slowness issue for OLAP so
hopefully that will solve the msmdsrv.exe issue too! I'll let you know how I
get on.
--
Thanks, Ben.

Please rate this post if it helped.
http://appleparkltd.spaces.live.com/
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top