SQL Server has encountered 1 occurrence of I/O Requests taking longer than 15 seconds

  • Hello guys,

    during day shift was problem on database, I have night shift this week so I dont know directly were was problem.

    According to info what I received, database showed still timeouts. And it was needed manually change to another node.

    in sql log I found in 11:45:11 and this is also in application log

    Sourcespid10s

    Message

    SQL Server has encountered 1 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [G:\USERDB\MCS_MESDB_1.ldf] in database [MCS_MESDB] (8). The OS file handle is 0x000000000000173C. The offset of the latest long I/O is: 0x000003fe34b000

    in system log I found in 11:46:50

    Reset to device, \Device\RaidPort2, was issued.

    thanks for advices

  • First thought would be the SAN, check out the storage network / fibre network, don't think this is a software related error.

    😎

  • Eirikur Eiriksson (10/8/2014)


    First thought would be the SAN, check out the storage network / fibre network, don't think this is a software related error.

    😎

    thank you, I found few topics about it, so I told to storage admin..:)

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply