We recently separated out our tempdb files to a new SSD and have started seeing
5348 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\tempdb\tempdb4.ndf] .
We have multiple occurrences of this error. We did not see the errors when tempdb was back on its original RAID 5 home. I followed your tutorial on SQLIO and I think the SSD should be much faster when doing 8kb random read/writes, than the previous RAID 5 disks, so why are we seeing these errors. Also, by way of more proof that not all is well, the batch file we run overnight, when these errors occur, is taking 7 hours instead of 6.25 hours, on the old disks. is there a magic switch that we need to configure? The disks sit in a directly attached array. The RAID5 for data, RAID 10 for logs and a spare slot that we used for the SSD. The RAIS 5 and SSD are formatted for 64kb block size. the log is incorrectly set to 4KB block size (I know – will fix when I get a chance).
SQL server 2012 is patched till sp3
Do you have any idea what could be causing all these IO errors getting reported by SQL Server?