Microsoft KB Archive/274310

= FIX: Error 823 or 8966 Reported by SQL Server with Insufficient System Resources =

Article ID: 274310

Article Last Modified on 3/14/2006

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q274310



BUG #: 49541(SQLBUG_70)



SYMPTOMS
Microsoft Windows I/O errors may cause the following 823 or 8966 error messages to appear in the SQL Server error log:

Msg 823, Level 24, State 1:

I/O error 1453(Insufficient quota to complete the requested service.) detected during read of %s.

Msg 8966, Level 16, State 2:

Could not read and latch page (%d:%d) with latch type %s. 1453(Insufficient quota to complete the requested service.) failed.

-or-

Msg 823, Level 24, State 1: I/O error 1450(Insufficient system resources exist to complete the requested service.) detected during read of %s.

Msg 8966, Level 16, State 2: Could not read and latch page (%d:%d) with latch type %s. 1450(Insufficient system resources exist to complete the requested service.) failed.



CAUSE
When Windows I/O operations fail due to insufficient system resources or because of insufficient working set quota, SQL Server reports error 823 or error 8966 without attempting a retry. These conditions can be reported by the operating system on a normal system, due to the current workload at that instance. If you retry the operation later it might work because of changing loads and system resources availability.



STATUS
Microsoft has confirmed this to be a problem in SQL Server 7.0. This problem has been corrected in U.S. Service Pack 3 for Microsoft SQL Server 7.0. For more information, click the following article number to view the article in the Microsoft Knowledge Base:

274799 INF: How to Obtain Service Pack 3 for Microsoft SQL Server 7.0 and Microsoft Data Engine (MSDE) 1.0

For more information, contact your primary support provider.

Keywords: kbbug kbfix kbqfe KB274310

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.