The Scheduler 0 appears to be hung 1

[darkwing75]

Hi, has anybody encountered this error? It appears in my SQL Server Logs, how do you look for Scheduler 0? I looked in the SQL Jobs, but could not find it
Error: 17883, Severity: 1, State: 0
The Scheduler 0 appears to be hung. SPID 0, ECID 0, UMS Context 0x03B78900.

 

[camy123]

The checkpoint process forces SQL Server to write all the dirty pages to disk. Systems that can support and maintain fast I/O rates, and that do not result in pending I/O attempts, can trigger a condition whereby the checkpoint process does not have to delay to wait for I/O processes to complete. When the checkpoint does not correctly yield, it can affect overall database activity and performance. This may result in reduced transaction and batch submittal rates.


go to the following link and download the patch

http://support.microsoft.com/default.aspx?kbid=821277

cheers
kam.

 

[camy123]

p.s yes i had the ame problem ages back.. and it was resolved as i explain above..
good luck let me know how u get on.

 

[darkwing75]

Hi! Thanks for the reply, I looked at the link, and it seems to refer to a Security patch MS03-031, it doesn't seem to refer to this particular problem, is this the correct patch? Thanks!

 

[camy123]

Yes mate it is.. it wil correct your problem and should have no side affects.. load it on a test/dev server i alwyas recomened every thing to eb done on Dev before prod.
let me know how it goes.
cheers mate

 

[camy123]

microsoft being microsoft have budled this fix with a securioty patch that all it is..

 

[mrdenny]

I to installed this patch, to fix the same issue. It should do the trick for you.

Denny

--Anything is possible. All it takes is a little research. (Me)