日志内容如下
2009-09-02 14:14:08.90 spid18s * Edi: 4E97E530: 00142C70 00000000 4E97E77C 01091C87 623F6918 4E97E554
2009-09-02 14:14:08.90 spid18s * Esi: 00000000:
2009-09-02 14:14:08.90 spid18s * Eax: 4E97E414: 000042AC 00000000 00000000 7C80BEE7 00000000 7C95771B
2009-09-02 14:14:08.90 spid18s * Ebx: FFFFFFFF:
2009-09-02 14:14:08.90 spid18s * Ecx: 4E97EA84: 00000000 00010007 00000000 0090008E 00142C74 4E97E444
2009-09-02 14:14:08.90 spid18s * Edx: FFFFFFFF:
2009-09-02 14:14:08.90 spid18s * Eip: 7C80BEE7: 10C2C95E 01093D00 840FC000 00000095 F29DE950 9090FFFF
2009-09-02 14:14:08.90 spid18s * Ebp: 4E97E464: 4E97E4A8 02172CE4 000042AC 00000000 00000000 00000000
2009-09-02 14:14:08.90 spid18s * SegCs: 4E97001B: 00000000 00000000 00000000 00000000 00000000 00000000
2009-09-02 14:14:08.90 spid18s * EFlags: 00000246:
2009-09-02 14:14:08.90 spid18s * Esp: 4E97E410: 18F587B0 000042AC 00000000 00000000 7C80BEE7 00000000
2009-09-02 14:14:08.90 spid18s * SegSs: 78130023: 00000000 00000000 00000000 00000000 00000000 00000000
2009-09-02 14:14:08.90 spid18s * *******************************************************************************
2009-09-02 14:14:08.90 spid18s * -------------------------------------------------------------------------------
2009-09-02 14:14:08.90 spid18s * Short Stack Dump
2009-09-02 14:14:08.90 spid18s 7C80BEE7 Module(kernel32+0000BEE7)
2009-09-02 14:14:08.90 spid18s 02172CE4 Module(sqlservr+01172CE4)
2009-09-02 14:14:08.90 spid18s 02176BA0 Module(sqlservr+01176BA0)
2009-09-02 14:14:08.90 spid18s 0217674D Module(sqlservr+0117674D)
2009-09-02 14:14:08.90 spid18s 01597EA2 Module(sqlservr+00597EA2)
2009-09-02 14:14:08.90 spid18s 01095FFE Module(sqlservr+00095FFE)
2009-09-02 14:14:08.90 spid18s 02389FD6 Module(sqlservr+01389FD6)
2009-09-02 14:14:08.90 spid18s 0157808F Module(sqlservr+0057808F)
2009-09-02 14:14:08.90 spid18s 020DDCD8 Module(sqlservr+010DDCD8)
2009-09-02 14:14:08.90 spid18s 020DDDD1 Module(sqlservr+010DDDD1)
2009-09-02 14:14:08.90 spid18s 020DE03C Module(sqlservr+010DE03C)
2009-09-02 14:14:08.90 spid18s 020DD346 Module(sqlservr+010DD346)
2009-09-02 14:14:08.90 spid18s 010234D2 Module(sqlservr+000234D2)
2009-09-02 14:14:08.90 spid18s 010234C1 Module(sqlservr+000234C1)
2009-09-02 14:14:08.90 spid18s 01021880 Module(sqlservr+00021880)
2009-09-02 14:14:08.90 spid18s 010216E7 Module(sqlservr+000216E7)
2009-09-02 14:14:08.90 spid18s 010201DA Module(sqlservr+000201DA)
2009-09-02 14:14:08.90 spid18s 0100889F Module(sqlservr+0000889F)
2009-09-02 14:14:08.90 spid18s 010089C5 Module(sqlservr+000089C5)
2009-09-02 14:14:08.90 spid18s 010086E7 Module(sqlservr+000086E7)
2009-09-02 14:14:08.90 spid18s 010D764A Module(sqlservr+000D764A)
2009-09-02 14:14:08.90 spid18s 010D7B71 Module(sqlservr+000D7B71)
2009-09-02 14:14:08.90 spid18s 010D746E Module(sqlservr+000D746E)
2009-09-02 14:14:08.92 spid18s 010D83F0 Module(sqlservr+000D83F0)
2009-09-02 14:14:08.92 spid18s 781329BB Module(MSVCR80+000029BB)
2009-09-02 14:14:08.92 spid18s 78132A47 Module(MSVCR80+00002A47)目前现象:
应用已经停止,但是sql还是自动产生日志,且响应速度剧慢,且日志产生的速度很快。现象前的操作:由于应用系统每天的数据增长量很大,为了扩充存储空间,重新做raid。原来的是raid0,6块盘。现在是保留系统不变,对后4块盘重新做raid,做的是raid10.将原来的数据库做的是分离和附加的操作。附加是抱错,所以就没有附加日志,但是附加完成后数据可用,但是仍然有错误产生。错误如下:
错误: 605,严重性: 21,状态: 3。
Attempt to fetch logical page (1:3565792) in database 7 failed. It belongs to allocation unit 72057594161463296 not to 72057594317045760.为了解决此问题,对数据库所有的表索引重建。以上的问题解决后,就出现最上面的问题。日志量很大,响应速度很慢。应用不可用。
2009-09-02 14:14:08.90 spid18s * Edi: 4E97E530: 00142C70 00000000 4E97E77C 01091C87 623F6918 4E97E554
2009-09-02 14:14:08.90 spid18s * Esi: 00000000:
2009-09-02 14:14:08.90 spid18s * Eax: 4E97E414: 000042AC 00000000 00000000 7C80BEE7 00000000 7C95771B
2009-09-02 14:14:08.90 spid18s * Ebx: FFFFFFFF:
2009-09-02 14:14:08.90 spid18s * Ecx: 4E97EA84: 00000000 00010007 00000000 0090008E 00142C74 4E97E444
2009-09-02 14:14:08.90 spid18s * Edx: FFFFFFFF:
2009-09-02 14:14:08.90 spid18s * Eip: 7C80BEE7: 10C2C95E 01093D00 840FC000 00000095 F29DE950 9090FFFF
2009-09-02 14:14:08.90 spid18s * Ebp: 4E97E464: 4E97E4A8 02172CE4 000042AC 00000000 00000000 00000000
2009-09-02 14:14:08.90 spid18s * SegCs: 4E97001B: 00000000 00000000 00000000 00000000 00000000 00000000
2009-09-02 14:14:08.90 spid18s * EFlags: 00000246:
2009-09-02 14:14:08.90 spid18s * Esp: 4E97E410: 18F587B0 000042AC 00000000 00000000 7C80BEE7 00000000
2009-09-02 14:14:08.90 spid18s * SegSs: 78130023: 00000000 00000000 00000000 00000000 00000000 00000000
2009-09-02 14:14:08.90 spid18s * *******************************************************************************
2009-09-02 14:14:08.90 spid18s * -------------------------------------------------------------------------------
2009-09-02 14:14:08.90 spid18s * Short Stack Dump
2009-09-02 14:14:08.90 spid18s 7C80BEE7 Module(kernel32+0000BEE7)
2009-09-02 14:14:08.90 spid18s 02172CE4 Module(sqlservr+01172CE4)
2009-09-02 14:14:08.90 spid18s 02176BA0 Module(sqlservr+01176BA0)
2009-09-02 14:14:08.90 spid18s 0217674D Module(sqlservr+0117674D)
2009-09-02 14:14:08.90 spid18s 01597EA2 Module(sqlservr+00597EA2)
2009-09-02 14:14:08.90 spid18s 01095FFE Module(sqlservr+00095FFE)
2009-09-02 14:14:08.90 spid18s 02389FD6 Module(sqlservr+01389FD6)
2009-09-02 14:14:08.90 spid18s 0157808F Module(sqlservr+0057808F)
2009-09-02 14:14:08.90 spid18s 020DDCD8 Module(sqlservr+010DDCD8)
2009-09-02 14:14:08.90 spid18s 020DDDD1 Module(sqlservr+010DDDD1)
2009-09-02 14:14:08.90 spid18s 020DE03C Module(sqlservr+010DE03C)
2009-09-02 14:14:08.90 spid18s 020DD346 Module(sqlservr+010DD346)
2009-09-02 14:14:08.90 spid18s 010234D2 Module(sqlservr+000234D2)
2009-09-02 14:14:08.90 spid18s 010234C1 Module(sqlservr+000234C1)
2009-09-02 14:14:08.90 spid18s 01021880 Module(sqlservr+00021880)
2009-09-02 14:14:08.90 spid18s 010216E7 Module(sqlservr+000216E7)
2009-09-02 14:14:08.90 spid18s 010201DA Module(sqlservr+000201DA)
2009-09-02 14:14:08.90 spid18s 0100889F Module(sqlservr+0000889F)
2009-09-02 14:14:08.90 spid18s 010089C5 Module(sqlservr+000089C5)
2009-09-02 14:14:08.90 spid18s 010086E7 Module(sqlservr+000086E7)
2009-09-02 14:14:08.90 spid18s 010D764A Module(sqlservr+000D764A)
2009-09-02 14:14:08.90 spid18s 010D7B71 Module(sqlservr+000D7B71)
2009-09-02 14:14:08.90 spid18s 010D746E Module(sqlservr+000D746E)
2009-09-02 14:14:08.92 spid18s 010D83F0 Module(sqlservr+000D83F0)
2009-09-02 14:14:08.92 spid18s 781329BB Module(MSVCR80+000029BB)
2009-09-02 14:14:08.92 spid18s 78132A47 Module(MSVCR80+00002A47)目前现象:
应用已经停止,但是sql还是自动产生日志,且响应速度剧慢,且日志产生的速度很快。现象前的操作:由于应用系统每天的数据增长量很大,为了扩充存储空间,重新做raid。原来的是raid0,6块盘。现在是保留系统不变,对后4块盘重新做raid,做的是raid10.将原来的数据库做的是分离和附加的操作。附加是抱错,所以就没有附加日志,但是附加完成后数据可用,但是仍然有错误产生。错误如下:
错误: 605,严重性: 21,状态: 3。
Attempt to fetch logical page (1:3565792) in database 7 failed. It belongs to allocation unit 72057594161463296 not to 72057594317045760.为了解决此问题,对数据库所有的表索引重建。以上的问题解决后,就出现最上面的问题。日志量很大,响应速度很慢。应用不可用。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货