none
sqlserver 2005难题? RRS feed

  • 问题

  • 各位好:
    现在sqlserver报错如下:

    SQL Server has encountered 1 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [F:\Microsoft SQL Server\MSSQL.1\MSSQL\Data\kk.mdf] in database [kk] (9).  The OS file handle is 0x0000095C.  The offset of the latest long I/O is: 0x00000acf284000

    SQL Server has encountered 1 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [F:\Microsoft SQL Server\MSSQL.1\MSSQL\Data\kk.mdf] in database [kk] (9).  The OS file handle is 0x0000095C.  The offset of the latest long I/O is: 0x00000cd4f9a000

    SQL Server has encountered 1 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [F:\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\tempdb.mdf] in database [tempdb] (2).  The OS file handle is 0x000006C4.  The offset of the latest long I/O is: 0x0000002098e000

    SQL Server has encountered 1 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [F:\Microsoft SQL Server\MSSQL.1\MSSQL\Data\kk.ldf] in database [kk] (9).  The OS file handle is 0x000009D4.  The offset of the latest long I/O is: 0x0000002ff40000

    SQL Server has encountered 1 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [F:\Microsoft SQL Server\MSSQL.1\MSSQL\Data\distribution.LDF] in database [distribution] (8).  The OS file handle is 0x000009C4.  The offset of the latest long I/O is: 0x00000002a2a400

    SQL Server has encountered 1 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [F:\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\templog.ldf] in database [tempdb] (2).  The OS file handle is 0x000006BC.  The offset of the latest long I/O is: 0x0000005fdcd000

    SQL Server has encountered 34 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [F:\Microsoft SQL Server\MSSQL.1\MSSQL\Data\kk.mdf] in database [kk] (9).  The OS file handle is 0x0000095C.  The offset of the latest long I/O is: 0x00000c197a0000


    SQL Server has encountered 145 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [F:\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\tempdb.mdf] in database [tempdb] (2).  The OS file handle is 0x000006C4.  The offset of the latest long I/O is: 0x00000039590000

    SQL Server has encountered 3 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [F:\Microsoft SQL Server\MSSQL.1\MSSQL\Data\kk.ldf] in database [kk] (9).  The OS file handle is 0x000009D4.  The offset of the latest long I/O is: 0x00000003470000

    SQL Server has encountered 2 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [F:\Microsoft SQL Server\MSSQL.1\MSSQL\Data\distribution.LDF] in database [distribution] (8).  The OS file handle is 0x000009C4.  The offset of the latest long I/O is: 0x00000009166200

    看起来是IO不够,如果对kk几个只有mdf的数据库添加多个ndf文件会不会有所好转?
    还是有更好的办法?

    2010年3月4日 14:44

答案

全部回复