日期:2014-05-18  浏览次数:20475 次

请教: Sql server2005数据库间断的offline的问题
我的系统是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的操作进行实时监控====它会属住要监控的数据库部分资源,导致的,所以去掉他对数据库的监控就可以了
------解决方案--------------------
没遇到过,帮顶~