MSSQLSERVER_844

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

Details

Product Name

SQL Server

Event ID

844

Event Source

MSSQLSERVER

Component

SQLEngine

Symbolic Name

BUFLATCH_TIMEOUT_CONTINUE

Message Text

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.