Post reply

I/O request taking longer than 15 second

  • July 10, 2014 at 2:23 am

    #288514

    Hi all

    I am facing this I/O issues at my prod db. After doing a little research, this issue is due to storage I/O. But i am thinking to add another datafiles for my temp database. What do u think ?

    07/07/2014 07:05:01,spid7s,Unknown,SQL Server has encountered 14 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [F:\MSSQL11.CWSAPPS\MSSQL\Data\CGOPRDKCHS.mdf] in database [CGOPRDKCHS] (7). The OS file handle is 0x0000000000000A8C. The offset of the latest long I/O is: 0x000000bb870000

    07/07/2014 06:59:48,spid7s,Unknown,SQL Server has encountered 140 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [F:\MSSQL11.CWSAPPS\MSSQL\Data\CGOPRDKCHS.mdf:MSSQL_DBCC9] in database [CGOPRDKCHS] (9). The OS file handle is 0x000000000000251C. The offset of the latest long I/O is: 0x0000023b5d0000

    07/07/2014 06:59:48,spid7s,Unknown,SQL Server has encountered 10 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [F:\MSSQL11.CWSAPPS\MSSQL\Data\CGOPRDKCHS.mdf] in database [CGOPRDKCHS] (7). The OS file handle is 0x0000000000000A8C. The offset of the latest long I/O is: 0x000000b1a3c000

    07/07/2014 06:59:48,spid7s,Unknown,SQL Server has encountered 4 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [F:\MSSQL11.CWSAPPS\MSSQL\Data\tempdb.mdf] in database [tempdb] (2). The OS file handle is 0x0000000000000AE0. The offset of the latest long I/O is: 0x00000007f90000

  • July 10, 2014 at 4:54 am

    #1728316

    I don't think that will help. Most of those errors are not from tempdb, they're from another database. And, everything is from drive F. It looks like that drive is either completely overwhelmed, or there's something wrong with the hardware, or there's something wrong with the disk configurations. It's most likely something with the hardware or the disk configurations.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • July 10, 2014 at 9:50 am

    #1728440

    Adding files onto a disk subsystem that is already overwhelmed can only make things WORSE!!! You will be INCREASING disk seeks and head thrashing.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

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

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