|
此后，你可以查看数据库的例行日志，每隔一段时间，数据库都会检查死锁，日志文本如下所示：
2004-01-16 18:34:38.50 spid4 ----------------------------------
2004-01-16 18:34:38.50 spid4 Starting deadlock search 1976
2004-01-16 18:34:38.50 spid4 Target Resource Owner:
2004-01-16 18:34:38.50 spid4 ResType:LockOwner Stype:''''OR'''' Mode: U SPID:55 ECID:0 Ec:(0xAA577570) Value:0x4c25cba0
2004-01-16 18:34:38.50 spid4 Node:1 ResType:LockOwner Stype:''''OR'''' Mode: U SPID:55 ECID:0 Ec:(0xAA577570) Value:0x4c25cba0
2004-01-16 18:34:38.50 spid4 Node:2 ResType:LockOwner Stype:''''OR'''' Mode: U SPID:71 ECID:0 Ec:(0xABF07570) Value:0x9bd0ba00
2004-01-16 18:34:38.50 spid4
2004-01-16 18:34:38.50 spid4 -- next branch --
2004-01-16 18:34:38.50 spid4 Node:2 ResType:LockOwner Stype:''''OR'''' Mode: U SPID:71 ECID:0 Ec:(0xABF07570) Value:0x9bd0ba00
2004-01-16 18:34:38.50 spid4
2004-01-16 18:34:38.50 spid4
2004-01-16 18:34:38.50 spid4 End deadlock search 1976 ... a deadlock was not found.
2004-01-16 18:34:38.50 spid4 ---------------------------------- 以下实际检测到死锁的日志输出，来自于一份非常棒的讲义“Log Shipping in SQL Server 2000.ppt”，作者是Ron Talmage：
Deadlock encountered .... Printing deadlock information Wait-for graph Node:1 KEY: 7:1977058079:1 (f600d547433a) CleanCnt:1 Mode: X Flags: 0x0 Grant List:: Owner:0x19090e20 Mode: X Flg:0x0 Ref:0 Life:02000000 SPID:54 ECID:0 SPID: 54 ECID: 0 Statement Type: SELECT Line #: 1 Input Buf: Language Event: Select * From Authors Requested By: ResType:LockOwner Stype:''''OR'''' Mode: S SPID:53 ECID:0 Ec:(0x19c5d530) Value:0x19090dc0 Cost:(0/114) Node:2 KEY: 7:1977058079:1 (f5006f164aa3) CleanCnt:1 Mode: X Flags: 0x0 Grant List:: Owner:0x19091000 Mode: X Flg:0x0 Ref:0 Life:02000000 SPID:53 ECID:0 SPID: 53 ECID: 0 Statement Type: SELECT Line #: 1 Input Buf: Language Event: Select * From Authors 上一页 [1] [2] [3] [4] 下一页
[其他]手工升级ACCESS到SQLSERVER方法详解 [Web开发]asp+sqlserver 分页方法（不用存储过程）
[办公软件]在sybase中插入图片、PDF、文本文件 [办公软件]安装Sybase ASE
[办公软件]linux指令大全(完整篇) [办公软件]Linux新手入门常用命令大全
[办公软件]在RedHat Linux 9里安装gaim0.80 [办公软件]浅谈Linux 下Java 1.5 汉字方块问题解决方法
[办公软件]Linux程序员必读：中文化与GB18030标准 [办公软件]linux指令大全
| 
注：本站部分文章源于互联网，版权归原作者所有！如有侵权，请原作者与本站联系，本站将立即删除！ 本站文章除特别注明外均可转载，但需注明出处！ [MinTao学以致用网] 
