I am seeing SQL Server has encountered 649 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [d:datatempdb.mdf] in database [tempdb] (2). The OS file handle is 0x00000000000007EC. The offset of the latest long I/O is: 0x0000014f5e0000
events in the event log very frequently. If anyone has any clue for this kind of events, please let me know.
View Complete Post