MSSQLSERVER_845

Details

Product Name

SQL Server

Product Version

10.50

Product Build Number

10.50.0000.00

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 Product Service and Support.