Re: The scheduler 0 appears to be hung message in error log

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 08/23/04 

Date: Mon, 23 Aug 2004 16:15:04 -0400

If you search the KB for "scheduler 0 hung" there are several hits and this
seems to be the most obvious:

http://support.microsoft.com/default.aspx?scid=kb;en-us;810885&Product=sql2k 

-- 
Andrew J. Kelly  SQL MVP
"Rob" <Rob@discussions.microsoft.com> wrote in message
news:47b901c4893b$6d306360$a301280a@phx.gbl...
> I'm seeing a strange error in the SQLServer error log:
>
> The Scheduler 0 appears to be hung. PSS 0x00000000, EC
> 0x00000000, UMS Context 0x01051F70
>
> I'm also seeing this error as well:
>
> Point record not found for PPID SCOTT:02010903 ADDR 6.
>
> I'm not sure what they mean...  There isn't an object in
> the database called "SCOTT"...
>
> Any help would be much appreciated!
> Thanks.

Relevant Pages

  • Re: Jobs dont run and are stuck with request pending
    ... > SQL Agent log when you run out of job worker threads. ... > - sometimes it's on emailing results and mail gets hung up. ... If the scheduler gets ... >>The job history does not show anything out of the ordinary. ...
    (microsoft.public.sqlserver.server)
  • Re: The Scheduler 2 appears to be hung
    ... It's not the process that's hung - it's the Scheduler. ... SQL Server has its own internal scheduler that takes over from the os ... About 1 out of 40 we have to restart SQL Server. ...
    (microsoft.public.sqlserver.server)
  • Re: Weird parallel stored procedures execution problem
    ... Have you run profiler with errors and assertions events turned on? ... Are they just blocked or hung, ... Andrew J. Kelly SQL MVP ... are stopping suddenly without any error message. ...
    (microsoft.public.sqlserver.programming)
  • Re: 2.6.15-rc5-mm2 :-)
    ... On Monday 12 December 2005 03:12, Maciej Soltysiak wrote: ... me bow before Con and Andrew;-) ... > on his staircase scheduler. ...
    (Linux-Kernel)
  • The scheduler 0 appears to be hung message in error log
    ... The Scheduler 0 appears to be hung. ... PSS 0x00000000, EC ... 0x00000000, UMS Context 0x01051F70 ...
    (microsoft.public.sqlserver.server)