SQL Server tempdb on SSD showing IO

by G Devine   Last Updated May 03, 2018 17:06 PM

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?



Related Questions


Tempdb approaching disk max, ok to wait?

Updated August 03, 2017 20:06 PM

Chaning tempdb settings on production database

Updated May 15, 2015 21:02 PM

Error: Invalid object for global temporary table

Updated August 27, 2016 08:04 AM