|
|
Posted by kmounkhaty@yahoo.com on 04/11/06 00:11
Hi Guru,
Our HR sql 2000 production server is 800.760 built (SP3a) with 2GB of
RAM and 2 CPU hiper threading. This server is very low activity where
processor runs average 1-3 during the day. However, in the last two
months, I've seen the following message occurred a few times on this
server.
Error: 17883, Severity: 1, State: 0
The Scheduler 2 appears to be hung. SPID 0, ECID 0, UMS Context
0x0381F660.
I did extensive research and read both KB 815056 and 10885 but I could
not correlate these KBs in to my issue. The reason is, I don't think
our server is very busy to cause the checkpoint process to be delayed.
The database keeps growing only 5-10MB in a week and I allocated the
space during off hour.
What is the solution to fix this issue? Will I fix this issue by
applying the hotfix MS03-031?
Thanks so much,
Silaphet,
Navigation:
[Reply to this message]
|