积极答复者
sqlserver 2005难题?

问题
-
各位好:
现在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: 0x00000acf284000SQL 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: 0x00000039590000SQL 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文件会不会有所好转?
还是有更好的办法?
答案
-
That means slow disk i/o, check if any issue on disk or disk channel.
- 已标记为答案 Hong-Gang Chen - MSFTModerator 2010年3月9日 10:01
全部回复
-
That means slow disk i/o, check if any issue on disk or disk channel.
- 已标记为答案 Hong-Gang Chen - MSFTModerator 2010年3月9日 10:01