此后，你可以查看数据库的例行日志，每隔一段时间，数据库都会检查死锁，日志文本如下所示：

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]  下一页