mssdmn consuming cpu and memory

I have a sql 2000 SP4 server with two processors that has started to consume
cpu cycles (25% or more on each processor). The proces that is consuming
the cpu is mssdmn. The server hosts three major databases; MS Sharepoint
team services, Lyris list manager, and Macromedia Breeze. Over the weekend
I shutdown all three of these major servers and the cpu continued to be
consumed. I have run Symantec AV and found no viruses. I have restarted
the SQL server several times and the problem continues. I find that if I
work in SQL Enterprise Manager on the sql server the cpu decreases, which I
guess points to a background process.
The server O/S is Windows 2003 server with the latest service packs and
updates applied.
Any suggestions on how to solve the problem would be grealy appreciated.
ThanksThis is SQL FTS - actually MSSearch. You might want to configure it to be
less invasive or perhaps more invasive. Use sp_fulltext_server
'resource_usage' to do this. Configure it for 1 to get less invasive, 5 to
get more invasive.
The question you should be asking yourself is why is it indexing all the
time. What sorts of docs are you storing, and are any of them in Far Eastern
languages or in German. These tend to be resource intensive.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Jim Boyer" <boyerj@.wsu.edu> wrote in message
news:92bbe140b9d046ddb63a62ee9eef93a8@.ur
eader.com...
> I have a sql 2000 SP4 server with two processors that has started to
consume
> cpu cycles (25% or more on each processor). The proces that is consuming
> the cpu is mssdmn. The server hosts three major databases; MS Sharepoint
> team services, Lyris list manager, and Macromedia Breeze. Over the
weekend
> I shutdown all three of these major servers and the cpu continued to be
> consumed. I have run Symantec AV and found no viruses. I have restarted
> the SQL server several times and the problem continues. I find that if I
> work in SQL Enterprise Manager on the sql server the cpu decreases, which
I
> guess points to a background process.
> The server O/S is Windows 2003 server with the latest service packs and
> updates applied.
> Any suggestions on how to solve the problem would be grealy appreciated.
> Thanks