MSG 845, Buffer Latch type 2

[Scott Hughes]

I have been looking at Books Online and I'm trying to figure out how I can resolve this error.

MSG 845, Level 17, State 1
Time out occured while waiting for buffer latch type 2 for page.....


Thanks..

[Craig]

From Tecnet:
Severity Level 17
Message Text

Time out occurred while waiting for buffer latch type %d for page
%S_PGID, database ID %d, object ID %d, index ID %d.


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. Contact your system administrator. The system administrator should check the waittype, waittime, lastwaittype, and the waitresource columns of sysprocesses to see what activities each SPIDs is performing.
See Also
In This Volume
Errors 1 - 999
In Other Volumes
“sysprocesses” in Microsoft SQL Server Transact-SQL and Utilities Reference



------------
Scott Hughes at 11/1/99 9:51:43 AM

I have been looking at Books Online and I'm trying to figure out how I can resolve this error.

MSG 845, Level 17, State 1
Time out occured while waiting for buffer latch type 2 for page.....


Thanks..