SQL Server Performance

Test server is very slow from few days

Discussion in 'Performance Tuning for Hardware Configurations' started by haridba, May 29, 2007.

  1. haridba New Member

    Hi 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 />
  2. satya Moderator

    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.

Share This Page