Re: msmdsrv.exe takes more than 95% cpu

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@xxxxxxxxxxxxxxxxxxxx> wrote in message
> news:%23qC1fGfdFHA.2696@xxxxxxxxxxxxxxxxxxxxxxx
> > 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@xxxxxxxxxxxxxxxxxxxx
> > 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@xxxxxxxxxxx> wrote in message
> > news:uuLYlX6cFHA.2420@xxxxxxxxxxxxxxxxxxxxxxx
> >> 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.
> >>
> >
> >
>
>
>
.

Relevant Pages

  • Re: msmdsrv.exe takes more than 95% cpu
    ... 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 ... SQL BI Product Unit (Analysis Services) ... I thought SP4 could correct the problem but it did not. ...
    (microsoft.public.sqlserver.datawarehouse)
  • Creating database roles on analysis services
    ... the "Members" table on SQL Server, I am having a problem in creating roles ... for these same users on Analysis Services. ... I was able to assign roles using DSO when this was a web application. ... since this needs to be a windows application, ...
    (microsoft.public.dotnet.languages.csharp)
  • Assign database role on analysis services using windows applicatio
    ... the "Members" table on SQL Server, I am having a problem in creating roles ... for these same users on Analysis Services. ... I was able to assign roles using DSO when this was a web application. ... since this needs to be a windows application, ...
    (microsoft.public.dotnet.general)
  • Re: OLAP Analysis Services Components Installation
    ... Is it Windows Secruty Problem or something else? ... >> analysis services components, the setup file is runing on Windows ...
    (microsoft.public.sqlserver.olap)
  • Re: OLAP Analysis Services Components Installation
    ... The analysis services setup file held on the windows process task ... > My server installed SQL Server 2000 with SP3a, ... I am not sure that I can't install olap ...
    (microsoft.public.sqlserver.olap)
Loading