MSSQLSERVER_845
SQL Server 2005
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.
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 Product Service and Support.
