MSMDSRV.EXE using 99% of CPU post Win2k SP4

  • Thread starter Thread starter TP Costello
  • Start date Start date
T

TP Costello

I just installed Windows 2000 SP4 on a SQL server machine. Upon
rebooting the machine, MSMDSRV.EXE was consuming 99% of the CPU, and
the machine was extremely slow responding to anything. Stopping the
IIS Admin service would bring the CPU usage back down. Everything I
have read regarding MSMDSRV.EXE seems to be related to SQL server, and
the Analysis Server. Uninstalling IIS will rectify the problem, but I
need IIS also. Any ideas what is going on?
Thanks a lot...
 
And no need to multi-post it all over the place either. If you want to post
to more than one group - if it's absolutely necessary - use one message
addressed to the groups, not individual identical messages.

Ray at work

Dave Patrick said:
Best to ask in sqlserver.server

--
Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft MVP [Windows NT/2000 Operating Systems]

TP Costello said:
I just installed Windows 2000 SP4 on a SQL server machine. Upon
rebooting the machine, MSMDSRV.EXE was consuming 99% of the CPU, and
the machine was extremely slow responding to anything. Stopping the
IIS Admin service would bring the CPU usage back down. Everything I
have read regarding MSMDSRV.EXE seems to be related to SQL server, and
the Analysis Server. Uninstalling IIS will rectify the problem, but I
need IIS also. Any ideas what is going on?
Thanks a lot...
Click to expand...
Click to expand...
 
Dear Customer,

Thank you for your posting.

Based on the description, the issue is related to the Msmdsrv.exe SQL
Server 2000 Analysis Services. To resolve this problem, obtain the latest
service pack for Microsoft SQL Server 2000.

SQL Server 2000 Service Pack 3a:
http://www.microsoft.com/sql/downloads/2000/sp3.asp

In addition, if you would, please post this question in the sqlserver
newsgroup. The sqlserver newsgroup is primarily for issues involving SQL
Server. The reason why we recommend posting appropriately is you will get
the most qualified pool of respondents, and other partners who read the
newsgroups regularly can either share their knowledge or learn from your
interaction with us.

Thanks and have a good day!

Regards,

Benny Fu
Microsoft Online Partner Support
Microsoft Corporation
Get Secure! – www.microsoft.com/security

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

--------------------
| From: (e-mail address removed) (TP Costello)
| Newsgroups: microsoft.public.win2000.general
| Subject: MSMDSRV.EXE using 99% of CPU post Win2k SP4
| Date: 29 Jul 2003 09:11:59 -0700
| Organization: http://groups.google.com/
| Lines: 8
| Message-ID: <[email protected]>
| NNTP-Posting-Host: 209.242.61.90
| Content-Type: text/plain; charset=ISO-8859-1
| Content-Transfer-Encoding: 8bit
| X-Trace: posting.google.com 1059495120 12967 127.0.0.1 (29 Jul 2003
16:12:00 GMT)
| X-Complaints-To: (e-mail address removed)
| NNTP-Posting-Date: 29 Jul 2003 16:12:00 GMT
| Path:
cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.sul.t-online.de!t-onlin
e.de!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!sn-xit-03!sn-xit-01!sn-
xit-09!supernews.com!postnews1.google.com!not-for-mail
| Xref: cpmsftngxa06.phx.gbl microsoft.public.win2000.general:62947
| X-Tomcat-NG: microsoft.public.win2000.general
|
| I just installed Windows 2000 SP4 on a SQL server machine. Upon
| rebooting the machine, MSMDSRV.EXE was consuming 99% of the CPU, and
| the machine was extremely slow responding to anything. Stopping the
| IIS Admin service would bring the CPU usage back down. Everything I
| have read regarding MSMDSRV.EXE seems to be related to SQL server, and
| the Analysis Server. Uninstalling IIS will rectify the problem, but I
| need IIS also. Any ideas what is going on?
| Thanks a lot...
|
 
Back
Top