846

Product

Name

Event ID

846

Event Source

MSSQLSERVER

Component

SQLEngine

Symbolic

Name

N/A

Message

Text

A 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. Not continuing to wait.

A computer might stop responding, or a time-out or some other disruption of regular

operations might occur at the same time that SQL Server writes buffer latch errors to the SQL

Server error log.

If the stat field in the message has the value of 0x04 on, SQL Server is waiting for an I/O

operation. You may also receive message

MSSQLSERVER_833

in the SQL Server error log.

If the stat field in the message has the value 0x04 off, there is heavy contention for a page. If

the object is a data page, this can be caused by inefficient code design. If the page is nondata,

the error might be caused by server bottlenecks, such as insufficient hardware resources.

To work around this problem, depending on your environment, one or more of the following

steps might reduce or eliminate the error messages:

ﾉ

Expand table