Adam_Smasher (3/7/2013)
So, SPID4 is reporting the problem, not necessarily the cause of the problem?
Correct.
The slow IOs is telling you that in the last hour, there were x number of IO operations that took over 15 seconds to complete. Since IO operations should be measured in the ms, that's a slight problem. There's nothing in the message that can suggest which processes had slow IOs, just which file.
Am I correct in assuming that because of the 'S' in the SPID that SPID 12 'CHECKPOINT' would be reported as '12S'?
If the checkpoint had reason to write into the error log, the source column would be spid12s
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability