all groups > sql server data warehouse > june 2005 >
You're in the

sql server data warehouse

group:

msmdsrv.exe takes more than 95% cpu


msmdsrv.exe takes more than 95% cpu §Chrissi§
6/17/2005 6:34:26 PM
sql server data warehouse:
Hi,

The process msmdsrv.exe (ver 8.00.2039) takes more than 95% cpu. The PC is
very very slow. What can I do? I have SP4 for Analysis Services installed.
I thought SP4 could correct the problem but it did not.

When I looked at the Analysis Services in MMC, the PC icon had a small red
square, which indicates the Analysis Services was not running. I did not
connect to it, since the PC was nearly halted.

Please help me!

Thanks.

Re: msmdsrv.exe takes more than 95% cpu Dave Wickert [MSFT]
6/20/2005 4:40:50 PM
Actually msmdsrv *IS* Analysis Services. It is the service.
So it is running -- regardless of what the icon is saying. This just means
that the service APIs cannot detect that it is in a running state. Typically
msmdsrv going into a high CPU loop when the lazy aggregator is running (i.e.
someone kicked off a changing dimension incremental process and the flex
aggs are being reprocessed), or a full processing is being done for a
specific cube, etc.
--
Dave Wickert [MSFT]
dwickert@online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


[quoted text, click to view]

Re: msmdsrv.exe takes more than 95% cpu §Chrissi§
6/30/2005 6:35:30 AM
Do you have a solution to this problem? My OS is windows 2000 server. I
have another PC with Analysis Services. The msmdsrv.exe does not take cpu.

[quoted text, click to view]

Re: msmdsrv.exe takes more than 95% cpu BeWyched
7/20/2005 10:50:08 AM
I had the same problem albiet under Windows XP. I resolved it by:

1: Go to Control Panel/Admin Tools/Services. Find the
MSSQLServerOLAPService, choose properties and check the 'Allow service to
interact with desktop' checkbox.

2: Allow the msmdsrv.exe file through your firewall (file typically found in
the \program files\Microsoft Analyst Service\bin\ folder.

I'm not sure if 2: is required but it seemed to help.

This resolved the problem - I'm not technically competent enough to know why
but it worked!

Good luck.

[quoted text, click to view]
AddThis Social Bookmark Button