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