FIX: Error 823 or 8966 Reported by SQL Server with Insufficient System Resources (274310)

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.