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.