I'm having a problem on a SQL Server that eventually stop responding. I'm wondering if you're familiar with it.
When this occurs I check the logs/event viewer and get tons of this messages:
Error: 17883, Severity: 1, State: 0
Process 86:0 (340) UMS Context 0x05DD2608 appears to be non-yielding on Scheduler 0.
I have postSP4 SQL patch level:
Microsoft SQL Server 2000 - 8.00.2187 (Intel X86)
Mar 9 2006 11:38:51
Copyright (c) 1988-2003 Microsoft Corporation
Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
The MS link for that error is http://support.microsoft.com/kb/891268, but is supposed to be solved with a patch for SP3 or included with SP4, then I'm supposed to already have it.
Have you seen this before?