我的系统是Windows 2003 service pack 1. 数据库是SQLServer 2005 service pack 2. 另外安装了LogExplorer 4.1对sql server的操作进行实时监控.
数据库经常会不间断的offline,online,从日志分析好像有死锁的情况.但卸载掉LogExplorer 4.1又不会这样,谁遇到过类似的问题,请帮忙分析原因?
非常感谢!
部分sql的log:
SQL Server has encountered 233 occurrence(s) of I/O
requests taking longer than 15 seconds to complete on file
[S:\Data\dbE2EComb2_Data_redirect.MDF] in database [dbE2EComb2] (5).
The OS file handle is 0x0000089C. The offset of the latest long I/O is:
0x00000a40680000
SQL Server has encountered 501 occurrence(s) of I/O
requests taking longer than 15 seconds to complete on file
[S:\Data\dbE2EComb2_Data_redirect.MDF] in database [dbE2EComb2] (5).
The OS file handle is 0x0000089C. The offset of the latest long I/O is:
0x00000bfe9ac000
SQL Server has encountered 752 occurrence(s) of I/O
requests taking longer than 15 seconds to complete on file
[S:\Data\dbE2EComb2_Data_redirect.MDF] in database [dbE2EComb2] (5).
The OS file handle is 0x0000089C. The offset of the latest long I/O is:
0x00001c7ee40000
------解决方案--------------------
LogExplorer 4.1对sql server的操作进行实时监控====它会属住要监控的数据库部分资源,导致的,所以去掉他对数据库的监控就可以了
------解决方案--------------------
没遇到过,帮顶~