Firehose mode is disrupting processes

Over the last two months our SQL 2000 Server has been going into
firehose mode very frequently. Probably about 2 times a weeek. This
is a major annoyance since we have to restart SQL every time this
error comes up. Sometimes we can get into Enterprise Manager and view
that a spid is blocking another spid from doing it's work. Sometimes
we unable to view the spid and Enterprise Manager locks up. It's very
frustrating and wonder if anybody else has came across with their
servers?
Thanks,
JKThere are a couple of Kbase articles on Firehose mode :-
http://support.microsoft.com/default.aspx?scid=kb;en-us;286199
and 237398
--
HTH
Ryan Waight, MCDBA, MCSE
"Josh King" <joshk@.geoaccess.com> wrote in message
news:945a5f59.0310160714.a6cfe8@.posting.google.com...
> Over the last two months our SQL 2000 Server has been going into
> firehose mode very frequently. Probably about 2 times a weeek. This
> is a major annoyance since we have to restart SQL every time this
> error comes up. Sometimes we can get into Enterprise Manager and view
> that a spid is blocking another spid from doing it's work. Sometimes
> we unable to view the spid and Enterprise Manager locks up. It's very
> frustrating and wonder if anybody else has came across with their
> servers?
> Thanks,
> JK