Topic: Error in tempdb: Time-out occurred while waiting for buffer latch type 3 for page...
The full test
Error: Time-out occurred while waiting for buffer latch type 3 for page (11:485280), database ID 2.
The version of Microsoft SQL Server 2016 (SP1) (KB3182545) - 13.0.4001.0 (X64) Oct 28 2016 6:17:30 PM Copyright (c) Standard Edition Microsoft Corporation (64-bit) on Windows Server 2012 R2 Standard 6.3 <X64> (Build 9600:)
Checkdb produces 0 errors.
The error came up the second time for couple of weeks.
As it tempDb, and a time interval, between the previous error. The server a minimum of 1 times was overloaded. And also tempDb was rehay on other disk (that is a question to "" the disk as though cannot be).
In a broad gull sql
For 4 minutes of time about 12 similar errors. With buffer latch type 3 and buffer latch type 4. All concern to tempdb
And for 6 minutes of the order 20 type messages
Process 0:0:0 (0xad8) Worker 0x00000049EC400160 appears to be non-yielding on Scheduler 17. Thread creation time: 13150541410851. Approx Thread CPU Used: kernel 0 ms, user 124703 ms. Process Utilization 60 %. System Idle 38 %. Interval: 130882 ms.
The previous time. Met a mention that in 2005 versions it can be the multithreading conflict for disk resources and the recommendation to increase an amount of files in basis. In tempdb now consists of 12 files (on 3 independent IO)
Where further to dig to search for the reason?