Error 844

Troubleshooting SQL Server

Troubleshooting

Error 844

Severity Level 10
Message Text

Time out occurred while waiting for buffer latch type %d, bp %#x, page %S_PGID, stat %#x, object ID %d:%d:%d, waittime %d. Continuing to wait.

Explanation

When under a heavy stress load or high I/O conditions, your system may produce this message.

Action

This message can usually be ignored. However, if you receive repeated messages where the wait time increases, it may indicate an internal server problem, in which case, contact your system administrator. The system administrator should check the waittype, waittime, lastwaittype, and the waitresource columns of sysprocesses to see what activities each SPID is performing.

See Also

Errors 1 - 999

sysprocesses