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.


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


Last modified: October 22, 2021



Write a Reply or Comment