Time out occurred while waiting for buffer latch — type %d, bp %p, page %d:%d, stat %#x, database id: %d, allocation unit id: %I64d%ls, task 0x%p : %d, waittime %d, flags 0x%I64x, owning task 0x%p. Continuing to wait.

Details
Product: SQL Server
Event ID: 844
Source: MSSQLServer
Version: 9.0
Component: SQLEngine
Symbolic Name: BUFLATCH_TIMEOUT_CONTINUE
Message: Time out occurred while waiting for buffer latch — type %d, bp %p, page %d:%d, stat %#x, database id: %d, allocation unit id: %I64d%ls, task 0x%p : %d, waittime %d, flags 0x%I64x, owning task 0x%p. Continuing to wait.
   
Explanation

A process is waiting to acquire a latch. This problem can be caused by an I/O operation taking too long to complete. Typically this type of error is the result of other tasks blocking system processes. In some instances, this error may be the result of hardware failure.

   
User Action

Try the following to prevent this error from occurring:

Reduce workload.

Check for associated I/O failures in error log or event log. I/O failures typically point to a disk malfunction.

Check the error log for non-yielding tasks and other critical errors.

If critical errors such as asserts frequently occur, resolve these problems.

If the error persists, contact Microsoft Customer Service and Support.

Related:

Leave a Reply