msmdsrv.exe takes more than 95% cpu

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.
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.
"Chrissi" <anubisofthydeath@.hotmail.com> wrote in message
news:uuLYlX6cFHA.2420@.TK2MSFTNGP12.phx.gbl...
> 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.
>
|||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.
"Dave Wickert [MSFT]" <dwickert@.online.microsoft.com> wrote in message
news:%23qC1fGfdFHA.2696@.TK2MSFTNGP09.phx.gbl...
> 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.
>
> "Chrissi" <anubisofthydeath@.hotmail.com> wrote in message
> news:uuLYlX6cFHA.2420@.TK2MSFTNGP12.phx.gbl...
>
|||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.
"§Chrissi§" wrote:

> 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.
> "Dave Wickert [MSFT]" <dwickert@.online.microsoft.com> wrote in message
> news:%23qC1fGfdFHA.2696@.TK2MSFTNGP09.phx.gbl...
>
>