MSSQLSERVER_845

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

845

Event Source

MSSQLSERVER

Component

SQLEngine

Symbolic Name

BUFLATCH_TIMEOUT

Message Text

Time-out occurred while waiting for buffer latch type %d for page %S_PGID, database ID %d.

Explanation

A process was waiting to acquire a latch, but the process waited until the time limit expired and failed to acquire one. This can occur if an I/O operation takes too long to complete, usually as a result of other tasks blocking system processes. In some instances, this error may be the result of hardware failure.

User Action

Performing the following tasks may prevent this error:

  • Reduce the workload.

  • Verify whether there are associated I/O failures in the error log or event log. I/O failures are typically caused by disk malfunction.

  • Check 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.