847

Product

Name

Event ID

847

Event Source

MSSQLSERVER

Component

SQLEngine

Symbolic

Name

N/A

Message Text

Time-out occurred while waiting for latch: class ‘%ls’, id %p, type %d, Task 0x%p : %d,

waittime %d, flags 0x%I64x, owning task 0x%p. 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