SQL error about I/O

  • We have a SQL server which is a virtual server that hosts the VDI for our district.

    VDI is a software that deploys and manages student virtual desk tops.

    At weekends there is some scheudled recomposition of virtual destopts to fail.

    I checked the log, there is a serverity 20 happens around the time.

    and prior to that, there is an error message:

    SQL Server has encountered 2 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [F:\MSSQL\Logs\Rapport4.ldf] in database [RapportDB] (7). The OS file handle is 0x0000000000000534. The offset of the latest long I/O is: 0x00000000068e00

    What does this mean?

    Thanks

  • It means that you have an I/O issue. This could be caused by a very small (or very large) growth setting on that particular log file and that it is growing frequently or that you have a performance issue on your storage. This could be anywhere from the local HBA to disk configuration and perf on the SAN (I'm guessing SAN from your question).



    Shamless self promotion - read my blog http://sirsql.net

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

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