SQL Server Performance Forum – Threads Archive
Test server is very slow from few daysHi all<br /><br />quite recently, One of our Test server is very slow<br /><br />I got the following error in SQL Log <br /><br />2007-05-27 16:10:41.53 spid79 SQL Server has encountered 4 occurrence(s) of IO requests taking longer than 15 seconds to complete on file [D:SQLSRVSQLDATATESTDBTESTDB13.MDF] in database [TESTDB] (<img src=’/community/emoticons/emotion-11.gif’ alt=’8)’ />. The OS file handle is 0x000004D4. The offset of the latest long IO is: 0x000000eb0a0000<br /><br />What does the above info inidcates, how can i fix the server performance..<br /><br />Please suggest me..<br /><br />Thanks<br />
That is an informational message not an error, it is nothing but indicates that an IO operation has been issued, and it has taken over 15 seconds for that operation to return through the IO subsystem. Have a look at this support article for troubleshooting steps: KBAhttp://support.microsoft.com/kb/897284/en-us Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.