Article ID: 810885 - View products that this article applies to.
BUG #: 363118 (SHILOH_BUGS)
You may receive the following error message:
You may receive this error message when you use any of the following on a high-end disk subsystem:
Error: 17883, Severity: 1, State: 0
The Scheduler 0 appears to be hung. SPID 53, ECID 1, UMS Context 0x04069D90
(http://support.microsoft.com/kb/319892/ )New concurrency and scheduling diagnostics added to SQL Server
Note This article discusses one possible cause for the 17883 error message. The workaround that is discussed in this article is only for the cause that is discussed in this article.
One of the possible causes is an unyielding thread.
When you perform any of the operations mentioned in the "Symptoms" sections, SQL Server issues a WriteFile WinAPI call, and then checks the result of the write request. If the operation returns pending, SQL Server appropriately yields that SQL Scheduler.
However, when you perform any of the operations on a large file that physically resides on a high-end disk subsystem, SQL Server issues a write operation and the disk subsystem completes the write operation immediately. Because the disk subsystem completes the write operation so quickly, SQL Server continues to issue new write requests until the whole file operation completes, thereby creating an unyielding thread on the SQL Scheduler. When the SQL Scheduler does not yield for more than 60 seconds, SQL Server generates the 17883 error message.
For the problem to occur, the file size must be so large that even with write operations completing extremely fast, SQL Server continues to post the write requests for more than 60 seconds and has still not reached the end of the operation.
There is no direct way to avoid this problem. However, you can schedule all the file operations that are mentioned in the "Symptoms" section to occur during non-peak hours so that the server is not affected by a SQL Server scheduler that has stopped responding until a file operation completes.
Service pack informationTo resolve this problem, obtain the latest service pack for SQL Server 2000. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/290211/ )How to obtain the latest SQL Server 2000 service pack
Microsoft has confirmed that this is a bug in the Microsoft products that are listed in the "Applies to" section. This bug was corrected in SQL Server 2000 Service Pack 4.
Article ID: 810885 - Last Review: July 20, 2005 - Revision: 7.0