Error:

Error in procedure dbo.uspXXXX Error in procedure dbo.uspXXXX Time-out occurred while waiting for buffer latch type 3 for page (6:784), database ID 2. [SQLSTATE 42000] (Error 50000)  Process Failed, ERROR CODE:0 [SQLSTATE 42000] (Error 50000).  The step failed.

Cause:

IO requests of SQL Server cannot be met by the hardware. This becomes pronounced when there is a heavy workload on the system. For example, if you’re running a batch processing job, full backups and index maintenance job , all in parallel – then there is a greater demand on IO channels.

Also check which database the IO bottleneck is happening. DB_ID=2 is the TempDB. IO bottleneck with TempDB.

SELECT DB_ID();  -- 2

Sources:

https://www.sqlserver-dba.com/2016/02/troubleshooting-msg-845-time-out-occurred-while-waiting-for-buffer-latch-type-3.html

Last modified: October 22, 2021

Author

Comments

Write a Reply or Comment