Re: Hung SQL Server

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Sebastian K. Zaklada (szaklada-dont-like-spam_at_skilledsoftware.com)
Date: 02/25/04 

Date: Wed, 25 Feb 2004 15:24:19 +0100

> A process froze up a production server, and when I
> rebooted the machine the error message I received was:
>
> 2004-02-25 07:47:55.85 server Error: 17883, Severity:
> 1, State: 0
> 2004-02-25 07:47:55.85 server Process 0:0 (66c) UMS
> Context 0x11C6AF28 appears to be non-yielding on Scheduler
> 0.
>
> Can anyone tell me what might have caused such a problem?

These messages indicate a single UMS scheduler has experience a yield
problem. The health monitoring has detected what appears to be a scheduler
with a worker thread that is not allowing other workers to progress, and the
scheduler is being flagged as non-responsive. A scheduler that has stopped
responding is generally a bug with the SQL Server product or an external
component (XProc, COM object, and so on).

The following are examples of known 17883 conditions. Make sure that you
search the Microsoft Knowledge Base for related articles. If your system
requires an updated patch, apply it accordingly.

FIX: The checkpoint process can stall database activity

http://support.microsoft.com/default.aspx?scid=kb;EN-US;815056

BUG: High-end Disk Subsystems May Experience Error 17883

http://support.microsoft.com/default.aspx?scid=kb;EN-US;810885

If you cannot determine the root cause immediately, consult the error log
for problems and engage in extended support efforts.

When a scheduler is not properly responding, it can reduce overall
concurrency for SQL Server. SQL Server can also appear to be stalled or it
might stop responding.

Please check this KB article for more info:

INF: New Concurrency and Scheduling Diagnostics Added to SQL Server
http://support.microsoft.com/default.aspx?kbid=319892

sincerely, 

--
Sebastian K. Zaklada
Skilled Software
http://www.skilledsoftware.com
This posting is provided "AS IS" with no warranties, and confers no rights.

Relevant Pages

  • Re: Connection to SQL Server 2005 lost
    ... the error message reported is a little bit different, ... Hitchhiker’s Guide to Visual Studio and SQL Server ... Q. Must I upgrade clients to use SQL Native Client as soon as I upgrade my ...
    (microsoft.public.sqlserver.connect)
  • Re: BizTalk Orchestration SQL Adapter
    ... My short answer would be to use DTS intsead of BizTalk Server for this type ... > mirror image of SQL Server tables. ... > scheduler invoke BizTalk, scheduler writes a dummy file to a folder at ...
    (microsoft.public.biztalk.general)
  • Re: Error while connecting to SQL 2005 from ASP.Net 2.0
    ... When connecting to SQL Server ... Server does not allow remote connections. ... ASP.NET webservice to the SQL Server 2005 box. ... If so, as the error message indicate, the SQL ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Cant connect to SQL Server 2008
    ... The error occurs on opening a connection. ... I can connect to SQL Server 2008 using sqlcmd from the same machine which ... VS solution cannot connect to the SQL Server. ... Error Message: ...
    (microsoft.public.sqlserver.connect)
  • Re: CUPS Server Error
    ... # This is the CUPS configuration file. ... Server Identity ... determines whether the scheduler will allow new printers ... whether or not to use "short" names for remote printers ...
    (Debian-User)