April 10, 2006 at 3:13 pm
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,
April 12, 2006 at 2:23 am
I had the same problem. It finally ground down my IO to a halt. Read this KB and see if you have the same problem: http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B810885
My solution was to apply a hotfix at the time but I see now that when they released SP4 it is included there instead...
I hope this could help!
Hanslindgren
April 14, 2006 at 2:28 am
Hello.
I faced the same error and the cause of this error is I/O overhead. Try separating your backup jobs and keeping a comfotable difference between the jobs you have scheduled, this will reduce the chances of you getting this error.
Regards,
Deepak Uniyal
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply