Post reply

Error:sqlserver errorLog

  • January 29, 2009 at 6:12 am

    #129844

    Hi,

    I am working in SS2K standard and WIN2003 standard and I got below error message in sql error log

    8.00.2050

    SQL Server has encountered 6 occurrence(s) of IO requests taking longer than 15 seconds to complete on file [e:\mssql\datafiles\MSSQL\data\stdfqads_Data.MDF] in database [stdfqads] (26). The OS file handle is 0x0000062C. The offset of the latest long IO is: 0x00000151ba0000

    We are using RAID-5 disk and now free space 9GB (But in percentage 8%)

    Ram-3GB and my server using 1.58 GB

    current size of stdfqads_Data.MDF 7GB Growth 100Mb U.G

    May I know the Reason why this error coming daily Help Me...

    Muthukkumaran Kaliyamoorthy
    https://www.sqlserverblogforum.com/

  • January 29, 2009 at 8:17 am

    #934717

    Try the following link.

    http://support.microsoft.com/kb/897284

  • January 30, 2009 at 5:45 am

    #935438

    aali_online,

    Thanks for ur link.

    I checked in my server everything is fine but onlything is work load is high in that particular database and some of non clustered index heavily fragmented (Extent Scan Fragmentation is very high).I don't know about hardware side any issue there or not.

    Thanks,

    Muthuuu.

    Muthukkumaran Kaliyamoorthy
    https://www.sqlserverblogforum.com/

  • January 30, 2009 at 8:14 am

    #935576

    At the very least, rebuild the statistics on that database. Better yet, rebuild all indices on it. That should help the situation.

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

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