Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Deadlock Output Expand / Collapse
Author
Message
Posted Friday, August 24, 2012 2:16 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 5:52 PM
Points: 208, Visits: 1,020
Hello experts,
i enables trace flags 1222,1204,3226 to capture deadlock data, when i check in errorlog file i get an out like i pasted below but unable to understand and troubleshoot thigns infact looking multiple node in it very confusing please help to decode it.


2012-08-24 13:02:47.39 spid8s Deadlock encountered .... Printing deadlock information
2012-08-24 13:02:47.39 spid8s Wait-for graph
2012-08-24 13:02:47.39 spid8s
2012-08-24 13:02:47.39 spid8s Node:1

2012-08-24 13:02:47.39 spid8s Port: 0x000000022ACCB6C0 Xid Slot: 4, Wait Slot: 1, Task: 0x000000022B674508, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 1
2012-08-24 13:02:47.39 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:13 TaskProxy0x00000005441358F0) Value:0x2b674508 Cost20/0)
2012-08-24 13:02:47.39 spid8s SPID: 108 ECID: 13 Statement Type: SELECT Line #: 1
2012-08-24 13:02:47.39 spid8s Input Buf: No Event:
2012-08-24 13:02:47.39 spid8s
2012-08-24 13:02:47.39 spid8s Node:2

2012-08-24 13:02:47.39 spid8s Port: 0x000000022B1F8600 Xid Slot: 4, Wait Slot: 0, Task: 0x000000022BCB02C8, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0
2012-08-24 13:02:47.39 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:11 TaskProxy0x0000000544135830) Value:0x2bcb02c8 Cost0/10000)
2012-08-24 13:02:47.39 spid8s SPID: 108 ECID: 11 Statement Type: SELECT Line #: 1
2012-08-24 13:02:47.39 spid8s Input Buf: No Event:
2012-08-24 13:02:47.39 spid8s
2012-08-24 13:02:47.39 spid8s Node:3

2012-08-24 13:02:47.39 spid8s Port: 0x000000022B1F8D80 Xid Slot: 3, Wait Slot: 1, Task: 0x000000000A7A8748, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0
2012-08-24 13:02:47.39 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:2 TaskProxy0x00000005441354D0) Value:0xa7a8748 Cost0/10000)
2012-08-24 13:02:47.39 spid8s SPID: 108 ECID: 2 Statement Type: SELECT Line #: 1
2012-08-24 13:02:47.39 spid8s Input Buf: No Event:
2012-08-24 13:02:47.39 spid8s
2012-08-24 13:02:47.39 spid8s Node:4

2012-08-24 13:02:47.39 spid8s Port: 0x000000022B1F8680 Xid Slot: 1, Wait Slot: -1, Task: 0x000000022BCB0088, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0
2012-08-24 13:02:47.39 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:9 TaskProxy0x0000000544135770) Value:0x2bcb0088 Cost0/10000)
2012-08-24 13:02:47.39 spid8s SPID: 108 ECID: 9 Statement Type: SELECT Line #: 1
2012-08-24 13:02:47.39 spid8s Input Buf: No Event:
2012-08-24 13:02:47.40 spid8s
2012-08-24 13:02:47.40 spid8s Node:5

2012-08-24 13:02:47.40 spid8s Port: 0x000000022B1F8D00 Xid Slot: 0, Wait Slot: -1, Task: 0x000000022B674088, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0
2012-08-24 13:02:47.40 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:12 TaskProxy0x0000000544135890) Value:0x2b674088 Cost0/10000)
2012-08-24 13:02:47.40 spid8s SPID: 108 ECID: 12 Statement Type: SELECT Line #: 1
2012-08-24 13:02:47.40 spid8s Input Buf: No Event:
2012-08-24 13:02:47.40 spid8s
2012-08-24 13:02:47.40 spid8s Node:6

2012-08-24 13:02:47.40 spid8s Port: 0x000000022B1F8E00 Xid Slot: 2, Wait Slot: -1, Task: 0x00000000E3F1A508, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0
2012-08-24 13:02:47.40 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:10 TaskProxy0x00000005441357D0) Value:0xe3f1a508 Cost0/10000)
2012-08-24 13:02:47.40 spid8s SPID: 108 ECID: 10 Statement Type: SELECT Line #: 1
2012-08-24 13:02:47.40 spid8s Input Buf: No Event:
2012-08-24 13:02:47.40 spid8s
2012-08-24 13:02:47.40 spid8s Node:7

2012-08-24 13:02:47.40 spid8s Port: 0x000000022D26B0E0 Xid Slot: 0, Wait Slot: 4, Task: 0x000000000A7A8988, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0
2012-08-24 13:02:47.40 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:7 TaskProxy0x00000005441356B0) Value:0xa7a8988 Cost0/10000)
2012-08-24 13:02:47.40 spid8s SPID: 108 ECID: 7 Statement Type: SELECT Line #: 1
2012-08-24 13:02:47.40 spid8s Input Buf: No Event:
2012-08-24 13:02:47.40 spid8s
2012-08-24 13:02:47.40 spid8s Node:8

2012-08-24 13:02:47.40 spid8s Port: 0x000000022B1F8D80 Xid Slot: 5, Wait Slot: 1, Task: 0x0000000005AAB048, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0
2012-08-24 13:02:47.40 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:1 TaskProxy0x0000000544134F80) Value:0x5aab048 Cost0/10000)
2012-08-24 13:02:47.40 spid8s SPID: 108 ECID: 1 Statement Type: SELECT Line #: 1
2012-08-24 13:02:47.40 spid8s Input Buf: No Event:
2012-08-24 13:02:47.40 spid8s
2012-08-24 13:02:47.40 spid8s Node:9

2012-08-24 13:02:47.40 spid8s Port: 0x000000022B1F8D80 Xid Slot: 4, Wait Slot: 1, Task: 0x00000000057C0748, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0
2012-08-24 13:02:47.40 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:3 TaskProxy0x0000000544135530) Value:0x57c0748 Cost0/10000)
2012-08-24 13:02:47.40 spid8s SPID: 108 ECID: 3 Statement Type: SELECT Line #: 1
2012-08-24 13:02:47.40 spid8s Input Buf: No Event:
2012-08-24 13:02:52.41 spid8s Deadlock encountered .... Printing deadlock information
2012-08-24 13:02:52.41 spid8s Wait-for graph
2012-08-24 13:02:52.41 spid8s
2012-08-24 13:02:52.41 spid8s Node:1

2012-08-24 13:02:52.41 spid8s Port: 0x000000022BC1F3A0 Xid Slot: 4, Wait Slot: 2, Task: 0x000000022B674508, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 1
2012-08-24 13:02:52.41 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:13 TaskProxy0x00000005441358F0) Value:0x2b674508 Cost20/0)
2012-08-24 13:02:52.41 spid8s
2012-08-24 13:02:52.41 spid8s Node:2

2012-08-24 13:02:52.41 spid8s Port: 0x000000022B1F8600 Xid Slot: 4, Wait Slot: 0, Task: 0x000000022BCB02C8, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0
2012-08-24 13:02:52.41 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:11 TaskProxy0x0000000544135830) Value:0x2bcb02c8 Cost0/10000)
2012-08-24 13:02:52.41 spid8s
2012-08-24 13:02:52.41 spid8s Node:3

2012-08-24 13:02:52.41 spid8s Port: 0x000000022B1F8D80 Xid Slot: 3, Wait Slot: 1, Task: 0x000000000A7A8748, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0
2012-08-24 13:02:52.41 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:2 TaskProxy0x00000005441354D0) Value:0xa7a8748 Cost0/10000)
2012-08-24 13:02:52.41 spid8s
2012-08-24 13:02:52.41 spid8s Node:4

2012-08-24 13:02:52.41 spid8s Port: 0x000000022B1F8D00 Xid Slot: 0, Wait Slot: -1, Task: 0x000000022B674088, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0
2012-08-24 13:02:52.41 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:12 TaskProxy0x0000000544135890) Value:0x2b674088 Cost0/10000)
2012-08-24 13:02:52.41 spid8s
2012-08-24 13:02:52.41 spid8s Node:5

2012-08-24 13:02:52.41 spid8s Port: 0x000000022B1F8E00 Xid Slot: 2, Wait Slot: -1, Task: 0x00000000E3F1A508, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0
2012-08-24 13:02:52.41 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:10 TaskProxy0x00000005441357D0) Value:0xe3f1a508 Cost0/10000)
2012-08-24 13:02:52.41 spid8s
2012-08-24 13:02:52.41 spid8s Node:6

2012-08-24 13:02:52.41 spid8s Port: 0x000000022D26B0E0 Xid Slot: 0, Wait Slot: 4, Task: 0x000000000A7A8988, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0
2012-08-24 13:02:52.41 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:7 TaskProxy0x00000005441356B0) Value:0xa7a8988 Cost0/10000)
2012-08-24 13:02:52.41 spid8s
2012-08-24 13:02:52.41 spid8s Node:7

2012-08-24 13:02:52.41 spid8s Port: 0x000000022B1F8D80 Xid Slot: 5, Wait Slot: 1, Task: 0x0000000005AAB048, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0
2012-08-24 13:02:52.41 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:1 TaskProxy0x0000000544134F80) Value:0x5aab048 Cost0/10000)
2012-08-24 13:02:52.41 spid8s
2012-08-24 13:02:52.41 spid8s Node:8

2012-08-24 13:02:52.41 spid8s Port: 0x000000022B1F8700 Xid Slot: 2, Wait Slot: -1, Task: 0x0000000005AAAE08, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0
2012-08-24 13:02:52.41 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:8 TaskProxy0x0000000544135710) Value:0x5aaae08 Cost0/10000)
2012-08-24 13:02:52.41 spid8s SPID: 108 ECID: 8 Statement Type: SELECT Line #: 1
2012-08-24 13:02:52.41 spid8s Input Buf: No Event:
2012-08-24 13:02:52.41 spid8s
2012-08-24 13:02:52.41 spid8s Node:9

2012-08-24 13:02:52.41 spid8s Port: 0x000000022B1F8D80 Xid Slot: 4, Wait Slot: 1, Task: 0x00000000057C0748, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0
2012-08-24 13:02:52.41 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:3 TaskProxy0x0000000544135530) Value:0x57c0748 Cost0/10000)
2012-08-24 13:02:54.91 spid8s Deadlock encountered .... Printing deadlock information
2012-08-24 13:02:54.91 spid8s Wait-for graph
2012-08-24 13:02:54.91 spid8s
2012-08-24 13:02:54.91 spid8s Node:1

2012-08-24 13:02:54.91 spid8s Port: 0x000000021D775C80 Xid Slot: 3, Wait Slot: 1, Task: 0x000000022D336748, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 1
2012-08-24 13:02:54.91 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:13 TaskProxy0x00000005441358F0) Value:0x2d336748 Cost20/0)
2012-08-24 13:02:54.91 spid8s SPID: 108 ECID: 13 Statement Type: SELECT Line #: 1
2012-08-24 13:02:54.91 spid8s Input Buf: No Event:
2012-08-24 13:02:54.91 spid8s
2012-08-24 13:02:54.91 spid8s Node:2

2012-08-24 13:02:54.91 spid8s Port: 0x000000022D35A600 Xid Slot: 4, Wait Slot: 0, Task: 0x000000022A78A2C8, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0
2012-08-24 13:02:54.91 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:11 TaskProxy0x0000000544135830) Value:0x2a78a2c8 Cost0/10000)
2012-08-24 13:02:54.91 spid8s SPID: 108 ECID: 11 Statement Type: SELECT Line #: 1
2012-08-24 13:02:54.91 spid8s Input Buf: No Event:
2012-08-24 13:02:54.91 spid8s
2012-08-24 13:02:54.91 spid8s Node:3

2012-08-24 13:02:54.91 spid8s Port: 0x000000022D35AD80 Xid Slot: 3, Wait Slot: 1, Task: 0x0000000004E37DC8, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0
2012-08-24 13:02:54.91 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:1 TaskProxy0x0000000544134F80) Value:0x4e37dc8 Cost0/10000)
2012-08-24 13:02:54.91 spid8s SPID: 108 ECID: 1 Statement Type: SELECT Line #: 1
2012-08-24 13:02:54.91 spid8s Input Buf: No Event:
2012-08-24 13:02:54.91 spid8s
2012-08-24 13:02:54.91 spid8s Node:4

2012-08-24 13:02:54.91 spid8s Port: 0x000000029A214280 Xid Slot: 0, Wait Slot: 3, Task: 0x000000022A78A088, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0
2012-08-24 13:02:54.91 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:7 TaskProxy0x00000005441356B0) Value:0x2a78a088 Cost0/10000)
2012-08-24 13:02:54.91 spid8s SPID: 108 ECID: 7 Statement Type: SELECT Line #: 1
2012-08-24 13:02:54.91 spid8s Input Buf: No Event:
2012-08-24 13:02:54.91 spid8s
2012-08-24 13:02:54.91 spid8s Node:5

2012-08-24 13:02:54.91 spid8s Port: 0x000000022D35AD80 Xid Slot: 4, Wait Slot: 1, Task: 0x0000000000B254C8, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0
2012-08-24 13:02:54.91 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:3 TaskProxy0x0000000544135530) Value:0xb254c8 Cost0/10000)
2012-08-24 13:02:54.91 spid8s SPID: 108 ECID: 3 Statement Type: SELECT Line #: 1
2012-08-24 13:02:54.91 spid8s Input Buf: No Event:
2012-08-24 13:02:54.91 spid8s
2012-08-24 13:02:54.91 spid8s Node:6

2012-08-24 13:02:54.91 spid8s Port: 0x000000022D35A680 Xid Slot: 1, Wait Slot: -1, Task: 0x000000022D336088, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0
2012-08-24 13:02:54.92 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:8 TaskProxy0x0000000544135710) Value:0x2d336088 Cost0/10000)
2012-08-24 13:02:54.92 spid8s SPID: 108 ECID: 8 Statement Type: SELECT Line #: 1
2012-08-24 13:02:54.92 spid8s Input Buf: No Event:
2012-08-24 13:02:54.92 spid8s
2012-08-24 13:02:54.92 spid8s Node:7

2012-08-24 13:02:54.92 spid8s Port: 0x000000022D35AD80 Xid Slot: 5, Wait Slot: 1, Task: 0x0000000004E03288, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0
2012-08-24 13:02:54.92 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:2 TaskProxy0x00000005441354D0) Value:0x4e03288 Cost0/10000)
2012-08-24 13:02:54.92 spid8s SPID: 108 ECID: 2 Statement Type: SELECT Line #: 1
2012-08-24 13:02:54.92 spid8s Input Buf: No Event:
2012-08-24 13:02:54.92 spid8s
2012-08-24 13:02:54.92 spid8s Node:8

2012-08-24 13:02:54.92 spid8s Port: 0x000000022D35AD00 Xid Slot: 0, Wait Slot: -1, Task: 0x000000022D3362C8, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0
2012-08-24 13:02:54.92 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:12 TaskProxy0x0000000544135890) Value:0x2d3362c8 Cost0/10000)
2012-08-24 13:02:54.92 spid8s SPID: 108 ECID: 12 Statement Type: SELECT Line #: 1
2012-08-24 13:02:54.92 spid8s Input Buf: No Event:
2012-08-24 13:02:54.92 spid8s
2012-08-24 13:02:54.92 spid8s Node:9

2012-08-24 13:02:54.92 spid8s Port: 0x000000022D35AE00 Xid Slot: 2, Wait Slot: -1, Task: 0x000000022D32C2C8, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0
2012-08-24 13:02:54.92 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:10 TaskProxy0x00000005441357D0) Value:0x2d32c2c8 Cost0/10000)
2012-08-24 13:02:54.92 spid8s SPID: 108 ECID: 10 Statement Type: SELECT Line #: 1
2012-08-24 13:02:54.92 spid8s Input Buf: No Event:
2012-08-24 13:02:56.18 spid8s Deadlock encountered .... Printing deadlock information
2012-08-24 13:02:56.18 spid8s Wait-for graph
2012-08-24 13:02:56.18 spid8s
2012-08-24 13:02:56.18 spid8s Node:1

2012-08-24 13:02:56.18 spid8s Port: 0x000000021D774AB0 Xid Slot: 3, Wait Slot: 2, Task: 0x000000022D336748, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 1
2012-08-24 13:02:56.18 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:13 TaskProxy0x00000005441358F0) Value:0x2d336748 Cost20/0)
2012-08-24 13:02:56.18 spid8s
2012-08-24 13:02:56.18 spid8s Node:2

2012-08-24 13:02:56.18 spid8s Port: 0x000000022D35A600 Xid Slot: 4, Wait Slot: 0, Task: 0x000000022A78A2C8, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0
2012-08-24 13:02:56.18 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:11 TaskProxy0x0000000544135830) Value:0x2a78a2c8 Cost0/10000)
2012-08-24 13:02:56.18 spid8s
2012-08-24 13:02:56.18 spid8s Node:3

2012-08-24 13:02:56.18 spid8s Port: 0x000000022D35AD80 Xid Slot: 3, Wait Slot: 1, Task: 0x0000000004E37DC8, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0
2012-08-24 13:02:56.18 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:1 TaskProxy0x0000000544134F80) Value:0x4e37dc8 Cost0/10000)
2012-08-24 13:02:56.18 spid8s
2012-08-24 13:02:56.18 spid8s Node:4

2012-08-24 13:02:56.18 spid8s Port: 0x000000029A214280 Xid Slot: 0, Wait Slot: 3, Task: 0x000000022A78A088, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0
2012-08-24 13:02:56.18 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:7 TaskProxy0x00000005441356B0) Value:0x2a78a088 Cost0/10000)
2012-08-24 13:02:56.18 spid8s
2012-08-24 13:02:56.18 spid8s Node:5

2012-08-24 13:02:56.18 spid8s Port: 0x000000022D35AD80 Xid Slot: 4, Wait Slot: 1, Task: 0x0000000000B254C8, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0
2012-08-24 13:02:56.18 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:3 TaskProxy0x0000000544135530) Value:0xb254c8 Cost0/10000)
2012-08-24 13:02:56.18 spid8s
2012-08-24 13:02:56.18 spid8s Node:6

2012-08-24 13:02:56.18 spid8s Port: 0x000000022D35AD80 Xid Slot: 5, Wait Slot: 1, Task: 0x0000000004E03288, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0
2012-08-24 13:02:56.18 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:2 TaskProxy0x00000005441354D0) Value:0x4e03288 Cost0/10000)
2012-08-24 13:02:56.18 spid8s
2012-08-24 13:02:56.18 spid8s Node:7

2012-08-24 13:02:56.18 spid8s Port: 0x000000022D35A700 Xid Slot: 2, Wait Slot: -1, Task: 0x000000022D32C088, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0
2012-08-24 13:02:56.18 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:9 TaskProxy0x0000000544135770) Value:0x2d32c088 Cost0/10000)
2012-08-24 13:02:56.18 spid8s SPID: 108 ECID: 9 Statement Type: SELECT Line #: 1
2012-08-24 13:02:56.18 spid8s Input Buf: No Event:
2012-08-24 13:02:56.18 spid8s
2012-08-24 13:02:56.18 spid8s Node:8

2012-08-24 13:02:56.18 spid8s Port: 0x000000022D35AD00 Xid Slot: 0, Wait Slot: -1, Task: 0x000000022D3362C8, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0
2012-08-24 13:02:56.18 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:12 TaskProxy0x0000000544135890) Value:0x2d3362c8 Cost0/10000)
2012-08-24 13:02:56.18 spid8s
2012-08-24 13:02:56.18 spid8s Node:9

2012-08-24 13:02:56.18 spid8s Port: 0x000000022D35AE00 Xid Slot: 2, Wait Slot: -1, Task: 0x000000022D32C2C8, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0
2012-08-24 13:02:56.18 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:10 TaskProxy0x00000005441357D0) Value:0x2d32c2c8 Cost0/10000)
2012-08-24 13:03:01.50 spid8s Deadlock encountered .... Printing deadlock information
2012-08-24 13:03:01.50 spid8s Wait-for graph
2012-08-24 13:03:01.50 spid8s
2012-08-24 13:03:01.50 spid8s Node:1

2012-08-24 13:03:01.50 spid8s Port: 0x00000002DD5EE3A0 Xid Slot: 5, Wait Slot: 1, Task: 0x000000024A86E748, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 1
2012-08-24 13:03:01.50 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:13 TaskProxy0x00000005441358F0) Value:0x4a86e748 Cost20/0)
2012-08-24 13:03:01.50 spid8s SPID: 108 ECID: 13 Statement Type: SELECT Line #: 1
2012-08-24 13:03:01.50 spid8s Input Buf: No Event:
2012-08-24 13:03:01.50 spid8s
2012-08-24 13:03:01.50 spid8s Node:2

2012-08-24 13:03:01.50 spid8s Port: 0x000000022D35AD80 Xid Slot: 3, Wait Slot: 1, Task: 0x0000000000B2E748, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0
2012-08-24 13:03:01.50 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:1 TaskProxy0x0000000544134F80) Value:0xb2e748 Cost0/10000)
2012-08-24 13:03:01.50 spid8s SPID: 108 ECID: 1 Statement Type: SELECT Line #: 1
2012-08-24 13:03:01.50 spid8s Input Buf: No Event:
2012-08-24 13:03:01.50 spid8s
2012-08-24 13:03:01.50 spid8s Node:3

2012-08-24 13:03:01.50 spid8s Port: 0x000000022D35AD00 Xid Slot: 0, Wait Slot: -1, Task: 0x000000029A938508, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0
2012-08-24 13:03:01.50 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:12 TaskProxy0x0000000544135890) Value:0x9a938508 Cost0/10000)
2012-08-24 13:03:01.50 spid8s SPID: 108 ECID: 12 Statement Type: SELECT Line #: 1
2012-08-24 13:03:01.50 spid8s Input Buf: No Event:
2012-08-24 13:03:01.50 spid8s
2012-08-24 13:03:01.50 spid8s Node:4

2012-08-24 13:03:01.50 spid8s Port: 0x000000022D35AE00 Xid Slot: 2, Wait Slot: -1, Task: 0x000000024A86E508, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0
2012-08-24 13:03:01.50 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:11 TaskProxy0x0000000544135830) Value:0x4a86e508 Cost0/10000)
2012-08-24 13:03:01.50 spid8s SPID: 108 ECID: 11 Statement Type: SELECT Line #: 1
2012-08-24 13:03:01.50 spid8s Input Buf: No Event:
2012-08-24 13:03:01.50 spid8s
2012-08-24 13:03:01.50 spid8s Node:5

2012-08-24 13:03:01.50 spid8s Port: 0x000000022D35AD80 Xid Slot: 4, Wait Slot: 1, Task: 0x0000000000B24E08, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0
2012-08-24 13:03:01.50 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:3 TaskProxy0x0000000544135530) Value:0xb24e08 Cost0/10000)
2012-08-24 13:03:01.50 spid8s SPID: 108 ECID: 3 Statement Type: SELECT Line #: 1
2012-08-24 13:03:01.50 spid8s Input Buf: No Event:
2012-08-24 13:03:01.50 spid8s
2012-08-24 13:03:01.50 spid8s Node:6

2012-08-24 13:03:01.50 spid8s Port: 0x000000022D35A600 Xid Slot: 4, Wait Slot: 0, Task: 0x000000022DCB02C8, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0
2012-08-24 13:03:01.50 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:10 TaskProxy0x00000005441357D0) Value:0x2dcb02c8 Cost0/10000)
2012-08-24 13:03:01.50 spid8s SPID: 108 ECID: 10 Statement Type: SELECT Line #: 1
2012-08-24 13:03:01.50 spid8s Input Buf: No Event:
2012-08-24 13:03:01.50 spid8s
2012-08-24 13:03:01.50 spid8s Node:7

2012-08-24 13:03:01.50 spid8s Port: 0x000000022D35AD80 Xid Slot: 5, Wait Slot: 1, Task: 0x000000000081BDC8, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0
2012-08-24 13:03:01.50 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:2 TaskProxy0x00000005441354D0) Value:0x81bdc8 Cost0/10000)
2012-08-24 13:03:01.50 spid8s SPID: 108 ECID: 2 Statement Type: SELECT Line #: 1
2012-08-24 13:03:01.50 spid8s Input Buf: No Event:
2012-08-24 13:03:01.50 spid8s
2012-08-24 13:03:01.50 spid8s Node:8

2012-08-24 13:03:01.50 spid8s Port: 0x000000022D35A680 Xid Slot: 1, Wait Slot: -1, Task: 0x000000022DCB0088, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0
2012-08-24 13:03:01.50 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:7 TaskProxy0x00000005441356B0) Value:0x2dcb0088 Cost0/10000)
2012-08-24 13:03:01.50 spid8s SPID: 108 ECID: 7 Statement Type: SELECT Line #: 1
2012-08-24 13:03:01.50 spid8s Input Buf: No Event:
2012-08-24 13:03:01.50 spid8s
2012-08-24 13:03:01.50 spid8s Node:9

2012-08-24 13:03:01.50 spid8s Port: 0x000000024AB84F30 Xid Slot: 0, Wait Slot: 5, Task: 0x000000029A9382C8, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0
2012-08-24 13:03:01.50 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:8 TaskProxy0x0000000544135710) Value:0x9a9382c8 Cost0/10000)
2012-08-24 13:03:01.50 spid8s SPID: 108 ECID: 8 Statement Type: SELECT Line #: 1
2012-08-24 13:03:01.50 spid8s Input Buf: No Event:
2012-08-24 13:03:06.49 spid8s Deadlock encountered .... Printing deadlock information
2012-08-24 13:03:06.49 spid8s Wait-for graph
2012-08-24 13:03:06.49 spid8s
2012-08-24 13:03:06.49 spid8s Node:1

2012-08-24 13:03:06.49 spid8s Port: 0x00000004048510F0 Xid Slot: 5, Wait Slot: 2, Task: 0x000000024A86E748, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 1
2012-08-24 13:03:06.49 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:13 TaskProxy0x00000005441358F0) Value:0x4a86e748 Cost20/0)
2012-08-24 13:03:06.49 spid8s
2012-08-24 13:03:06.49 spid8s Node:2

2012-08-24 13:03:06.49 spid8s Port: 0x000000022D35AD80 Xid Slot: 3, Wait Slot: 1, Task: 0x0000000000B2E748, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0
2012-08-24 13:03:06.49 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:1 TaskProxy0x0000000544134F80) Value:0xb2e748 Cost0/10000)
2012-08-24 13:03:06.49 spid8s
2012-08-24 13:03:06.49 spid8s Node:3

2012-08-24 13:03:06.49 spid8s Port: 0x000000022D35A700 Xid Slot: 2, Wait Slot: -1, Task: 0x000000024A86E2C8, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0
2012-08-24 13:03:06.49 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:9 TaskProxy0x0000000544135770) Value:0x4a86e2c8 Cost0/10000)
2012-08-24 13:03:06.49 spid8s SPID: 108 ECID: 9 Statement Type: SELECT Line #: 1
2012-08-24 13:03:06.49 spid8s Input Buf: No Event:
2012-08-24 13:03:06.49 spid8s
2012-08-24 13:03:06.49 spid8s Node:4

2012-08-24 13:03:06.49 spid8s Port: 0x000000022D35AD00 Xid Slot: 0, Wait Slot: -1, Task: 0x000000029A938508, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0
2012-08-24 13:03:06.49 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:12 TaskProxy0x0000000544135890) Value:0x9a938508 Cost0/10000)
2012-08-24 13:03:06.49 spid8s
2012-08-24 13:03:06.49 spid8s Node:5

2012-08-24 13:03:06.49 spid8s Port: 0x000000022D35AE00 Xid Slot: 2, Wait Slot: -1, Task: 0x000000024A86E508, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0
2012-08-24 13:03:06.49 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:11 TaskProxy0x0000000544135830) Value:0x4a86e508 Cost0/10000)
2012-08-24 13:03:06.49 spid8s
2012-08-24 13:03:06.49 spid8s Node:6

2012-08-24 13:03:06.49 spid8s Port: 0x000000022D35AD80 Xid Slot: 4, Wait Slot: 1, Task: 0x0000000000B24E08, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0
2012-08-24 13:03:06.49 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:3 TaskProxy0x0000000544135530) Value:0xb24e08 Cost0/10000)
2012-08-24 13:03:06.49 spid8s
2012-08-24 13:03:06.49 spid8s Node:7

2012-08-24 13:03:06.49 spid8s Port: 0x000000022D35A600 Xid Slot: 4, Wait Slot: 0, Task: 0x000000022DCB02C8, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0
2012-08-24 13:03:06.49 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:10 TaskProxy0x00000005441357D0) Value:0x2dcb02c8 Cost0/10000)
2012-08-24 13:03:06.49 spid8s
2012-08-24 13:03:06.49 spid8s Node:8

2012-08-24 13:03:06.49 spid8s Port: 0x000000022D35AD80 Xid Slot: 5, Wait Slot: 1, Task: 0x000000000081BDC8, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0
2012-08-24 13:03:06.49 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:2 TaskProxy0x00000005441354D0) Value:0x81bdc8 Cost0/10000)
2012-08-24 13:03:06.49 spid8s
2012-08-24 13:03:06.49 spid8s Node:9

2012-08-24 13:03:06.49 spid8s Port: 0x000000024AB84F30 Xid Slot: 0, Wait Slot: 5, Task: 0x000000029A9382C8, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0
2012-08-24 13:03:06.49 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:8 TaskProxy0x0000000544135710) Value:0x9a9382c8 Cost0/10000)
2012-08-24 13:03:08.99 spid8s Deadlock encountered .... Printing deadlock information
2012-08-24 13:03:08.99 spid8s Wait-for graph
2012-08-24 13:03:08.99 spid8s
2012-08-24 13:03:08.99 spid8s Node:1

2012-08-24 13:03:08.99 spid8s Port: 0x000000022CD4D380 Xid Slot: 5, Wait Slot: 1, Task: 0x000000022D9A82C8, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 1
2012-08-24 13:03:08.99 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:13 TaskProxy0x00000005441358F0) Value:0x2d9a82c8 Cost20/0)
2012-08-24 13:03:08.99 spid8s SPID: 108 ECID: 13 Statement Type: SELECT Line #: 1
2012-08-24 13:03:08.99 spid8s Input Buf: No Event:
2012-08-24 13:03:08.99 spid8s
2012-08-24 13:03:08.99 spid8s Node:2

2012-08-24 13:03:08.99 spid8s Port: 0x000000022DE284D0 Xid Slot: 0, Wait Slot: 5, Task: 0x000000022D4E8088, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0
2012-08-24 13:03:08.99 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:7 TaskProxy0x00000005441356B0) Value:0x2d4e8088 Cost0/10000)
2012-08-24 13:03:08.99 spid8s SPID: 108 ECID: 7 Statement Type: SELECT Line #: 1
2012-08-24 13:03:08.99 spid8s Input Buf: No Event:
2012-08-24 13:03:08.99 spid8s
2012-08-24 13:03:08.99 spid8s Node:3

2012-08-24 13:03:08.99 spid8s Port: 0x000000022DE06600 Xid Slot: 4, Wait Slot: 0, Task: 0x000000022D9A8088, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0
2012-08-24 13:03:08.99 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:10 TaskProxy0x00000005441357D0) Value:0x2d9a8088 Cost0/10000)
2012-08-24 13:03:08.99 spid8s SPID: 108 ECID: 10 Statement Type: SELECT Line #: 1
2012-08-24 13:03:08.99 spid8s Input Buf: No Event:
2012-08-24 13:03:08.99 spid8s
2012-08-24 13:03:08.99 spid8s Node:4

2012-08-24 13:03:08.99 spid8s Port: 0x000000022DE06D80 Xid Slot: 3, Wait Slot: 1, Task: 0x000000000A7A8BC8, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0
2012-08-24 13:03:08.99 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:3 TaskProxy0x0000000544135530) Value:0xa7a8bc8 Cost0/10000)
2012-08-24 13:03:08.99 spid8s SPID: 108 ECID: 3 Statement Type: SELECT Line #: 1
2012-08-24 13:03:08.99 spid8s Input Buf: No Event:
2012-08-24 13:03:08.99 spid8s
2012-08-24 13:03:08.99 spid8s Node:5

2012-08-24 13:03:08.99 spid8s Port: 0x000000022DE06D00 Xid Slot: 0, Wait Slot: -1, Task: 0x000000022D4E82C8, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0
2012-08-24 13:03:08.99 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:11 TaskProxy0x0000000544135830) Value:0x2d4e82c8 Cost0/10000)
2012-08-24 13:03:08.99 spid8s SPID: 108 ECID: 11 Statement Type: SELECT Line #: 1
2012-08-24 13:03:08.99 spid8s Input Buf: No Event:
2012-08-24 13:03:08.99 spid8s
2012-08-24 13:03:08.99 spid8s Node:6

2012-08-24 13:03:08.99 spid8s Port: 0x000000022DE06D80 Xid Slot: 4, Wait Slot: 1, Task: 0x000000000A82B708, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0
2012-08-24 13:03:08.99 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:2 TaskProxy0x00000005441354D0) Value:0xa82b708 Cost0/10000)
2012-08-24 13:03:08.99 spid8s SPID: 108 ECID: 2 Statement Type: SELECT Line #: 1
2012-08-24 13:03:08.99 spid8s Input Buf: No Event:
2012-08-24 13:03:08.99 spid8s
2012-08-24 13:03:08.99 spid8s Node:7

2012-08-24 13:03:08.99 spid8s Port: 0x000000022DE06D80 Xid Slot: 5, Wait Slot: 1, Task: 0x000000000A7F6748, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0
2012-08-24 13:03:08.99 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:1 TaskProxy0x0000000544134F80) Value:0xa7f6748 Cost0/10000)
2012-08-24 13:03:08.99 spid8s SPID: 108 ECID: 1 Statement Type: SELECT Line #: 1
2012-08-24 13:03:08.99 spid8s Input Buf: No Event:
2012-08-24 13:03:08.99 spid8s
2012-08-24 13:03:08.99 spid8s Node:8

2012-08-24 13:03:08.99 spid8s Port: 0x000000022DE06680 Xid Slot: 1, Wait Slot: -1, Task: 0x000000000A7F7288, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0
2012-08-24 13:03:08.99 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:8 TaskProxy0x0000000544135710) Value:0xa7f7288 Cost0/10000)
2012-08-24 13:03:08.99 spid8s SPID: 108 ECID: 8 Statement Type: SELECT Line #: 1
2012-08-24 13:03:08.99 spid8s Input Buf: No Event:
2012-08-24 13:03:08.99 spid8s
2012-08-24 13:03:08.99 spid8s Node:9

2012-08-24 13:03:08.99 spid8s Port: 0x000000022DE06E00 Xid Slot: 2, Wait Slot: -1, Task: 0x000000075C80A508, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0
2012-08-24 13:03:08.99 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:12 TaskProxy0x0000000544135890) Value:0x5c80a508 Cost0/10000)
2012-08-24 13:03:08.99 spid8s SPID: 108 ECID: 12 Statement Type: SELECT Line #: 1
2012-08-24 13:03:08.99 spid8s Input Buf: No Event:
2012-08-24 13:03:10.23 spid8s Deadlock encountered .... Printing deadlock information
2012-08-24 13:03:10.23 spid8s Wait-for graph
2012-08-24 13:03:10.23 spid8s
2012-08-24 13:03:10.23 spid8s Node:1

2012-08-24 13:03:10.23 spid8s Port: 0x000000022CD4D9E0 Xid Slot: 5, Wait Slot: 2, Task: 0x000000022D9A82C8, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 1
2012-08-24 13:03:10.23 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:13 TaskProxy0x00000005441358F0) Value:0x2d9a82c8 Cost20/0)
2012-08-24 13:03:10.23 spid8s
2012-08-24 13:03:10.23 spid8s Node:2

2012-08-24 13:03:10.23 spid8s Port: 0x000000022DE284D0 Xid Slot: 0, Wait Slot: 5, Task: 0x000000022D4E8088, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0
2012-08-24 13:03:10.23 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:7 TaskProxy0x00000005441356B0) Value:0x2d4e8088 Cost0/10000)
2012-08-24 13:03:10.23 spid8s
2012-08-24 13:03:10.23 spid8s Node:3

2012-08-24 13:03:10.23 spid8s Port: 0x000000022DE06600 Xid Slot: 4, Wait Slot: 0, Task: 0x000000022D9A8088, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0
2012-08-24 13:03:10.23 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:10 TaskProxy0x00000005441357D0) Value:0x2d9a8088 Cost0/10000)
2012-08-24 13:03:10.23 spid8s
2012-08-24 13:03:10.23 spid8s Node:4

2012-08-24 13:03:10.23 spid8s Port: 0x000000022DE06D80 Xid Slot: 3, Wait Slot: 1, Task: 0x000000000A7A8BC8, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0
2012-08-24 13:03:10.23 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:3 TaskProxy0x0000000544135530) Value:0xa7a8bc8 Cost0/10000)
2012-08-24 13:03:10.23 spid8s
2012-08-24 13:03:10.23 spid8s Node:5

2012-08-24 13:03:10.23 spid8s Port: 0x000000022DE06D00 Xid Slot: 0, Wait Slot: -1, Task: 0x000000022D4E82C8, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0
2012-08-24 13:03:10.23 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:11 TaskProxy0x0000000544135830) Value:0x2d4e82c8 Cost0/10000)
2012-08-24 13:03:10.23 spid8s
2012-08-24 13:03:10.23 spid8s Node:6

2012-08-24 13:03:10.23 spid8s Port: 0x000000022DE06D80 Xid Slot: 4, Wait Slot: 1, Task: 0x000000000A82B708, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0
2012-08-24 13:03:10.23 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:2 TaskProxy0x00000005441354D0) Value:0xa82b708 Cost0/10000)
2012-08-24 13:03:10.23 spid8s
2012-08-24 13:03:10.23 spid8s Node:7

2012-08-24 13:03:10.23 spid8s Port: 0x000000022DE06D80 Xid Slot: 5, Wait Slot: 1, Task: 0x000000000A7F6748, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0
2012-08-24 13:03:10.23 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:1 TaskProxy0x0000000544134F80) Value:0xa7f6748 Cost0/10000)
2012-08-24 13:03:10.23 spid8s
2012-08-24 13:03:10.23 spid8s Node:8

2012-08-24 13:03:10.23 spid8s Port: 0x000000022DE06E00 Xid Slot: 2, Wait Slot: -1, Task: 0x000000075C80A508, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0
2012-08-24 13:03:10.23 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:12 TaskProxy0x0000000544135890) Value:0x5c80a508 Cost0/10000)
2012-08-24 13:03:10.23 spid8s
2012-08-24 13:03:10.23 spid8s Node:9

2012-08-24 13:03:10.23 spid8s Port: 0x000000022DE06700 Xid Slot: 2, Wait Slot: -1, Task: 0x000000000A82BDC8, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0
2012-08-24 13:03:10.23 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:9 TaskProxy0x0000000544135770) Value:0xa82bdc8 Cost0/10000)
2012-08-24 13:03:10.23 spid8s SPID: 108 ECID: 9 Statement Type: SELECT Line #: 1
2012-08-24 13:03:10.23 spid8s Input Buf: No Event:
2012-08-24 13:03:10.86 spid8s Deadlock encountered .... Printing deadlock information
2012-08-24 13:03:10.86 spid8s Wait-for graph
2012-08-24 13:03:10.86 spid8s
2012-08-24 13:03:10.86 spid8s Node:1

2012-08-24 13:03:10.86 spid8s Port: 0x00000002EFB04780 Xid Slot: 5, Wait Slot: 1, Task: 0x00000002226542C8, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 1
2012-08-24 13:03:10.86 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:14 TaskProxy0x0000000544135950) Value:0x226542c8 Cost20/0)
2012-08-24 13:03:10.86 spid8s SPID: 108 ECID: 14 Statement Type: SELECT Line #: 1
2012-08-24 13:03:10.86 spid8s Input Buf: No Event:
2012-08-24 13:03:10.86 spid8s
2012-08-24 13:03:10.86 spid8s Node:2

2012-08-24 13:03:10.86 spid8s Port: 0x000000022AE98600 Xid Slot: 4, Wait Slot: 0, Task: 0x00000002B54A8748, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0
2012-08-24 13:03:10.86 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:12 TaskProxy0x0000000544135890) Value:0xb54a8748 Cost0/10000)
2012-08-24 13:03:10.86 spid8s SPID: 108 ECID: 12 Statement Type: SELECT Line #: 1
2012-08-24 13:03:10.86 spid8s Input Buf: No Event:
2012-08-24 13:03:10.86 spid8s
2012-08-24 13:03:10.86 spid8s Node:3

2012-08-24 13:03:10.86 spid8s Port: 0x000000022AE98D80 Xid Slot: 3, Wait Slot: 1, Task: 0x0000000004E374C8, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0
2012-08-24 13:03:10.86 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:1 TaskProxy0x0000000544134F80) Value:0x4e374c8 Cost0/10000)
2012-08-24 13:03:10.86 spid8s SPID: 108 ECID: 1 Statement Type: SELECT Line #: 1
2012-08-24 13:03:10.86 spid8s Input Buf: No Event:
2012-08-24 13:03:10.86 spid8s
2012-08-24 13:03:10.86 spid8s Node:4

2012-08-24 13:03:10.86 spid8s Port: 0x00000002EF82AF30 Xid Slot: 0, Wait Slot: 5, Task: 0x00000002B54A8508, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0
2012-08-24 13:03:10.86 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:8 TaskProxy0x0000000544135710) Value:0xb54a8508 Cost0/10000)
2012-08-24 13:03:10.86 spid8s SPID: 108 ECID: 8 Statement Type: SELECT Line #: 1
2012-08-24 13:03:10.86 spid8s Input Buf: No Event:
2012-08-24 13:03:10.86 spid8s
2012-08-24 13:03:10.86 spid8s Node:5

2012-08-24 13:03:10.86 spid8s Port: 0x000000022AE98D80 Xid Slot: 4, Wait Slot: 1, Task: 0x0000000000B24E08, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0
2012-08-24 13:03:10.86 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:2 TaskProxy0x00000005441354D0) Value:0xb24e08 Cost0/10000)
2012-08-24 13:03:10.86 spid8s SPID: 108 ECID: 2 Statement Type: SELECT Line #: 1
2012-08-24 13:03:10.86 spid8s Input Buf: No Event:
2012-08-24 13:03:10.86 spid8s
2012-08-24 13:03:10.86 spid8s Node:6

2012-08-24 13:03:10.86 spid8s Port: 0x000000022AE98D80 Xid Slot: 5, Wait Slot: 1, Task: 0x0000000000B2F4C8, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0
2012-08-24 13:03:10.86 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:3 TaskProxy0x0000000544135530) Value:0xb2f4c8 Cost0/10000)
2012-08-24 13:03:10.86 spid8s SPID: 108 ECID: 3 Statement Type: SELECT Line #: 1
2012-08-24 13:03:10.86 spid8s Input Buf: No Event:
2012-08-24 13:03:10.86 spid8s
2012-08-24 13:03:10.86 spid8s Node:7

2012-08-24 13:03:10.86 spid8s Port: 0x000000022AE98D00 Xid Slot: 0, Wait Slot: -1, Task: 0x000000022A7AE2C8, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0
2012-08-24 13:03:10.86 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:10 TaskProxy0x00000005441357D0) Value:0x2a7ae2c8 Cost0/10000)
2012-08-24 13:03:10.86 spid8s SPID: 108 ECID: 10 Statement Type: SELECT Line #: 1
2012-08-24 13:03:10.86 spid8s Input Buf: No Event:
2012-08-24 13:03:10.86 spid8s
2012-08-24 13:03:10.86 spid8s Node:8

2012-08-24 13:03:10.86 spid8s Port: 0x000000022AE98E00 Xid Slot: 2, Wait Slot: -1, Task: 0x0000000222654088, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0
2012-08-24 13:03:10.86 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:11 TaskProxy0x0000000544135830) Value:0x22654088 Cost0/10000)
2012-08-24 13:03:10.86 spid8s SPID: 108 ECID: 11 Statement Type: SELECT Line #: 1
2012-08-24 13:03:10.86 spid8s Input Buf: No Event:
2012-08-24 13:03:10.86 spid8s
2012-08-24 13:03:10.86 spid8s Node:9

2012-08-24 13:03:10.86 spid8s Port: 0x000000022AE98680 Xid Slot: 1, Wait Slot: -1, Task: 0x000000022A7AE088, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0
2012-08-24 13:03:10.86 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:7 TaskProxy0x00000005441356B0) Value:0x2a7ae088 Cost0/10000)
2012-08-24 13:03:10.86 spid8s SPID: 108 ECID: 7 Statement Type: SELECT Line #: 1
2012-08-24 13:03:10.86 spid8s Input Buf: No Event:
2012-08-24 13:03:11.17 spid8s Deadlock encountered .... Printing deadlock information
2012-08-24 13:03:11.17 spid8s Wait-for graph
2012-08-24 13:03:11.17 spid8s
2012-08-24 13:03:11.17 spid8s Node:1

2012-08-24 13:03:11.17 spid8s Port: 0x000000027E9A6710 Xid Slot: 5, Wait Slot: 2, Task: 0x00000002226542C8, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 1
2012-08-24 13:03:11.17 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:14 TaskProxy0x0000000544135950) Value:0x226542c8 Cost20/0)
2012-08-24 13:03:11.17 spid8s
2012-08-24 13:03:11.17 spid8s Node:2

2012-08-24 13:03:11.17 spid8s Port: 0x000000022AE98600 Xid Slot: 4, Wait Slot: 0, Task: 0x00000002B54A8748, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0
2012-08-24 13:03:11.17 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:12 TaskProxy0x0000000544135890) Value:0xb54a8748 Cost0/10000)
2012-08-24 13:03:11.17 spid8s
2012-08-24 13:03:11.17 spid8s Node:3

2012-08-24 13:03:11.17 spid8s Port: 0x000000022AE98D80 Xid Slot: 3, Wait Slot: 1, Task: 0x0000000004E374C8, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0
2012-08-24 13:03:11.17 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:1 TaskProxy0x0000000544134F80) Value:0x4e374c8 Cost0/10000)
2012-08-24 13:03:11.17 spid8s
2012-08-24 13:03:11.17 spid8s Node:4

2012-08-24 13:03:11.17 spid8s Port: 0x00000002EF82AF30 Xid Slot: 0, Wait Slot: 5, Task: 0x00000002B54A8508, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0
2012-08-24 13:03:11.17 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:8 TaskProxy0x0000000544135710) Value:0xb54a8508 Cost0/10000)
2012-08-24 13:03:11.17 spid8s
2012-08-24 13:03:11.17 spid8s Node:5

2012-08-24 13:03:11.17 spid8s Port: 0x000000022AE98D80 Xid Slot: 4, Wait Slot: 1, Task: 0x0000000000B24E08, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0
2012-08-24 13:03:11.17 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:2 TaskProxy0x00000005441354D0) Value:0xb24e08 Cost0/10000)
2012-08-24 13:03:11.17 spid8s
2012-08-24 13:03:11.17 spid8s Node:6

2012-08-24 13:03:11.17 spid8s Port: 0x000000022AE98D80 Xid Slot: 5, Wait Slot: 1, Task: 0x0000000000B2F4C8, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0
2012-08-24 13:03:11.17 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:3 TaskProxy0x0000000544135530) Value:0xb2f4c8 Cost0/10000)
2012-08-24 13:03:11.17 spid8s
2012-08-24 13:03:11.17 spid8s Node:7

2012-08-24 13:03:11.17 spid8s Port: 0x000000022AE98700 Xid Slot: 2, Wait Slot: -1, Task: 0x0000000000B2F048, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0
2012-08-24 13:03:11.17 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:9 TaskProxy0x0000000544135770) Value:0xb2f048 Cost0/10000)
2012-08-24 13:03:11.17 spid8s SPID: 108 ECID: 9 Statement Type: SELECT Line #: 1
2012-08-24 13:03:11.17 spid8s Input Buf: No Event:
2012-08-24 13:03:11.17 spid8s
2012-08-24 13:03:11.17 spid8s Node:8

2012-08-24 13:03:11.17 spid8s Port: 0x000000022AE98D00 Xid Slot: 0, Wait Slot: -1, Task: 0x000000022A7AE2C8, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0
2012-08-24 13:03:11.17 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:10 TaskProxy0x00000005441357D0) Value:0x2a7ae2c8 Cost0/10000)
2012-08-24 13:03:11.17 spid8s
2012-08-24 13:03:11.17 spid8s Node:9

2012-08-24 13:03:11.17 spid8s Port: 0x000000022AE98E00 Xid Slot: 2, Wait Slot: -1, Task: 0x0000000222654088, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0
2012-08-24 13:03:11.17 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:11 TaskProxy0x0000000544135830) Value:0x22654088 Cost0/10000)
2012-08-24 13:03:11.64 spid8s Deadlock encountered .... Printing deadlock information
2012-08-24 13:03:11.64 spid8s Wait-for graph
2012-08-24 13:03:11.64 spid8s
2012-08-24 13:03:11.64 spid8s Node:1

2012-08-24 13:03:11.64 spid8s Port: 0x000000029DE34AC0 Xid Slot: 3, Wait Slot: 1, Task: 0x000000029DD14988, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 1
2012-08-24 13:03:11.64 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:13 TaskProxy0x00000005441358F0) Value:0x9dd14988 Cost20/0)
2012-08-24 13:03:11.64 spid8s SPID: 108 ECID: 13 Statement Type: SELECT Line #: 1
2012-08-24 13:03:11.64 spid8s Input Buf: No Event:
2012-08-24 13:03:11.64 spid8s
2012-08-24 13:03:11.64 spid8s Node:2

2012-08-24 13:03:11.64 spid8s Port: 0x000000022D5E0D80 Xid Slot: 5, Wait Slot: 1, Task: 0x00000000050B8BC8, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0
2012-08-24 13:03:11.64 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:3 TaskProxy0x0000000544135530) Value:0x50b8bc8 Cost0/10000)
2012-08-24 13:03:11.64 spid8s SPID: 108 ECID: 3 Statement Type: SELECT Line #: 1
2012-08-24 13:03:11.64 spid8s Input Buf: No Event:
2012-08-24 13:03:11.64 spid8s
2012-08-24 13:03:11.64 spid8s Node:3

2012-08-24 13:03:11.64 spid8s Port: 0x000000022D5E0680 Xid Slot: 1, Wait Slot: -1, Task: 0x000000029DD142C8, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0
2012-08-24 13:03:11.64 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:8 TaskProxy0x0000000544135710) Value:0x9dd142c8 Cost0/10000)
2012-08-24 13:03:11.64 spid8s SPID: 108 ECID: 8 Statement Type: SELECT Line #: 1
2012-08-24 13:03:11.64 spid8s Input Buf: No Event:
2012-08-24 13:03:11.64 spid8s
2012-08-24 13:03:11.64 spid8s Node:4

2012-08-24 13:03:11.64 spid8s Port: 0x000000022D5E0D00 Xid Slot: 0, Wait Slot: -1, Task: 0x000000029DD14508, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0
2012-08-24 13:03:11.64 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:11 TaskProxy0x0000000544135830) Value:0x9dd14508 Cost0/10000)
2012-08-24 13:03:11.64 spid8s SPID: 108 ECID: 11 Statement Type: SELECT Line #: 1
2012-08-24 13:03:11.64 spid8s Input Buf: No Event:
2012-08-24 13:03:11.64 spid8s
2012-08-24 13:03:11.64 spid8s Node:5

2012-08-24 13:03:11.64 spid8s Port: 0x000000022D5E0E00 Xid Slot: 2, Wait Slot: -1, Task: 0x000000022D3AA2C8, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0
2012-08-24 13:03:11.64 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:12 TaskProxy0x0000000544135890) Value:0x2d3aa2c8 Cost0/10000)
2012-08-24 13:03:11.64 spid8s SPID: 108 ECID: 12 Statement Type: SELECT Line #: 1
2012-08-24 13:03:11.64 spid8s Input Buf: No Event:
2012-08-24 13:03:11.64 spid8s
2012-08-24 13:03:11.64 spid8s Node:6

2012-08-24 13:03:11.64 spid8s Port: 0x000000022D5E0D80 Xid Slot: 4, Wait Slot: 1, Task: 0x0000000004E374C8, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0
2012-08-24 13:03:11.64 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:1 TaskProxy0x0000000544134F80) Value:0x4e374c8 Cost0/10000)
2012-08-24 13:03:11.64 spid8s SPID: 108 ECID: 1 Statement Type: SELECT Line #: 1
2012-08-24 13:03:11.64 spid8s Input Buf: No Event:
2012-08-24 13:03:11.64 spid8s
2012-08-24 13:03:11.64 spid8s Node:7

2012-08-24 13:03:11.64 spid8s Port: 0x000000022D5E0600 Xid Slot: 4, Wait Slot: 0, Task: 0x00000002B54A8508, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0
2012-08-24 13:03:11.64 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:10 TaskProxy0x00000005441357D0) Value:0xb54a8508 Cost0/10000)
2012-08-24 13:03:11.64 spid8s SPID: 108 ECID: 10 Statement Type: SELECT Line #: 1
2012-08-24 13:03:11.64 spid8s Input Buf: No Event:
2012-08-24 13:03:11.64 spid8s
2012-08-24 13:03:11.64 spid8s Node:8

2012-08-24 13:03:11.64 spid8s Port: 0x000000022D5E0D80 Xid Slot: 3, Wait Slot: 1, Task: 0x0000000000B24E08, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0
2012-08-24 13:03:11.64 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:2 TaskProxy0x00000005441354D0) Value:0xb24e08 Cost0/10000)
2012-08-24 13:03:11.64 spid8s SPID: 108 ECID: 2 Statement Type: SELECT Line #: 1
2012-08-24 13:03:11.64 spid8s Input Buf: No Event:
2012-08-24 13:03:11.64 spid8s
2012-08-24 13:03:11.64 spid8s Node:9

2012-08-24 13:03:11.64 spid8s Port: 0x0000000274320590 Xid Slot: 0, Wait Slot: 3, Task: 0x00000002B54A82C8, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0
2012-08-24 13:03:11.64 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:9 TaskProxy0x0000000544135770) Value:0xb54a82c8 Cost0/10000)
2012-08-24 13:03:11.64 spid8s SPID: 108 ECID: 9 Statement Type: SELECT Line #: 1
2012-08-24 13:03:11.64 spid8s Input Buf: No Event:
2012-08-24 13:03:12.05 spid8s Deadlock encountered .... Printing deadlock information
2012-08-24 13:03:12.05 spid8s Wait-for graph
2012-08-24 13:03:12.05 spid8s
2012-08-24 13:03:12.05 spid8s Node:1

2012-08-24 13:03:12.05 spid8s Port: 0x000000029DE35C10 Xid Slot: 3, Wait Slot: 2, Task: 0x000000029DD14988, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 1
2012-08-24 13:03:12.05 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:13 TaskProxy0x00000005441358F0) Value:0x9dd14988 Cost20/0)
2012-08-24 13:03:12.05 spid8s
2012-08-24 13:03:12.05 spid8s Node:2

2012-08-24 13:03:12.05 spid8s Port: 0x000000022D5E0D80 Xid Slot: 5, Wait Slot: 1, Task: 0x00000000050B8BC8, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0
2012-08-24 13:03:12.05 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:3 TaskProxy0x0000000544135530) Value:0x50b8bc8 Cost0/10000)
2012-08-24 13:03:12.05 spid8s
2012-08-24 13:03:12.05 spid8s Node:3

2012-08-24 13:03:12.05 spid8s Port: 0x000000022D5E0D00 Xid Slot: 0, Wait Slot: -1, Task: 0x000000029DD14508, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0
2012-08-24 13:03:12.05 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:11 TaskProxy0x0000000544135830) Value:0x9dd14508 Cost0/10000)
2012-08-24 13:03:12.05 spid8s
2012-08-24 13:03:12.05 spid8s Node:4

2012-08-24 13:03:12.05 spid8s Port: 0x000000022D5E0E00 Xid Slot: 2, Wait Slot: -1, Task: 0x000000022D3AA2C8, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0
2012-08-24 13:03:12.05 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:12 TaskProxy0x0000000544135890) Value:0x2d3aa2c8 Cost0/10000)
2012-08-24 13:03:12.05 spid8s
2012-08-24 13:03:12.05 spid8s Node:5

2012-08-24 13:03:12.05 spid8s Port: 0x000000022D5E0D80 Xid Slot: 4, Wait Slot: 1, Task: 0x0000000004E374C8, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0
2012-08-24 13:03:12.05 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:1 TaskProxy0x0000000544134F80) Value:0x4e374c8 Cost0/10000)
2012-08-24 13:03:12.05 spid8s
2012-08-24 13:03:12.05 spid8s Node:6

2012-08-24 13:03:12.05 spid8s Port: 0x000000022D5E0600 Xid Slot: 4, Wait Slot: 0, Task: 0x00000002B54A8508, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0
2012-08-24 13:03:12.05 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:10 TaskProxy0x00000005441357D0) Value:0xb54a8508 Cost0/10000)
2012-08-24 13:03:12.05 spid8s
2012-08-24 13:03:12.05 spid8s Node:7

2012-08-24 13:03:12.05 spid8s Port: 0x000000022D5E0D80 Xid Slot: 3, Wait Slot: 1, Task: 0x0000000000B24E08, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0
2012-08-24 13:03:12.06 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:2 TaskProxy0x00000005441354D0) Value:0xb24e08 Cost0/10000)
2012-08-24 13:03:12.06 spid8s
2012-08-24 13:03:12.06 spid8s Node:8

2012-08-24 13:03:12.06 spid8s Port: 0x000000022D5E0700 Xid Slot: 2, Wait Slot: -1, Task: 0x000000022D3AA088, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0
2012-08-24 13:03:12.06 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:7 TaskProxy0x00000005441356B0) Value:0x2d3aa088 Cost0/10000)
2012-08-24 13:03:12.06 spid8s SPID: 108 ECID: 7 Statement Type: SELECT Line #: 1
2012-08-24 13:03:12.06 spid8s Input Buf: No Event:
2012-08-24 13:03:12.06 spid8s
2012-08-24 13:03:12.06 spid8s Node:9

2012-08-24 13:03:12.06 spid8s Port: 0x0000000274320590 Xid Slot: 0, Wait Slot: 3, Task: 0x00000002B54A82C8, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0
2012-08-24 13:03:12.06 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:9 TaskProxy0x0000000544135770) Value:0xb54a82c8 Cost0/10000)
2012-08-24 13:03:13.78 spid8s Deadlock encountered .... Printing deadlock information
2012-08-24 13:03:13.78 spid8s Wait-for graph
2012-08-24 13:03:13.78 spid8s
2012-08-24 13:03:13.78 spid8s Node:1

2012-08-24 13:03:13.78 spid8s Port: 0x000000022D398830 Xid Slot: 5, Wait Slot: 1, Task: 0x000000075C80A508, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 1
2012-08-24 13:03:13.78 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:14 TaskProxy0x0000000544135950) Value:0x5c80a508 Cost20/0)
2012-08-24 13:03:13.78 spid8s SPID: 108 ECID: 14 Statement Type: SELECT Line #: 1
2012-08-24 13:03:13.78 spid8s Input Buf: No Event:
2012-08-24 13:03:13.78 spid8s
2012-08-24 13:03:13.78 spid8s Node:2

2012-08-24 13:03:13.78 spid8s Port: 0x000000022CBD0D80 Xid Slot: 3, Wait Slot: 1, Task: 0x000000000A7A8BC8, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0
2012-08-24 13:03:13.78 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:1 TaskProxy0x0000000544134F80) Value:0xa7a8bc8 Cost0/10000)
2012-08-24 13:03:13.78 spid8s SPID: 108 ECID: 1 Statement Type: SELECT Line #: 1
2012-08-24 13:03:13.78 spid8s Input Buf: No Event:
2012-08-24 13:03:13.78 spid8s
2012-08-24 13:03:13.78 spid8s Node:3

2012-08-24 13:03:13.78 spid8s Port: 0x000000022CBD0680 Xid Slot: 1, Wait Slot: -1, Task: 0x00000000057C1948, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0
2012-08-24 13:03:13.78 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:8 TaskProxy0x0000000544135710) Value:0x57c1948 Cost0/10000)
2012-08-24 13:03:13.78 spid8s SPID: 108 ECID: 8 Statement Type: SELECT Line #: 1
2012-08-24 13:03:13.78 spid8s Input Buf: No Event:
2012-08-24 13:03:13.78 spid8s
2012-08-24 13:03:13.78 spid8s Node:4

2012-08-24 13:03:13.78 spid8s Port: 0x000000022CBD0D00 Xid Slot: 0, Wait Slot: -1, Task: 0x000000022D3302C8, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0
2012-08-24 13:03:13.78 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:12 TaskProxy0x0000000544135890) Value:0x2d3302c8 Cost0/10000)
2012-08-24 13:03:13.78 spid8s SPID: 108 ECID: 12 Statement Type: SELECT Line #: 1
2012-08-24 13:03:13.78 spid8s Input Buf: No Event:
2012-08-24 13:03:13.78 spid8s
2012-08-24 13:03:13.78 spid8s Node:5

2012-08-24 13:03:13.78 spid8s Port: 0x000000022CBD0E00 Xid Slot: 2, Wait Slot: -1, Task: 0x000000075C80A2C8, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0
2012-08-24 13:03:13.78 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:10 TaskProxy0x00000005441357D0) Value:0x5c80a2c8 Cost0/10000)
2012-08-24 13:03:13.78 spid8s SPID: 108 ECID: 10 Statement Type: SELECT Line #: 1
2012-08-24 13:03:13.78 spid8s Input Buf: No Event:
2012-08-24 13:03:13.78 spid8s
2012-08-24 13:03:13.78 spid8s Node:6

2012-08-24 13:03:13.78 spid8s Port: 0x000000022CB527F0 Xid Slot: 0, Wait Slot: 5, Task: 0x000000022D330088, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0
2012-08-24 13:03:13.78 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:9 TaskProxy0x0000000544135770) Value:0x2d330088 Cost0/10000)
2012-08-24 13:03:13.78 spid8s SPID: 108 ECID: 9 Statement Type: SELECT Line #: 1
2012-08-24 13:03:13.78 spid8s Input Buf: No Event:
2012-08-24 13:03:13.78 spid8s
2012-08-24 13:03:13.78 spid8s Node:7

2012-08-24 13:03:13.78 spid8s Port: 0x000000022CBD0600 Xid Slot: 4, Wait Slot: 0, Task: 0x000000022E810088, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0
2012-08-24 13:03:13.78 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:11 TaskProxy0x0000000544135830) Value:0x2e810088 Cost0/10000)
2012-08-24 13:03:13.78 spid8s SPID: 108 ECID: 11 Statement Type: SELECT Line #: 1
2012-08-24 13:03:13.78 spid8s Input Buf: No Event:
2012-08-24 13:03:13.78 spid8s
2012-08-24 13:03:13.78 spid8s Node:8

2012-08-24 13:03:13.78 spid8s Port: 0x000000022CBD0D80 Xid Slot: 4, Wait Slot: 1, Task: 0x00000000057C0748, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0
2012-08-24 13:03:13.78 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:2 TaskProxy0x00000005441354D0) Value:0x57c0748 Cost0/10000)
2012-08-24 13:03:13.78 spid8s SPID: 108 ECID: 2 Statement Type: SELECT Line #: 1
2012-08-24 13:03:13.78 spid8s Input Buf: No Event:
2012-08-24 13:03:13.78 spid8s
2012-08-24 13:03:13.78 spid8s Node:9

2012-08-24 13:03:13.78 spid8s Port: 0x000000022CBD0D80 Xid Slot: 5, Wait Slot: 1, Task: 0x000000000A82BDC8, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0
2012-08-24 13:03:13.78 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:3 TaskProxy0x0000000544135530) Value:0xa82bdc8 Cost0/10000)
2012-08-24 13:03:13.78 spid8s SPID: 108 ECID: 3 Statement Type: SELECT Line #: 1
2012-08-24 13:03:13.78 spid8s Input Buf: No Event:
2012-08-24 13:03:15.38 spid8s Deadlock encountered .... Printing deadlock information
2012-08-24 13:03:15.38 spid8s Wait-for graph
2012-08-24 13:03:15.38 spid8s
2012-08-24 13:03:15.38 spid8s Node:1

2012-08-24 13:03:15.38 spid8s Port: 0x000000022D399D00 Xid Slot: 5, Wait Slot: 2, Task: 0x000000075C80A508, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 1
2012-08-24 13:03:15.38 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:14 TaskProxy0x0000000544135950) Value:0x5c80a508 Cost20/0)
2012-08-24 13:03:15.38 spid8s
2012-08-24 13:03:15.38 spid8s Node:2

2012-08-24 13:03:15.38 spid8s Port: 0x000000022CBD0D80 Xid Slot: 3, Wait Slot: 1, Task: 0x000000000A7A8BC8, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0
2012-08-24 13:03:15.38 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:1 TaskProxy0x0000000544134F80) Value:0xa7a8bc8 Cost0/10000)
2012-08-24 13:03:15.38 spid8s
2012-08-24 13:03:15.38 spid8s Node:3

2012-08-24 13:03:15.38 spid8s Port: 0x000000022CBD0D00 Xid Slot: 0, Wait Slot: -1, Task: 0x000000022D3302C8, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0
2012-08-24 13:03:15.38 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:12 TaskProxy0x0000000544135890) Value:0x2d3302c8 Cost0/10000)
2012-08-24 13:03:15.38 spid8s
2012-08-24 13:03:15.38 spid8s Node:4

2012-08-24 13:03:15.38 spid8s Port: 0x000000022CBD0E00 Xid Slot: 2, Wait Slot: -1, Task: 0x000000075C80A2C8, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0
2012-08-24 13:03:15.38 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:10 TaskProxy0x00000005441357D0) Value:0x5c80a2c8 Cost0/10000)
2012-08-24 13:03:15.38 spid8s
2012-08-24 13:03:15.38 spid8s Node:5

2012-08-24 13:03:15.38 spid8s Port: 0x000000022CB527F0 Xid Slot: 0, Wait Slot: 5, Task: 0x000000022D330088, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0
2012-08-24 13:03:15.38 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:9 TaskProxy0x0000000544135770) Value:0x2d330088 Cost0/10000)
2012-08-24 13:03:15.38 spid8s
2012-08-24 13:03:15.38 spid8s Node:6

2012-08-24 13:03:15.38 spid8s Port: 0x000000022CBD0600 Xid Slot: 4, Wait Slot: 0, Task: 0x000000022E810088, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0
2012-08-24 13:03:15.38 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:11 TaskProxy0x0000000544135830) Value:0x2e810088 Cost0/10000)
2012-08-24 13:03:15.38 spid8s
2012-08-24 13:03:15.38 spid8s Node:7

2012-08-24 13:03:15.38 spid8s Port: 0x000000022CBD0D80 Xid Slot: 4, Wait Slot: 1, Task: 0x00000000057C0748, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0
2012-08-24 13:03:15.38 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:2 TaskProxy0x00000005441354D0) Value:0x57c0748 Cost0/10000)
2012-08-24 13:03:15.38 spid8s
2012-08-24 13:03:15.38 spid8s Node:8

2012-08-24 13:03:15.39 spid8s Port: 0x000000022CBD0D80 Xid Slot: 5, Wait Slot: 1, Task: 0x000000000A82BDC8, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0
2012-08-24 13:03:15.39 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:3 TaskProxy0x0000000544135530) Value:0xa82bdc8 Cost0/10000)
2012-08-24 13:03:15.39 spid8s
2012-08-24 13:03:15.39 spid8s Node:9

2012-08-24 13:03:15.39 spid8s Port: 0x000000022CBD0700 Xid Slot: 2, Wait Slot: -1, Task: 0x000000000A82ABC8, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0
2012-08-24 13:03:15.39 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:7 TaskProxy0x00000005441356B0) Value:0xa82abc8 Cost0/10000)
2012-08-24 13:03:15.39 spid8s SPID: 108 ECID: 7 Statement Type: SELECT Line #: 1
2012-08-24 13:03:15.39 spid8s Input Buf: No Event:
2012-08-24 13:03:16.19 spid8s Deadlock encountered .... Printing deadlock information
2012-08-24 13:03:16.19 spid8s Wait-for graph
2012-08-24 13:03:16.19 spid8s
2012-08-24 13:03:16.19 spid8s Node:1

2012-08-24 13:03:16.19 spid8s Port: 0x000000021C695CD0 Xid Slot: 4, Wait Slot: 1, Task: 0x000000022451ABC8, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 1
2012-08-24 13:03:16.19 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:15 TaskProxy0x00000005441359B0) Value:0x2451abc8 Cost20/0)
2012-08-24 13:03:16.19 spid8s SPID: 108 ECID: 15 Statement Type: SELECT Line #: 1
2012-08-24 13:03:16.19 spid8s Input Buf: No Event:
2012-08-24 13:03:16.19 spid8s
2012-08-24 13:03:16.19 spid8s Node:2

2012-08-24 13:03:16.19 spid8s Port: 0x00000003164D5540 Xid Slot: 0, Wait Slot: 4, Task: 0x000000022451A508, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0
2012-08-24 13:03:16.19 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:7 TaskProxy0x00000005441356B0) Value:0x2451a508 Cost0/10000)
2012-08-24 13:03:16.19 spid8s SPID: 108 ECID: 7 Statement Type: SELECT Line #: 1
2012-08-24 13:03:16.19 spid8s Input Buf: No Event:
2012-08-24 13:03:16.19 spid8s
2012-08-24 13:03:16.19 spid8s Node:3

2012-08-24 13:03:16.19 spid8s Port: 0x000000022DE90600 Xid Slot: 4, Wait Slot: 0, Task: 0x000000022E2362C8, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0
2012-08-24 13:03:16.19 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:12 TaskProxy0x0000000544135890) Value:0x2e2362c8 Cost0/10000)
2012-08-24 13:03:16.19 spid8s SPID: 108 ECID: 12 Statement Type: SELECT Line #: 1
2012-08-24 13:03:16.19 spid8s Input Buf: No Event:
2012-08-24 13:03:16.19 spid8s
2012-08-24 13:03:16.19 spid8s Node:4

2012-08-24 13:03:16.19 spid8s Port: 0x000000022DE90D80 Xid Slot: 3, Wait Slot: 1, Task: 0x0000000000B24E08, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0
2012-08-24 13:03:16.19 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:1 TaskProxy0x0000000544134F80) Value:0xb24e08 Cost0/10000)
2012-08-24 13:03:16.19 spid8s SPID: 108 ECID: 1 Statement Type: SELECT Line #: 1
2012-08-24 13:03:16.19 spid8s Input Buf: No Event:
2012-08-24 13:03:16.19 spid8s
2012-08-24 13:03:16.19 spid8s Node:5

2012-08-24 13:03:16.19 spid8s Port: 0x000000022DE90D00 Xid Slot: 0, Wait Slot: -1, Task: 0x000000022451A748, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0
2012-08-24 13:03:16.19 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:10 TaskProxy0x00000005441357D0) Value:0x2451a748 Cost0/10000)
2012-08-24 13:03:16.19 spid8s SPID: 108 ECID: 10 Statement Type: SELECT Line #: 1
2012-08-24 13:03:16.19 spid8s Input Buf: No Event:
2012-08-24 13:03:16.19 spid8s
2012-08-24 13:03:16.19 spid8s Node:6

2012-08-24 13:03:16.19 spid8s Port: 0x000000022DE90D80 Xid Slot: 4, Wait Slot: 1, Task: 0x00000000050B8BC8, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0
2012-08-24 13:03:16.19 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:3 TaskProxy0x0000000544135530) Value:0x50b8bc8 Cost0/10000)
2012-08-24 13:03:16.19 spid8s SPID: 108 ECID: 3 Statement Type: SELECT Line #: 1
2012-08-24 13:03:16.19 spid8s Input Buf: No Event:
2012-08-24 13:03:16.19 spid8s
2012-08-24 13:03:16.19 spid8s Node:7

2012-08-24 13:03:16.19 spid8s Port: 0x000000022DE90D80 Xid Slot: 5, Wait Slot: 1, Task: 0x0000000004E51DC8, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0
2012-08-24 13:03:16.19 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:2 TaskProxy0x00000005441354D0) Value:0x4e51dc8 Cost0/10000)
2012-08-24 13:03:16.19 spid8s SPID: 108 ECID: 2 Statement Type: SELECT Line #: 1
2012-08-24 13:03:16.19 spid8s Input Buf: No Event:
2012-08-24 13:03:16.19 spid8s
2012-08-24 13:03:16.19 spid8s Node:8

2012-08-24 13:03:16.19 spid8s Port: 0x000000022DE90680 Xid Slot: 1, Wait Slot: -1, Task: 0x000000022E236088, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0
2012-08-24 13:03:16.19 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:9 TaskProxy0x0000000544135770) Value:0x2e236088 Cost0/10000)
2012-08-24 13:03:16.19 spid8s SPID: 108 ECID: 9 Statement Type: SELECT Line #: 1
2012-08-24 13:03:16.19 spid8s Input Buf: No Event:
2012-08-24 13:03:16.19 spid8s
2012-08-24 13:03:16.19 spid8s Node:9

2012-08-24 13:03:16.19 spid8s Port: 0x000000022DE90E00 Xid Slot: 2, Wait Slot: -1, Task: 0x000000025B02E748, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0
2012-08-24 13:03:16.19 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:11 TaskProxy0x0000000544135830) Value:0x5b02e748 Cost0/10000)
2012-08-24 13:03:16.19 spid8s SPID: 108 ECID: 11 Statement Type: SELECT Line #: 1
2012-08-24 13:03:16.19 spid8s Input Buf: No Event:
2012-08-24 13:03:16.60 spid8s Deadlock encountered .... Printing deadlock information
2012-08-24 13:03:16.60 spid8s Wait-for graph
2012-08-24 13:03:16.60 spid8s
2012-08-24 13:03:16.60 spid8s Node:1

2012-08-24 13:03:16.60 spid8s Port: 0x0000000448642170 Xid Slot: 4, Wait Slot: 2, Task: 0x000000022451ABC8, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 1
2012-08-24 13:03:16.60 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:15 TaskProxy0x00000005441359B0) Value:0x2451abc8 Cost20/0)
2012-08-24 13:03:16.60 spid8s
2012-08-24 13:03:16.60 spid8s Node:2

2012-08-24 13:03:16.60 spid8s Port: 0x00000003164D5540 Xid Slot: 0, Wait Slot: 4, Task: 0x000000022451A508, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0
2012-08-24 13:03:16.60 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:7 TaskProxy0x00000005441356B0) Value:0x2451a508 Cost0/10000)
2012-08-24 13:03:16.60 spid8s
2012-08-24 13:03:16.60 spid8s Node:3

2012-08-24 13:03:16.60 spid8s Port: 0x000000022DE90600 Xid Slot: 4, Wait Slot: 0, Task: 0x000000022E2362C8, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0
2012-08-24 13:03:16.60 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:12 TaskProxy0x0000000544135890) Value:0x2e2362c8 Cost0/10000)
2012-08-24 13:03:16.60 spid8s
2012-08-24 13:03:16.60 spid8s Node:4

2012-08-24 13:03:16.60 spid8s Port: 0x000000022DE90D80 Xid Slot: 3, Wait Slot: 1, Task: 0x0000000000B24E08, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0
2012-08-24 13:03:16.60 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:1 TaskProxy0x0000000544134F80) Value:0xb24e08 Cost0/10000)
2012-08-24 13:03:16.60 spid8s
2012-08-24 13:03:16.60 spid8s Node:5

2012-08-24 13:03:16.60 spid8s Port: 0x000000022DE90D00 Xid Slot: 0, Wait Slot: -1, Task: 0x000000022451A748, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0
2012-08-24 13:03:16.60 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:10 TaskProxy0x00000005441357D0) Value:0x2451a748 Cost0/10000)
2012-08-24 13:03:16.60 spid8s
2012-08-24 13:03:16.60 spid8s Node:6

2012-08-24 13:03:16.60 spid8s Port: 0x000000022DE90D80 Xid Slot: 4, Wait Slot: 1, Task: 0x00000000050B8BC8, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0
2012-08-24 13:03:16.60 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:3 TaskProxy0x0000000544135530) Value:0x50b8bc8 Cost0/10000)
2012-08-24 13:03:16.60 spid8s
2012-08-24 13:03:16.60 spid8s Node:7

2012-08-24 13:03:16.60 spid8s Port: 0x000000022DE90D80 Xid Slot: 5, Wait Slot: 1, Task: 0x0000000004E51DC8, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0
2012-08-24 13:03:16.60 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:2 TaskProxy0x00000005441354D0) Value:0x4e51dc8 Cost0/10000)
2012-08-24 13:03:16.60 spid8s
2012-08-24 13:03:16.60 spid8s Node:8

2012-08-24 13:03:16.60 spid8s Port: 0x000000022DE90700 Xid Slot: 2, Wait Slot: -1, Task: 0x000000025B02E508, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0
2012-08-24 13:03:16.60 spid8s ResType:ExchangeId Stype:'AND' SPID:108 BatchID:0 ECID:8 TaskProxy0x0000000544135710) Value:0x5b02e508 Cost0/10000)
2012-08-24 13:03:16.60 spid8s SPID: 108 ECID: 8 Statement Type: SELECT Line #: 1
2012-08-24 13:03:16.60 spid8s Input Buf: No Event:
2012-08-24 13:03:16.60 spid8s
2012-08-24 13:03:16.60 spid8s Node:9
Post #1349519
Posted Friday, August 24, 2012 3:30 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 5:18 PM
Points: 42,437, Visits: 35,492
Please turn traceflag 1204 off. Why is 3226 on? Do you know what it does?

Once done if you get a deadlock graph from with the output from 1222, please post that here. Traceflag 1204 is a SQL 2000 and earlier flag and the info it produces for deadlocks is near-impossible to read and missing lots of necessary info.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1349538
Posted Friday, August 24, 2012 4:40 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 5:52 PM
Points: 208, Visits: 1,020
i enabled these two flags (3226,1204) yesterday only, before that only one(1222) flag was enabled and log for yesterday was as follows :-

2012-08-23 16:05:24.17 spid8s Deadlock encountered .... Printing deadlock information
2012-08-23 16:05:24.17 spid8s Wait-for graph
2012-08-23 16:05:24.17 spid8s
2012-08-23 16:05:24.17 spid8s Node:1

2012-08-23 16:05:24.17 spid8s Port: 0x000000052A7F3B90 Xid Slot: 5, Wait Slot: 2, Task: 0x000000055A142748, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 1
2012-08-23 16:05:24.17 spid8s ResType:ExchangeId Stype:'AND' SPID:360 BatchID:0 ECID:14 TaskProxy0x00000006E7F03950) Value:0x5a142748 Cost20/0)
2012-08-23 16:05:24.17 spid8s
2012-08-23 16:05:24.17 spid8s Node:2

2012-08-23 16:05:24.17 spid8s Port: 0x00000007A1F44D80 Xid Slot: 3, Wait Slot: 1, Task: 0x00000000057C1B88, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0
2012-08-23 16:05:24.17 spid8s ResType:ExchangeId Stype:'AND' SPID:360 BatchID:0 ECID:1 TaskProxy0x00000006E7F02F80) Value:0x57c1b88 Cost0/10000)
2012-08-23 16:05:24.17 spid8s
2012-08-23 16:05:24.17 spid8s Node:3

2012-08-23 16:05:24.17 spid8s Port: 0x00000007A1F44600 Xid Slot: 4, Wait Slot: 0, Task: 0x00000007A0DD42C8, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0
2012-08-23 16:05:24.17 spid8s ResType:ExchangeId Stype:'AND' SPID:360 BatchID:0 ECID:11 TaskProxy0x00000006E7F03830) Value:0xa0dd42c8 Cost0/10000)
2012-08-23 16:05:24.17 spid8s
2012-08-23 16:05:24.17 spid8s Node:4

2012-08-23 16:05:24.17 spid8s Port: 0x00000007A1F44D00 Xid Slot: 0, Wait Slot: -1, Task: 0x00000007A2E642C8, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0
2012-08-23 16:05:24.17 spid8s ResType:ExchangeId Stype:'AND' SPID:360 BatchID:0 ECID:10 TaskProxy0x00000006E7F037D0) Value:0xa2e642c8 Cost0/10000)
2012-08-23 16:05:24.17 spid8s
2012-08-23 16:05:24.17 spid8s Node:5

2012-08-23 16:05:24.17 spid8s Port: 0x00000007A1F44E00 Xid Slot: 2, Wait Slot: -1, Task: 0x000000055A142508, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0
2012-08-23 16:05:24.17 spid8s ResType:ExchangeId Stype:'AND' SPID:360 BatchID:0 ECID:12 TaskProxy0x00000006E7F03890) Value:0x5a142508 Cost0/10000)
2012-08-23 16:05:24.17 spid8s
2012-08-23 16:05:24.17 spid8s Node:6

2012-08-23 16:05:24.17 spid8s Port: 0x00000007A1F44D80 Xid Slot: 4, Wait Slot: 1, Task: 0x0000000005AC5DC8, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0
2012-08-23 16:05:24.17 spid8s ResType:ExchangeId Stype:'AND' SPID:360 BatchID:0 ECID:3 TaskProxy0x00000006E7F03530) Value:0x5ac5dc8 Cost0/10000)
2012-08-23 16:05:24.17 spid8s
2012-08-23 16:05:24.17 spid8s Node:7

2012-08-23 16:05:24.17 spid8s Port: 0x00000007A1F44700 Xid Slot: 2, Wait Slot: -1, Task: 0x000000055A1422C8, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0
2012-08-23 16:05:24.17 spid8s ResType:ExchangeId Stype:'AND' SPID:360 BatchID:0 ECID:7 TaskProxy0x00000006E7F036B0) Value:0x5a1422c8 Cost0/10000)
2012-08-23 16:05:24.17 spid8s SPID: 360 ECID: 7 Statement Type: SELECT Line #: 1
2012-08-23 16:05:24.17 spid8s Input Buf: No Event:
2012-08-23 16:05:24.17 spid8s
2012-08-23 16:05:24.17 spid8s Node:8

2012-08-23 16:05:24.17 spid8s Port: 0x000000055B5A9060 Xid Slot: 0, Wait Slot: 5, Task: 0x00000007A2E64088, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0
2012-08-23 16:05:24.17 spid8s ResType:ExchangeId Stype:'AND' SPID:360 BatchID:0 ECID:9 TaskProxy0x00000006E7F03770) Value:0xa2e64088 Cost0/10000)
2012-08-23 16:05:24.17 spid8s
2012-08-23 16:05:24.17 spid8s Node:9

2012-08-23 16:05:24.17 spid8s Port: 0x00000007A1F44D80 Xid Slot: 5, Wait Slot: 1, Task: 0x0000000005ACE748, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0
2012-08-23 16:05:24.17 spid8s ResType:ExchangeId Stype:'AND' SPID:360 BatchID:0 ECID:2 TaskProxy0x00000006E7F034D0) Value:0x5ace748 Cost0/10000)
Post #1349573
Posted Friday, August 24, 2012 4:46 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 5:18 PM
Points: 42,437, Visits: 35,492
That is the output from traceflag 1204. Hard to interpret, missing information.

Please turn traceflag 1204 off (and why is 3226 on? do you know what it does?) and post the output that 1222 generates for a deadlock graph.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1349575
Posted Friday, August 24, 2012 4:55 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 5:52 PM
Points: 208, Visits: 1,020
I turned off them and only one trace flag is there, when i run
dbcc tracestatus command it gives result like


TraceFlag Status Global Session
1222 1 1 0


that mean only one flag is enabled now, i am waiting if any deadlock comes up again i will send you info.
Post #1349581
Posted Wednesday, August 29, 2012 4:11 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 5:52 PM
Points: 208, Visits: 1,020
HI, i found such a log related to dead lock after turning on correct trace flag.
please suggest something if you can find out actual cause of dead lock or decode the out put and the reason of it being so long out put?



deadlock-list
2012-08-29 11:46:32.54 spid37s deadlock victim=process81bb88
2012-08-29 11:46:32.54 spid37s process-list
2012-08-29 11:46:32.54 spid37s process id=process81bb88 taskpriority=0 logused=692 waitresource=PAGE: 126:1:2431515 waittime=5720 ownerId=30340257379 transactionname=DELETE lasttranstarted=2012-08-29T11:46:26.837 XDES=0x3b79b1950 lockMode=IX schedulerid=1 kpid=18972 status=suspended spid=324 sbid=0 ecid=0 priority=0 trancount=2 lastbatchstarted=2012-08-29T11:46:26.837 lastbatchcompleted=2012-08-29T11:46:26.837 clientapp=.Net SqlClient Data Provider hostname=WIMVMARCHJOR1 hostpid=1440 loginname=MetalogixPAM isolationlevel=read committed (2) xactid=30340257379 currentdb=126 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
2012-08-29 11:46:32.54 spid37s executionStack
2012-08-29 11:46:32.54 spid37s frame procname=JOurnalExchangeDB.metalogixpam.SP_EXPAM_MARKARCHIVEDMAILINDAPOOL line=14 stmtstart=468 stmtend=582 sqlhandle=0x03007e0027427f676df9af0090a000000100000000000000
2012-08-29 11:46:32.54 spid37s DELETE FROM EXCHANGEPAMDAPOOL
WHERE POOLID = @POOLID
2012-08-29 11:46:32.54 spid37s inputbuf
2012-08-29 11:46:32.54 spid37s Proc [Database Id = 126 Object Id = 1736393255]
2012-08-29 11:46:32.54 spid37s process id=processa82b708 taskpriority=0 logused=33074260 waitresource=PAGE: 126:1:3138657 waittime=4866 ownerId=30340249178 transactionname=UPDATE lasttranstarted=2012-08-29T11:46:22.220 XDES=0x357a99cd0 lockMode=U schedulerid=22 kpid=14748 status=suspended spid=244 sbid=0 ecid=0 priority=0 trancount=2 lastbatchstarted=2012-08-29T11:46:22.210 lastbatchcompleted=2012-08-29T11:46:22.210 clientapp=.Net SqlClient Data Provider hostname=WIMVMARCHJOR1 hostpid=1440 loginname=MetalogixPAM isolationlevel=read committed (2) xactid=30340249178 currentdb=126 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
2012-08-29 11:46:32.54 spid37s executionStack
2012-08-29 11:46:32.54 spid37s frame procname=JOurnalExchangeDB.metalogixpam.SP_EXPAM_MANAGEDAPOOL line=16 stmtstart=580 stmtend=808 sqlhandle=0x03007e000ea50f05e6f8af0090a000000100000000000000
2012-08-29 11:46:32.54 spid37s UPDATE EXCHANGEPAMDAPOOL SET MSGSTATUS = @MSGSTATUS WHERE JOBID = @JOBID AND (MSGSTATUS <> 3 AND MSGSTATUS <> 4)
2012-08-29 11:46:32.54 spid37s inputbuf
2012-08-29 11:46:32.54 spid37s Proc [Database Id = 126 Object Id = 84911374]
2012-08-29 11:46:32.54 spid37s resource-list
2012-08-29 11:46:32.54 spid37s pagelock fileid=1 pageid=2431515 dbid=126 objectname=JOurnalExchangeDB.metalogixpam.EXCHANGEPAMDAPOOL id=lock2f3bb8f80 mode=U associatedObjectId=72057594052149248
2012-08-29 11:46:32.54 spid37s owner-list
2012-08-29 11:46:32.54 spid37s owner id=processa82b708 mode=U
2012-08-29 11:46:32.54 spid37s waiter-list
2012-08-29 11:46:32.54 spid37s waiter id=process81bb88 mode=IX requestType=wait
2012-08-29 11:46:32.54 spid37s pagelock fileid=1 pageid=3138657 dbid=126 objectname=JOurnalExchangeDB.metalogixpam.EXCHANGEPAMDAPOOL id=lock4d39c0f00 mode=IX associatedObjectId=72057594042318848
2012-08-29 11:46:32.54 spid37s owner-list
2012-08-29 11:46:32.54 spid37s owner id=process81bb88 mode=IX
2012-08-29 11:46:32.54 spid37s waiter-list
2012-08-29 11:46:32.54 spid37s waiter id=processa82b708 mode=U requestType=wait
2012-08-29 11:46:37.56 spid17s deadlock-list
2012-08-29 11:46:37.56 spid17s deadlock victim=process4e03dc8
2012-08-29 11:46:37.56 spid17s process-list
2012-08-29 11:46:37.56 spid17s process id=process4e03dc8 taskpriority=0 logused=692 waitresource=PAGE: 126:1:5148471 waittime=6087 ownerId=30340263921 transactionname=DELETE lasttranstarted=2012-08-29T11:46:31.477 XDES=0x1c51d5460 lockMode=IX schedulerid=5 kpid=7736 status=suspended spid=491 sbid=0 ecid=0 priority=0 trancount=2 lastbatchstarted=2012-08-29T11:46:31.477 lastbatchcompleted=2012-08-29T11:46:31.477 clientapp=.Net SqlClient Data Provider hostname=WIMVMARCHJOR1 hostpid=1440 loginname=MetalogixPAM isolationlevel=read committed (2) xactid=30340263921 currentdb=126 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
2012-08-29 11:46:37.56 spid17s executionStack
2012-08-29 11:46:37.56 spid17s frame procname=JOurnalExchangeDB.metalogixpam.SP_EXPAM_MARKARCHIVEDMAILINDAPOOL line=14 stmtstart=468 stmtend=582 sqlhandle=0x03007e0027427f676df9af0090a000000100000000000000
2012-08-29 11:46:37.56 spid17s DELETE FROM EXCHANGEPAMDAPOOL
WHERE POOLID = @POOLID
2012-08-29 11:46:37.56 spid17s inputbuf
2012-08-29 11:46:37.56 spid17s Proc [Database Id = 126 Object Id = 1736393255]
2012-08-29 11:46:37.56 spid17s process id=processa82b708 taskpriority=0 logused=33077260 waitresource=PAGE: 126:1:5212618 waittime=5005 ownerId=30340249178 transactionname=UPDATE lasttranstarted=2012-08-29T11:46:22.220 XDES=0x357a99cd0 lockMode=U schedulerid=22 kpid=14748 status=suspended spid=244 sbid=0 ecid=0 priority=0 trancount=2 lastbatchstarted=2012-08-29T11:46:22.210 lastbatchcompleted=2012-08-29T11:46:22.210 clientapp=.Net SqlClient Data Provider hostname=WIMVMARCHJOR1 hostpid=1440 loginname=MetalogixPAM isolationlevel=read committed (2) xactid=30340249178 currentdb=126 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
2012-08-29 11:46:37.56 spid17s executionStack
2012-08-29 11:46:37.56 spid17s frame procname=JOurnalExchangeDB.metalogixpam.SP_EXPAM_MANAGEDAPOOL line=16 stmtstart=580 stmtend=808 sqlhandle=0x03007e000ea50f05e6f8af0090a000000100000000000000
2012-08-29 11:46:37.56 spid17s UPDATE EXCHANGEPAMDAPOOL SET MSGSTATUS = @MSGSTATUS WHERE JOBID = @JOBID AND (MSGSTATUS <> 3 AND MSGSTATUS <> 4)
2012-08-29 11:46:37.56 spid17s inputbuf
2012-08-29 11:46:37.56 spid17s Proc [Database Id = 126 Object Id = 84911374]
2012-08-29 11:46:37.56 spid17s resource-list
2012-08-29 11:46:37.56 spid17s pagelock fileid=1 pageid=5148471 dbid=126 objectname=JOurnalExchangeDB.metalogixpam.EXCHANGEPAMDAPOOL id=lock2e64e1700 mode=U associatedObjectId=72057594052149248
2012-08-29 11:46:37.56 spid17s owner-list
2012-08-29 11:46:37.56 spid17s owner id=processa82b708 mode=U
2012-08-29 11:46:37.56 spid17s waiter-list
2012-08-29 11:46:37.56 spid17s waiter id=process4e03dc8 mode=IX requestType=wait
2012-08-29 11:46:37.56 spid17s pagelock fileid=1 pageid=5212618 dbid=126 objectname=JOurnalExchangeDB.metalogixpam.EXCHANGEPAMDAPOOL id=lockc635f280 mode=IX associatedObjectId=72057594042318848
2012-08-29 11:46:37.56 spid17s owner-list
2012-08-29 11:46:37.56 spid17s owner id=process4e03dc8 mode=IX
2012-08-29 11:46:37.56 spid17s waiter-list
2012-08-29 11:46:37.56 spid17s waiter id=processa82b708 mode=U requestType=wait
2012-08-29 11:46:40.08 spid18s deadlock-list
2012-08-29 11:46:40.08 spid18s deadlock victim=processa844748
2012-08-29 11:46:40.08 spid18s process-list
2012-08-29 11:46:40.08 spid18s process id=processa844748 taskpriority=0 logused=692 waitresource=PAGE: 126:1:5148471 waittime=6097 ownerId=30340266774 transactionname=DELETE lasttranstarted=2012-08-29T11:46:33.980 XDES=0x64ce5f950 lockMode=IX schedulerid=23 kpid=21332 status=suspended spid=392 sbid=0 ecid=0 priority=0 trancount=2 lastbatchstarted=2012-08-29T11:46:33.980 lastbatchcompleted=2012-08-29T11:46:33.980 clientapp=.Net SqlClient Data Provider hostname=WIMVMARCHJOR1 hostpid=1440 loginname=MetalogixPAM isolationlevel=read committed (2) xactid=30340266774 currentdb=126 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
2012-08-29 11:46:40.08 spid18s executionStack
2012-08-29 11:46:40.08 spid18s frame procname=JOurnalExchangeDB.metalogixpam.SP_EXPAM_MARKARCHIVEDMAILINDAPOOL line=14 stmtstart=468 stmtend=582 sqlhandle=0x03007e0027427f676df9af0090a000000100000000000000
2012-08-29 11:46:40.08 spid18s DELETE FROM EXCHANGEPAMDAPOOL
WHERE POOLID = @POOLID
2012-08-29 11:46:40.08 spid18s inputbuf
2012-08-29 11:46:40.08 spid18s Proc [Database Id = 126 Object Id = 1736393255]
2012-08-29 11:46:40.08 spid18s process id=process81bb88 taskpriority=0 logused=692 waitresource=PAGE: 126:1:5148471 waittime=7498 ownerId=30340265361 transactionname=DELETE lasttranstarted=2012-08-29T11:46:32.567 XDES=0x3b79b1950 lockMode=IX schedulerid=1 kpid=18972 status=suspended spid=324 sbid=0 ecid=0 priority=0 trancount=2 lastbatchstarted=2012-08-29T11:46:32.567 lastbatchcompleted=2012-08-29T11:46:32.563 clientapp=.Net SqlClient Data Provider hostname=WIMVMARCHJOR1 hostpid=1440 loginname=MetalogixPAM isolationlevel=read committed (2) xactid=30340265361 currentdb=126 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
2012-08-29 11:46:40.08 spid18s executionStack
2012-08-29 11:46:40.08 spid18s frame procname=JOurnalExchangeDB.metalogixpam.SP_EXPAM_MARKARCHIVEDMAILINDAPOOL line=14 stmtstart=468 stmtend=582 sqlhandle=0x03007e0027427f676df9af0090a000000100000000000000
2012-08-29 11:46:40.08 spid18s DELETE FROM EXCHANGEPAMDAPOOL
WHERE POOLID = @POOLID
2012-08-29 11:46:40.08 spid18s inputbuf
2012-08-29 11:46:40.08 spid18s Proc [Database Id = 126 Object Id = 1736393255]
2012-08-29 11:46:40.08 spid18s process id=processa82b708 taskpriority=0 logused=33085900 waitresource=PAGE: 126:1:3119884 waittime=2510 ownerId=30340249178 transactionname=UPDATE lasttranstarted=2012-08-29T11:46:22.220 XDES=0x357a99cd0 lockMode=U schedulerid=22 kpid=14748 status=suspended spid=244 sbid=0 ecid=0 priority=0 trancount=2 lastbatchstarted=2012-08-29T11:46:22.210 lastbatchcompleted=2012-08-29T11:46:22.210 clientapp=.Net SqlClient Data Provider hostname=WIMVMARCHJOR1 hostpid=1440 loginname=MetalogixPAM isolationlevel=read committed (2) xactid=30340249178 currentdb=126 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
2012-08-29 11:46:40.08 spid18s executionStack
2012-08-29 11:46:40.08 spid18s frame procname=JOurnalExchangeDB.metalogixpam.SP_EXPAM_MANAGEDAPOOL line=16 stmtstart=580 stmtend=808 sqlhandle=0x03007e000ea50f05e6f8af0090a000000100000000000000
2012-08-29 11:46:40.08 spid18s UPDATE EXCHANGEPAMDAPOOL SET MSGSTATUS = @MSGSTATUS WHERE JOBID = @JOBID AND (MSGSTATUS <> 3 AND MSGSTATUS <> 4)
2012-08-29 11:46:40.08 spid18s inputbuf
2012-08-29 11:46:40.08 spid18s Proc [Database Id = 126 Object Id = 84911374]
2012-08-29 11:46:40.08 spid18s resource-list
2012-08-29 11:46:40.08 spid18s pagelock fileid=1 pageid=5148471 dbid=126 objectname=JOurnalExchangeDB.metalogixpam.EXCHANGEPAMDAPOOL id=lock2e64e1700 mode=U associatedObjectId=72057594052149248
2012-08-29 11:46:40.08 spid18s owner-list
2012-08-29 11:46:40.08 spid18s waiter-list
2012-08-29 11:46:40.08 spid18s waiter id=processa844748 mode=IX requestType=wait
2012-08-29 11:46:40.08 spid18s pagelock fileid=1 pageid=5148471 dbid=126 objectname=JOurnalExchangeDB.metalogixpam.EXCHANGEPAMDAPOOL id=lock2e64e1700 mode=U associatedObjectId=72057594052149248
2012-08-29 11:46:40.08 spid18s owner-list
2012-08-29 11:46:40.08 spid18s owner id=processa82b708 mode=U
2012-08-29 11:46:40.08 spid18s waiter-list
2012-08-29 11:46:40.08 spid18s waiter id=process81bb88 mode=IX requestType=wait
2012-08-29 11:46:40.08 spid18s pagelock fileid=1 pageid=3119884 dbid=126 objectname=JOurnalExchangeDB.metalogixpam.EXCHANGEPAMDAPOOL id=lock1384e7d80 mode=IX associatedObjectId=72057594042318848
2012-08-29 11:46:40.08 spid18s owner-list
2012-08-29 11:46:40.08 spid18s owner id=processa844748 mode=IX
2012-08-29 11:46:40.08 spid18s waiter-list
2012-08-29 11:46:40.08 spid18s waiter id=processa82b708 mode=U requestType=wait
2012-08-29 11:46:41.34 spid25s deadlock-list
2012-08-29 11:46:41.34 spid25s deadlock victim=process81bb88
2012-08-29 11:46:41.34 spid25s process-list
2012-08-29 11:46:41.34 spid25s process id=process81bb88 taskpriority=0 logused=692 waitresource=PAGE: 126:1:5148471 waittime=8761 ownerId=30340265361 transactionname=DELETE lasttranstarted=2012-08-29T11:46:32.567 XDES=0x3b79b1950 lockMode=IX schedulerid=1 kpid=18972 status=suspended spid=324 sbid=0 ecid=0 priority=0 trancount=2 lastbatchstarted=2012-08-29T11:46:32.567 lastbatchcompleted=2012-08-29T11:46:32.563 clientapp=.Net SqlClient Data Provider hostname=WIMVMARCHJOR1 hostpid=1440 loginname=MetalogixPAM isolationlevel=read committed (2) xactid=30340265361 currentdb=126 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
2012-08-29 11:46:41.34 spid25s executionStack
2012-08-29 11:46:41.34 spid25s frame procname=JOurnalExchangeDB.metalogixpam.SP_EXPAM_MARKARCHIVEDMAILINDAPOOL line=14 stmtstart=468 stmtend=582 sqlhandle=0x03007e0027427f676df9af0090a000000100000000000000
2012-08-29 11:46:41.34 spid25s DELETE FROM EXCHANGEPAMDAPOOL
WHERE POOLID = @POOLID
2012-08-29 11:46:41.34 spid25s inputbuf
2012-08-29 11:46:41.34 spid25s Proc [Database Id = 126 Object Id = 1736393255]
2012-08-29 11:46:41.34 spid25s process id=processa82b708 taskpriority=0 logused=33089380 waitresource=PAGE: 126:1:5216891 waittime=1262 ownerId=30340249178 transactionname=UPDATE lasttranstarted=2012-08-29T11:46:22.220 XDES=0x357a99cd0 lockMode=U schedulerid=22 kpid=14748 status=suspended spid=244 sbid=0 ecid=0 priority=0 trancount=2 lastbatchstarted=2012-08-29T11:46:22.210 lastbatchcompleted=2012-08-29T11:46:22.210 clientapp=.Net SqlClient Data Provider hostname=WIMVMARCHJOR1 hostpid=1440 loginname=MetalogixPAM isolationlevel=read committed (2) xactid=30340249178 currentdb=126 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
2012-08-29 11:46:41.34 spid25s executionStack
2012-08-29 11:46:41.34 spid25s frame procname=JOurnalExchangeDB.metalogixpam.SP_EXPAM_MANAGEDAPOOL line=16 stmtstart=580 stmtend=808 sqlhandle=0x03007e000ea50f05e6f8af0090a000000100000000000000
2012-08-29 11:46:41.34 spid25s UPDATE EXCHANGEPAMDAPOOL SET MSGSTATUS = @MSGSTATUS WHERE JOBID = @JOBID AND (MSGSTATUS <> 3 AND MSGSTATUS <> 4)
2012-08-29 11:46:41.34 spid25s inputbuf
2012-08-29 11:46:41.34 spid25s Proc [Database Id = 126 Object Id = 84911374]
2012-08-29 11:46:41.34 spid25s resource-list
2012-08-29 11:46:41.34 spid25s pagelock fileid=1 pageid=5148471 dbid=126 objectname=JOurnalExchangeDB.metalogixpam.EXCHANGEPAMDAPOOL id=lock2e64e1700 mode=U associatedObjectId=72057594052149248
2012-08-29 11:46:41.34 spid25s owner-list
2012-08-29 11:46:41.34 spid25s owner id=processa82b708 mode=U
2012-08-29 11:46:41.34 spid25s waiter-list
2012-08-29 11:46:41.34 spid25s waiter id=process81bb88 mode=IX requestType=wait
2012-08-29 11:46:41.34 spid25s pagelock fileid=1 pageid=5216891 dbid=126 objectname=JOurnalExchangeDB.metalogixpam.EXCHANGEPAMDAPOOL id=lock49aa90580 mode=IX associatedObjectId=72057594042318848
2012-08-29 11:46:41.34 spid25s owner-list
2012-08-29 11:46:41.34 spid25s owner id=process81bb88 mode=IX
2012-08-29 11:46:41.34 spid25s waiter-list
2012-08-29 11:46:41.34 spid25s waiter id=processa82b708 mode=U requestType=wait
2012-08-29 11:46:41.97 spid17s deadlock-list
2012-08-29 11:46:41.97 spid17s deadlock victim=process5acf4c8
2012-08-29 11:46:41.97 spid17s process-list
2012-08-29 11:46:41.97 spid17s process id=process5acf4c8 taskpriority=0 logused=692 waitresource=PAGE: 126:1:2431514 waittime=17391 ownerId=30340252457 transactionname=DELETE lasttranstarted=2012-08-29T11:46:24.580 XDES=0x13720f250 lockMode=IX schedulerid=16 kpid=20276 status=suspended spid=138 sbid=0 ecid=0 priority=0 trancount=2 lastbatchstarted=2012-08-29T11:46:24.580 lastbatchcompleted=2012-08-29T11:46:24.580 clientapp=.Net SqlClient Data Provider hostname=WIMVMARCHJOR1 hostpid=1440 loginname=MetalogixPAM isolationlevel=read committed (2) xactid=30340252457 currentdb=126 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
2012-08-29 11:46:41.97 spid17s executionStack
2012-08-29 11:46:41.97 spid17s frame procname=JOurnalExchangeDB.metalogixpam.SP_EXPAM_MARKARCHIVEDMAILINDAPOOL line=14 stmtstart=468 stmtend=582 sqlhandle=0x03007e0027427f676df9af0090a000000100000000000000
2012-08-29 11:46:41.97 spid17s DELETE FROM EXCHANGEPAMDAPOOL
WHERE POOLID = @POOLID
2012-08-29 11:46:41.97 spid17s inputbuf
2012-08-29 11:46:41.97 spid17s Proc [Database Id = 126 Object Id = 1736393255]
2012-08-29 11:46:41.97 spid17s process id=processa82b708 taskpriority=0 logused=33099220 waitresource=PAGE: 126:1:3139426 waittime=638 ownerId=30340249178 transactionname=UPDATE lasttranstarted=2012-08-29T11:46:22.220 XDES=0x357a99cd0 lockMode=U schedulerid=22 kpid=14748 status=suspended spid=244 sbid=0 ecid=0 priority=0 trancount=2 lastbatchstarted=2012-08-29T11:46:22.210 lastbatchcompleted=2012-08-29T11:46:22.210 clientapp=.Net SqlClient Data Provider hostname=WIMVMARCHJOR1 hostpid=1440 loginname=MetalogixPAM isolationlevel=read committed (2) xactid=30340249178 currentdb=126 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
2012-08-29 11:46:41.97 spid17s executionStack
2012-08-29 11:46:41.97 spid17s frame procname=JOurnalExchangeDB.metalogixpam.SP_EXPAM_MANAGEDAPOOL line=16 stmtstart=580 stmtend=808 sqlhandle=0x03007e000ea50f05e6f8af0090a000000100000000000000
2012-08-29 11:46:41.97 spid17s UPDATE EXCHANGEPAMDAPOOL SET MSGSTATUS = @MSGSTATUS WHERE JOBID = @JOBID AND (MSGSTATUS <> 3 AND MSGSTATUS <> 4)
2012-08-29 11:46:41.97 spid17s inputbuf
2012-08-29 11:46:41.97 spid17s Proc [Database Id = 126 Object Id = 84911374]
2012-08-29 11:46:41.97 spid17s resource-list
2012-08-29 11:46:41.97 spid17s pagelock fileid=1 pageid=2431514 dbid=126 objectname=JOurnalExchangeDB.metalogixpam.EXCHANGEPAMDAPOOL id=lock2e6517680 mode=U associatedObjectId=72057594052149248
2012-08-29 11:46:41.97 spid17s owner-list
2012-08-29 11:46:41.97 spid17s owner id=processa82b708 mode=U
2012-08-29 11:46:41.97 spid17s waiter-list
2012-08-29 11:46:41.97 spid17s waiter id=process5acf4c8 mode=IX requestType=wait
2012-08-29 11:46:41.97 spid17s pagelock fileid=1 pageid=3139426 dbid=126 objectname=JOurnalExchangeDB.metalogixpam.EXCHANGEPAMDAPOOL id=lock2e67de900 mode=IX associatedObjectId=72057594042318848
2012-08-29 11:46:41.97 spid17s owner-list
2012-08-29 11:46:41.97 spid17s owner id=process5acf4c8 mode=IX
2012-08-29 11:46:41.97 spid17s waiter-list
2012-08-29 11:46:41.97 spid17s waiter id=processa82b708 mode=U requestType=wait
2012-08-29 11:46:42.28 spid18s deadlock-list
2012-08-29 11:46:42.28 spid18s deadlock victim=process4de8988
2012-08-29 11:46:42.28 spid18s process-list
2012-08-29 11:46:42.28 spid18s process id=process4de8988 taskpriority=0 logused=692 waitresource=PAGE: 126:1:2431514 waittime=11874 ownerId=30340262531 transactionname=DELETE lasttranstarted=2012-08-29T11:46:30.403 XDES=0x727af1950 lockMode=IX schedulerid=4 kpid=5044 status=suspended spid=489 sbid=0 ecid=0 priority=0 trancount=2 lastbatchstarted=2012-08-29T11:46:30.403 lastbatchcompleted=2012-08-29T11:46:30.400 clientapp=.Net SqlClient Data Provider hostname=WIMVMARCHJOR1 hostpid=1440 loginname=MetalogixPAM isolationlevel=read committed (2) xactid=30340262531 currentdb=126 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
2012-08-29 11:46:42.28 spid18s executionStack
2012-08-29 11:46:42.28 spid18s frame procname=JOurnalExchangeDB.metalogixpam.SP_EXPAM_MARKARCHIVEDMAILINDAPOOL line=14 stmtstart=468 stmtend=582 sqlhandle=0x03007e0027427f676df9af0090a000000100000000000000
2012-08-29 11:46:42.28 spid18s DELETE FROM EXCHANGEPAMDAPOOL
WHERE POOLID = @POOLID
2012-08-29 11:46:42.28 spid18s inputbuf
2012-08-29 11:46:42.28 spid18s Proc [Database Id = 126 Object Id = 1736393255]
2012-08-29 11:46:42.28 spid18s process id=processa82b708 taskpriority=0 logused=33104020 waitresource=PAGE: 126:1:5218673 waittime=309 ownerId=30340249178 transactionname=UPDATE lasttranstarted=2012-08-29T11:46:22.220 XDES=0x357a99cd0 lockMode=U schedulerid=22 kpid=14748 status=suspended spid=244 sbid=0 ecid=0 priority=0 trancount=2 lastbatchstarted=2012-08-29T11:46:22.210 lastbatchcompleted=2012-08-29T11:46:22.210 clientapp=.Net SqlClient Data Provider hostname=WIMVMARCHJOR1 hostpid=1440 loginname=MetalogixPAM isolationlevel=read committed (2) xactid=30340249178 currentdb=126 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
2012-08-29 11:46:42.28 spid18s executionStack
2012-08-29 11:46:42.28 spid18s frame procname=JOurnalExchangeDB.metalogixpam.SP_EXPAM_MANAGEDAPOOL line=16 stmtstart=580 stmtend=808 sqlhandle=0x03007e000ea50f05e6f8af0090a000000100000000000000
2012-08-29 11:46:42.28 spid18s UPDATE EXCHANGEPAMDAPOOL SET MSGSTATUS = @MSGSTATUS WHERE JOBID = @JOBID AND (MSGSTATUS <> 3 AND MSGSTATUS <> 4)
2012-08-29 11:46:42.28 spid18s inputbuf
2012-08-29 11:46:42.28 spid18s Proc [Database Id = 126 Object Id = 84911374]
2012-08-29 11:46:42.28 spid18s resource-list
2012-08-29 11:46:42.28 spid18s pagelock fileid=1 pageid=2431514 dbid=126 objectname=JOurnalExchangeDB.metalogixpam.EXCHANGEPAMDAPOOL id=lock2e6517680 mode=U associatedObjectId=72057594052149248
2012-08-29 11:46:42.28 spid18s owner-list
2012-08-29 11:46:42.28 spid18s owner id=processa82b708 mode=U
2012-08-29 11:46:42.28 spid18s waiter-list
2012-08-29 11:46:42.28 spid18s waiter id=process4de8988 mode=IX requestType=wait
2012-08-29 11:46:42.28 spid18s pagelock fileid=1 pageid=5218673 dbid=126 objectname=JOurnalExchangeDB.metalogixpam.EXCHANGEPAMDAPOOL id=lockb654ad00 mode=IX associatedObjectId=72057594042318848
2012-08-29 11:46:42.28 spid18s owner-list
2012-08-29 11:46:42.28 spid18s owner id=process4de8988 mode=IX
2012-08-29 11:46:42.28 spid18s waiter-list
2012-08-29 11:46:42.28 spid18s waiter id=processa82b708 mode=U requestType=wait
2012-08-29 11:46:42.44 spid37s deadlock-list
2012-08-29 11:46:42.44 spid37s deadlock victim=process5ac5708
2012-08-29 11:46:42.44 spid37s process-list
2012-08-29 11:46:42.44 spid37s process id=process5ac5708 taskpriority=0 logused=692 waitresource=PAGE: 126:1:2431514 waittime=7412 ownerId=30340268315 transactionname=DELETE lasttranstarted=2012-08-29T11:46:35.033 XDES=0x555c61950 lockMode=IX schedulerid=15 kpid=8744 status=suspended spid=500 sbid=0 ecid=0 priority=0 trancount=2 lastbatchstarted=2012-08-29T11:46:35.033 lastbatchcompleted=2012-08-29T11:46:35.033 clientapp=.Net SqlClient Data Provider hostname=WIMVMARCHJOR1 hostpid=1440 loginname=MetalogixPAM isolationlevel=read committed (2) xactid=30340268315 currentdb=126 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
2012-08-29 11:46:42.44 spid37s executionStack
2012-08-29 11:46:42.44 spid37s frame procname=JOurnalExchangeDB.metalogixpam.SP_EXPAM_MARKARCHIVEDMAILINDAPOOL line=14 stmtstart=468 stmtend=582 sqlhandle=0x03007e0027427f676df9af0090a000000100000000000000
2012-08-29 11:46:42.44 spid37s DELETE FROM EXCHANGEPAMDAPOOL
WHERE POOLID = @POOLID
2012-08-29 11:46:42.44 spid37s inputbuf
2012-08-29 11:46:42.44 spid37s Proc [Database Id = 126 Object Id = 1736393255]
2012-08-29 11:46:42.44 spid37s process id=processa82b708 taskpriority=0 logused=33108100 waitresource=PAGE: 126:1:3139461 waittime=155 ownerId=30340249178 transactionname=UPDATE lasttranstarted=2012-08-29T11:46:22.220 XDES=0x357a99cd0 lockMode=U schedulerid=22 kpid=14748 status=suspended spid=244 sbid=0 ecid=0 priority=0 trancount=2 lastbatchstarted=2012-08-29T11:46:22.210 lastbatchcompleted=2012-08-29T11:46:22.210 clientapp=.Net SqlClient Data Provider hostname=WIMVMARCHJOR1 hostpid=1440 loginname=MetalogixPAM isolationlevel=read committed (2) xactid=30340249178 currentdb=126 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
2012-08-29 11:46:42.44 spid37s executionStack
2012-08-29 11:46:42.44 spid37s frame procname=JOurnalExchangeDB.metalogixpam.SP_EXPAM_MANAGEDAPOOL line=16 stmtstart=580 stmtend=808 sqlhandle=0x03007e000ea50f05e6f8af0090a000000100000000000000
2012-08-29 11:46:42.44 spid37s UPDATE EXCHANGEPAMDAPOOL SET MSGSTATUS = @MSGSTATUS WHERE JOBID = @JOBID AND (MSGSTATUS <> 3 AND MSGSTATUS <> 4)
2012-08-29 11:46:42.44 spid37s inputbuf
2012-08-29 11:46:42.44 spid37s Proc [Database Id = 126 Object Id = 84911374]
2012-08-29 11:46:42.44 spid37s resource-list
2012-08-29 11:46:42.44 spid37s pagelock fileid=1 pageid=2431514 dbid=126 objectname=JOurnalExchangeDB.metalogixpam.EXCHANGEPAMDAPOOL id=lock2e6517680 mode=U associatedObjectId=72057594052149248
2012-08-29 11:46:42.44 spid37s owner-list
2012-08-29 11:46:42.44 spid37s owner id=processa82b708 mode=U
2012-08-29 11:46:42.44 spid37s waiter-list
2012-08-29 11:46:42.44 spid37s waiter id=process5ac5708 mode=IX requestType=wait
2012-08-29 11:46:42.44 spid37s pagelock fileid=1 pageid=3139461 dbid=126 objectname=JOurnalExchangeDB.metalogixpam.EXCHANGEPAMDAPOOL id=lock67c0d0880 mode=IX associatedObjectId=72057594042318848
2012-08-29 11:46:42.44 spid37s owner-list
2012-08-29 11:46:42.44 spid37s owner id=process5ac5708 mode=IX
2012-08-29 11:46:42.44 spid37s waiter-list
2012-08-29 11:46:42.44 spid37s waiter id=processa82b708 mode=U requestType=wait
2012-08-29 11:46:42.55 spid29s deadlock-list
2012-08-29 11:46:42.55 spid29s deadlock victim=process4e1d4c8
2012-08-29 11:46:42.55 spid29s process-list
2012-08-29 11:46:42.55 spid29s process id=process4e1d4c8 taskpriority=0 logused=692 waitresource=PAGE: 126:1:3994893 waittime=14794 ownerId=30340259260 transactionname=DELETE lasttranstarted=2012-08-29T11:46:27.760 XDES=0x6186de3b0 lockMode=IX schedulerid=6 kpid=13724 status=suspended spid=481 sbid=0 ecid=0 priority=0 trancount=2 lastbatchstarted=2012-08-29T11:46:27.760 lastbatchcompleted=2012-08-29T11:46:27.757 clientapp=.Net SqlClient Data Provider hostname=WIMVMARCHJOR1 hostpid=1440 loginname=MetalogixPAM isolationlevel=read committed (2) xactid=30340259260 currentdb=126 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
2012-08-29 11:46:42.55 spid29s executionStack
2012-08-29 11:46:42.55 spid29s frame procname=JOurnalExchangeDB.metalogixpam.SP_EXPAM_MARKARCHIVEDMAILINDAPOOL line=14 stmtstart=468 stmtend=582 sqlhandle=0x03007e0027427f676df9af0090a000000100000000000000
2012-08-29 11:46:42.55 spid29s DELETE FROM EXCHANGEPAMDAPOOL
WHERE POOLID = @POOLID
2012-08-29 11:46:42.55 spid29s inputbuf
2012-08-29 11:46:42.55 spid29s Proc [Database Id = 126 Object Id = 1736393255]
2012-08-29 11:46:42.55 spid29s process id=processa82b708 taskpriority=0 logused=33112420 waitresource=PAGE: 126:1:3139730 waittime=108 ownerId=30340249178 transactionname=UPDATE lasttranstarted=2012-08-29T11:46:22.220 XDES=0x357a99cd0 lockMode=U schedulerid=22 kpid=14748 status=suspended spid=244 sbid=0 ecid=0 priority=0 trancount=2 lastbatchstarted=2012-08-29T11:46:22.210 lastbatchcompleted=2012-08-29T11:46:22.210 clientapp=.Net SqlClient Data Provider hostname=WIMVMARCHJOR1 hostpid=1440 loginname=MetalogixPAM isolationlevel=read committed (2) xactid=30340249178 currentdb=126 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
2012-08-29 11:46:42.55 spid29s executionStack
2012-08-29 11:46:42.55 spid29s frame procname=JOurnalExchangeDB.metalogixpam.SP_EXPAM_MANAGEDAPOOL line=16 stmtstart=580 stmtend=808 sqlhandle=0x03007e000ea50f05e6f8af0090a000000100000000000000
2012-08-29 11:46:42.55 spid29s UPDATE EXCHANGEPAMDAPOOL SET MSGSTATUS = @MSGSTATUS WHERE JOBID = @JOBID AND (MSGSTATUS <> 3 AND MSGSTATUS <> 4)
2012-08-29 11:46:42.55 spid29s inputbuf
2012-08-29 11:46:42.55 spid29s Proc [Database Id = 126 Object Id = 84911374]
2012-08-29 11:46:42.55 spid29s resource-list
2012-08-29 11:46:42.55 spid29s pagelock fileid=1 pageid=3994893 dbid=126 objectname=JOurnalExchangeDB.metalogixpam.EXCHANGEPAMDAPOOL id=lock2e6971f80 mode=U associatedObjectId=72057594052149248
2012-08-29 11:46:42.55 spid29s owner-list
2012-08-29 11:46:42.55 spid29s owner id=processa82b708 mode=U
2012-08-29 11:46:42.55 spid29s waiter-list
2012-08-29 11:46:42.55 spid29s waiter id=process4e1d4c8 mode=IX requestType=wait
2012-08-29 11:46:42.55 spid29s pagelock fileid=1 pageid=3139730 dbid=126 objectname=JOurnalExchangeDB.metalogixpam.EXCHANGEPAMDAPOOL id=lock20de94600 mode=IX associatedObjectId=72057594042318848
2012-08-29 11:46:42.55 spid29s owner-list
2012-08-29 11:46:42.55 spid29s owner id=process4e1d4c8 mode=IX
2012-08-29 11:46:42.55 spid29s waiter-list
2012-08-29 11:46:42.55 spid29s waiter id=processa82b708 mode=U requestType=wait
2012-08-29 11:46:42.66 spid24s deadlock-list
2012-08-29 11:46:42.66 spid24s deadlock victim=process5085948
2012-08-29 11:46:42.66 spid24s process-list
2012-08-29 11:46:42.66 spid24s process id=process5085948 taskpriority=0 logused=692 waitresource=PAGE: 126:1:3994893 waittime=12722 ownerId=30340261323 transactionname=DELETE lasttranstarted=2012-08-29T11:46:29.930 XDES=0x3b8f5ee80 lockMode=IX schedulerid=10 kpid=312 status=suspended spid=488 sbid=0 ecid=0 priority=0 trancount=2 lastbatchstarted=2012-08-29T11:46:29.930 lastbatchcompleted=2012-08-29T11:46:29.927 clientapp=.Net SqlClient Data Provider hostname=WIMVMARCHJOR1 hostpid=1440 loginname=MetalogixPAM isolationlevel=read committed (2) xactid=30340261323 currentdb=126 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
2012-08-29 11:46:42.66 spid24s executionStack
2012-08-29 11:46:42.66 spid24s frame procname=JOurnalExchangeDB.metalogixpam.SP_EXPAM_MARKARCHIVEDMAILINDAPOOL line=14 stmtstart=468 stmtend=582 sqlhandle=0x03007e0027427f676df9af0090a000000100000000000000
2012-08-29 11:46:42.66 spid24s DELETE FROM EXCHANGEPAMDAPOOL
WHERE POOLID = @POOLID
2012-08-29 11:46:42.66 spid24s inputbuf
2012-08-29 11:46:42.66 spid24s Proc [Database Id = 126 Object Id = 1736393255]
2012-08-29 11:46:42.66 spid24s process id=processa82b708 taskpriority=0 logused=33117820 waitresource=PAGE: 126:1:5219360 waittime=107 ownerId=30340249178 transactionname=UPDATE lasttranstarted=2012-08-29T11:46:22.220 XDES=0x357a99cd0 lockMode=U schedulerid=22 kpid=14748 status=suspended spid=244 sbid=0 ecid=0 priority=0 trancount=2 lastbatchstarted=2012-08-29T11:46:22.210 lastbatchcompleted=2012-08-29T11:46:22.210 clientapp=.Net SqlClient Data Provider hostname=WIMVMARCHJOR1 hostpid=1440 loginname=MetalogixPAM isolationlevel=read committed (2) xactid=30340249178 currentdb=126 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
2012-08-29 11:46:42.66 spid24s executionStack
2012-08-29 11:46:42.66 spid24s frame procname=JOurnalExchangeDB.metalogixpam.SP_EXPAM_MANAGEDAPOOL line=16 stmtstart=580 stmtend=808 sqlhandle=0x03007e000ea50f05e6f8af0090a000000100000000000000
2012-08-29 11:46:42.66 spid24s UPDATE EXCHANGEPAMDAPOOL SET MSGSTATUS = @MSGSTATUS WHERE JOBID = @JOBID AND (MSGSTATUS <> 3 AND MSGSTATUS <> 4)
2012-08-29 11:46:42.66 spid24s inputbuf
2012-08-29 11:46:42.66 spid24s Proc [Database Id = 126 Object Id = 84911374]
2012-08-29 11:46:42.66 spid24s resource-list
2012-08-29 11:46:42.66 spid24s pagelock fileid=1 pageid=3994893 dbid=126 objectname=JOurnalExchangeDB.metalogixpam.EXCHANGEPAMDAPOOL id=lock2e6971f80 mode=U associatedObjectId=72057594052149248
2012-08-29 11:46:42.66 spid24s owner-list
2012-08-29 11:46:42.66 spid24s owner id=processa82b708 mode=U
2012-08-29 11:46:42.66 spid24s waiter-list
2012-08-29 11:46:42.66 spid24s waiter id=process5085948 mode=IX requestType=wait
2012-08-29 11:46:42.66 spid24s pagelock fileid=1 pageid=5219360 dbid=126 objectname=JOurnalExchangeDB.metalogixpam.EXCHANGEPAMDAPOOL id=locka9479980 mode=IX associatedObjectId=72057594042318848
2012-08-29 11:46:42.66 spid24s owner-list
2012-08-29 11:46:42.66 spid24s owner id=process5085948 mode=IX
2012-08-29 11:46:42.66 spid24s waiter-list
2012-08-29 11:46:42.66 spid24s waiter id=processa82b708 mode=U requestType=wait
2012-08-29 11:46:42.77 spid28s deadlock-list
2012-08-29 11:46:42.77 spid28s deadlock victim=processb2ee08
2012-08-29 11:46:42.77 spid28s process-list
2012-08-29 11:46:42.77 spid28s process id=processb2ee08 taskpriority=0 logused=692 waitresource=PAGE: 126:1:3994893 waittime=10797 ownerId=30340264301 transactionname=DELETE lasttranstarted=2012-08-29T11:46:31.977 XDES=0x32a4fb950 lockMode=IX schedulerid=3 kpid=6656 status=suspended spid=493 sbid=0 ecid=0 priority=0 trancount=2 lastbatchstarted=2012-08-29T11:46:31.977 lastbatchcompleted=2012-08-29T11:46:31.977 clientapp=.Net SqlClient Data Provider hostname=WIMVMARCHJOR1 hostpid=1440 loginname=MetalogixPAM isolationlevel=read committed (2) xactid=30340264301 currentdb=126 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
2012-08-29 11:46:42.77 spid28s executionStack
2012-08-29 11:46:42.77 spid28s frame procname=JOurnalExchangeDB.metalogixpam.SP_EXPAM_MARKARCHIVEDMAILINDAPOOL line=14 stmtstart=468 stmtend=582 sqlhandle=0x03007e0027427f676df9af0090a000000100000000000000
2012-08-29 11:46:42.77 spid28s DELETE FROM EXCHANGEPAMDAPOOL
WHERE POOLID = @POOLID
2012-08-29 11:46:42.77 spid28s inputbuf
2012-08-29 11:46:42.77 spid28s Proc [Database Id = 126 Object Id = 1736393255]
2012-08-29 11:46:42.77 spid28s process id=processa810508 taskpriority=0 logused=692 waitresource=PAGE: 126:1:3994893 waittime=9795 ownerId=30340265723 transactionname=DELETE lasttranstarted=2012-08-29T11:46:32.967 XDES=0x4b0026e80 lockMode=IX schedulerid=21 kpid=10960 status=suspended spid=496 sbid=0 ecid=0 priority=0 trancount=2 lastbatchstarted=2012-08-29T11:46:32.967 lastbatchcompleted=2012-08-29T11:46:32.967 clientapp=.Net SqlClient Data Provider hostname=WIMVMARCHJOR1 hostpid=1440 loginname=MetalogixPAM isolationlevel=read committed (2) xactid=30340265723 currentdb=126 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
2012-08-29 11:46:42.77 spid28s executionStack
2012-08-29 11:46:42.77 spid28s frame procname=JOurnalExchangeDB.metalogixpam.SP_EXPAM_MARKARCHIVEDMAILINDAPOOL line=14 stmtstart=468 stmtend=582 sqlhandle=0x03007e0027427f676df9af0090a000000100000000000000
2012-08-29 11:46:42.77 spid28s DELETE FROM EXCHANGEPAMDAPOOL
WHERE POOLID = @POOLID
2012-08-29 11:46:42.77 spid28s inputbuf
2012-08-29 11:46:42.77 spid28s Proc [Database Id = 126 Object Id = 1736393255]
2012-08-29 11:46:42.77 spid28s process id=processa82b708 taskpriority=0 logused=33123340 waitresource=PAGE: 126:1:3139909 waittime=107 ownerId=30340249178 transactionname=UPDATE lasttranstarted=2012-08-29T11:46:22.220 XDES=0x357a99cd0 lockMode=U schedulerid=22 kpid=14748 status=suspended spid=244 sbid=0 ecid=0 priority=0 trancount=2 lastbatchstarted=2012-08-29T11:46:22.210 lastbatchcompleted=2012-08-29T11:46:22.210 clientapp=.Net SqlClient Data Provider hostname=WIMVMARCHJOR1 hostpid=1440 loginname=MetalogixPAM isolationlevel=read committed (2) xactid=30340249178 currentdb=126 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
2012-08-29 11:46:42.77 spid28s executionStack
2012-08-29 11:46:42.77 spid28s frame procname=JOurnalExchangeDB.metalogixpam.SP_EXPAM_MANAGEDAPOOL line=16 stmtstart=580 stmtend=808 sqlhandle=0x03007e000ea50f05e6f8af0090a000000100000000000000
2012-08-29 11:46:42.77 spid28s UPDATE EXCHANGEPAMDAPOOL SET MSGSTATUS = @MSGSTATUS WHERE JOBID = @JOBID AND (MSGSTATUS <> 3 AND MSGSTATUS <> 4)
2012-08-29 11:46:42.77 spid28s inputbuf
2012-08-29 11:46:42.77 spid28s Proc [Database Id = 126 Object Id = 84911374]
2012-08-29 11:46:42.77 spid28s resource-list
2012-08-29 11:46:42.77 spid28s pagelock fileid=1 pageid=3994893 dbid=126 objectname=JOurnalExchangeDB.metalogixpam.EXCHANGEPAMDAPOOL id=lock2e6971f80 mode=U associatedObjectId=72057594052149248
2012-08-29 11:46:42.77 spid28s owner-list
2012-08-29 11:46:42.77 spid28s owner id=processa82b708 mode=U
2012-08-29 11:46:42.77 spid28s waiter-list
2012-08-29 11:46:42.77 spid28s waiter id=processb2ee08 mode=IX requestType=wait
2012-08-29 11:46:42.77 spid28s pagelock fileid=1 pageid=3994893 dbid=126 objectname=JOurnalExchangeDB.metalogixpam.EXCHANGEPAMDAPOOL id=lock2e6971f80 mode=U associatedObjectId=72057594052149248
2012-08-29 11:46:42.77 spid28s owner-list
2012-08-29 11:46:42.77 spid28s waiter-list
2012-08-29 11:46:42.77 spid28s waiter id=processa810508 mode=IX requestType=wait
2012-08-29 11:46:42.77 spid28s pagelock fileid=1 pageid=3139909 dbid=126 objectname=JOurnalExchangeDB.metalogixpam.EXCHANGEPAMDAPOOL id=lock2e5040300 mode=IX associatedObjectId=72057594042318848
2012-08-29 11:46:42.77 spid28s owner-list
2012-08-29 11:46:42.77 spid28s owner id=processa810508 mode=IX
2012-08-29 11:46:42.77 spid28s waiter-list
2012-08-29 11:46:42.77 spid28s waiter id=processa82b708 mode=U requestType=wait
2012-08-29 11:46:42.87 spid21s deadlock-list
2012-08-29 11:46:42.87 spid21s deadlock victim=processa810508
2012-08-29 11:46:42.87 spid21s process-list
2012-08-29 11:46:42.87 spid21s process id=processa810508 taskpriority=0 logused=692 waitresource=PAGE: 126:1:3994893 waittime=9904 ownerId=30340265723 transactionname=DELETE lasttranstarted=2012-08-29T11:46:32.967 XDES=0x4b0026e80 lockMode=IX schedulerid=21 kpid=10960 status=suspended spid=496 sbid=0 ecid=0 priority=0 trancount=2 lastbatchstarted=2012-08-29T11:46:32.967 lastbatchcompleted=2012-08-29T11:46:32.967 clientapp=.Net SqlClient Data Provider hostname=WIMVMARCHJOR1 hostpid=1440 loginname=MetalogixPAM isolationlevel=read committed (2) xactid=30340265723 currentdb=126 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
2012-08-29 11:46:42.87 spid21s executionStack
2012-08-29 11:46:42.87 spid21s frame procname=JOurnalExchangeDB.metalogixpam.SP_EXPAM_MARKARCHIVEDMAILINDAPOOL line=14 stmtstart=468 stmtend=582 sqlhandle=0x03007e0027427f676df9af0090a000000100000000000000
2012-08-29 11:46:42.87 spid21s DELETE FROM EXCHANGEPAMDAPOOL
WHERE POOLID = @POOLID
2012-08-29 11:46:42.87 spid21s inputbuf
2012-08-29 11:46:42.87 spid21s Proc [Database Id = 126 Object Id = 1736393255]
2012-08-29 11:46:42.87 spid21s process id=processa82b708 taskpriority=0 logused=33123340 waitresource=PAGE: 126:1:3139909 waittime=217 ownerId=30340249178 transactionname=UPDATE lasttranstarted=2012-08-29T11:46:22.220 XDES=0x357a99cd0 lockMode=U schedulerid=22 kpid=14748 status=suspended spid=244 sbid=0 ecid=0 priority=0 trancount=2 lastbatchstarted=2012-08-29T11:46:22.210 lastbatchcompleted=2012-08-29T11:46:22.210 clientapp=.Net SqlClient Data Provider hostname=WIMVMARCHJOR1 hostpid=1440 loginname=MetalogixPAM isolationlevel=read committed (2) xactid=30340249178 currentdb=126 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
2012-08-29 11:46:42.87 spid21s executionStack
2012-08-29 11:46:42.88 spid21s frame procname=JOurnalExchangeDB.metalogixpam.SP_EXPAM_MANAGEDAPOOL line=16 stmtstart=580 stmtend=808 sqlhandle=0x03007e000ea50f05e6f8af0090a000000100000000000000
2012-08-29 11:46:42.88 spid21s UPDATE EXCHANGEPAMDAPOOL SET MSGSTATUS = @MSGSTATUS WHERE JOBID = @JOBID AND (MSGSTATUS <> 3 AND MSGSTATUS <> 4)
2012-08-29 11:46:42.88 spid21s inputbuf
2012-08-29 11:46:42.88 spid21s Proc [Database Id = 126 Object Id = 84911374]
2012-08-29 11:46:42.88 spid21s resource-list
2012-08-29 11:46:42.88 spid21s pagelock fileid=1 pageid=3994893 dbid=126 objectname=JOurnalExchangeDB.metalogixpam.EXCHANGEPAMDAPOOL id=lock2e6971f80 mode=U associatedObjectId=72057594052149248
2012-08-29 11:46:42.88 spid21s owner-list
2012-08-29 11:46:42.88 spid21s owner id=processa82b708 mode=U
2012-08-29 11:46:42.88 spid21s waiter-list
2012-08-29 11:46:42.88 spid21s waiter id=processa810508 mode=IX requestType=wait
2012-08-29 11:46:42.88 spid21s pagelock fileid=1 pageid=3139909 dbid=126 objectname=JOurnalExchangeDB.metalogixpam.EXCHANGEPAMDAPOOL id=lock2e5040300 mode=IX associatedObjectId=72057594042318848
2012-08-29 11:46:42.88 spid21s owner-list
2012-08-29 11:46:42.88 spid21s owner id=processa810508 mode=IX
2012-08-29 11:46:42.88 spid21s waiter-list
2012-08-29 11:46:42.88 spid21s waiter id=processa82b708 mode=U requestType=wait
2012-08-29 11:46:42.98 spid25s deadlock-list
2012-08-29 11:46:42.98 spid25s deadlock victim=process81b4c8
2012-08-29 11:46:42.98 spid25s process-list
2012-08-29 11:46:42.98 spid25s process id=process81b4c8 taskpriority=0 logused=692 waitresource=PAGE: 126:1:2431512 waittime=8513 ownerId=30340267617 transactionname=DELETE lasttranstarted=2012-08-29T11:46:34.480 XDES=0x3b5623950 lockMode=IX schedulerid=1 kpid=20396 status=suspended spid=499 sbid=0 ecid=0 priority=0 trancount=2 lastbatchstarted=2012-08-29T11:46:34.480 lastbatchcompleted=2012-08-29T11:46:34.480 clientapp=.Net SqlClient Data Provider hostname=WIMVMARCHJOR1 hostpid=1440 loginname=MetalogixPAM isolationlevel=read committed (2) xactid=30340267617 currentdb=126 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
2012-08-29 11:46:42.98 spid25s executionStack
2012-08-29 11:46:42.98 spid25s frame procname=JOurnalExchangeDB.metalogixpam.SP_EXPAM_MARKARCHIVEDMAILINDAPOOL line=14 stmtstart=468 stmtend=582 sqlhandle=0x03007e0027427f676df9af0090a000000100000000000000
2012-08-29 11:46:42.98 spid25s DELETE FROM EXCHANGEPAMDAPOOL
WHERE POOLID = @POOLID
2012-08-29 11:46:42.98 spid25s inputbuf
2012-08-29 11:46:42.98 spid25s Proc [Database Id = 126 Object Id = 1736393255]
2012-08-29 11:46:42.98 spid25s process id=processa82b708 taskpriority=0 logused=33140980 waitresource=PAGE: 126:1:5220149 waittime=106 ownerId=30340249178 transactionname=UPDATE lasttranstarted=2012-08-29T11:46:22.220 XDES=0x357a99cd0 lockMode=U schedulerid=22 kpid=14748 status=suspended spid=244 sbid=0 ecid=0 priority=0 trancount=2 lastbatchstarted=2012-08-29T11:46:22.210 lastbatchcompleted=2012-08-29T11:46:22.210 clientapp=.Net SqlClient Data Provider hostname=WIMVMARCHJOR1 hostpid=1440 loginname=MetalogixPAM isolationlevel=read committed (2) xactid=30340249178 currentdb=126 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
2012-08-29 11:46:42.98 spid25s executionStack
2012-08-29 11:46:42.98 spid25s frame procname=JOurnalExchangeDB.metalogixpam.SP_EXPAM_MANAGEDAPOOL line=16 stmtstart=580 stmtend=808 sqlhandle=0x03007e000ea50f05e6f8af0090a000000100000000000000
2012-08-29 11:46:42.98 spid25s UPDATE EXCHANGEPAMDAPOOL SET MSGSTATUS = @MSGSTATUS WHERE JOBID = @JOBID AND (MSGSTATUS <> 3 AND MSGSTATUS <> 4)
2012-08-29 11:46:42.98 spid25s inputbuf
2012-08-29 11:46:42.98 spid25s Proc [Database Id = 126 Object Id = 84911374]
2012-08-29 11:46:42.98 spid25s resource-list
2012-08-29 11:46:42.98 spid25s pagelock fileid=1 pageid=2431512 dbid=126 objectname=JOurnalExchangeDB.metalogixpam.EXCHANGEPAMDAPOOL id=lock46ca13d00 mode=U associatedObjectId=72057594052149248
2012-08-29 11:46:42.98 spid25s owner-list
2012-08-29 11:46:42.98 spid25s owner id=processa82b708 mode=U
2012-08-29 11:46:42.98 spid25s waiter-list
2012-08-29 11:46:42.98 spid25s waiter id=process81b4c8 mode=IX requestType=wait
2012-08-29 11:46:42.98 spid25s pagelock fileid=1 pageid=5220149 dbid=126 objectname=JOurnalExchangeDB.metalogixpam.EXCHANGEPAMDAPOOL id=lock20ec79300 mode=IX associatedObjectId=72057594042318848
2012-08-29 11:46:42.98 spid25s owner-list
2012-08-29 11:46:42.98 spid25s owner id=process81b4c8 mode=IX
2012-08-29 11:46:42.98 spid25s waiter-list
2012-08-29 11:46:42.98 spid25s waiter id=processa82b708 mode=U requestType=wait
2012-08-29 12:01:55.03 spid118 Setting database option SINGLE_USER to ON for database WNSDBREP.
2012-08-29 12:02:07.57 spid118 Starting up database 'WNSDBREP'.
2012-08-29 12:02:07.59 spid118 The database 'WNSDBREP' is marked RESTORING and is in a state that does not allow recovery to be run.
2012-08-29 12:02:09.31 spid118 Starting up database 'WNSDBREP'.
2012-08-29 12:02:09.41 spid118 Recovery is writing a checkpoint in database 'WNSDBREP' (65). This is an informational message only. No user action is required.
2012-08-29 12:02:10.08 spid118 CHECKDB for database 'WNSDBREP' finished without errors on 2011-12-24 06:05:24.553 (local time). This is an informational message only; no user action is required.
2012-08-29 12:02:10.09 Backup Restore is complete on database 'WNSDBREP'. The database is now available.
2012-08-29 12:46:34.76 spid18s deadlock-list
2012-08-29 12:46:34.76 spid18s deadlock victim=processa810508
2012-08-29 12:46:34.76 spid18s process-list
2012-08-29 12:46:34.76 spid18s process id=processa810508 taskpriority=0 logused=692 waitresource=PAGE: 126:1:13610500 waittime=5785 ownerId=30347084588 transactionname=DELETE lasttranstarted=2012-08-29T12:46:28.980 XDES=0x5f16ef950 lockMode=IX schedulerid=21 kpid=10960 status=suspended spid=400 sbid=0 ecid=0 priority=0 trancount=2 lastbatchstarted=2012-08-29T12:46:28.980 lastbatchcompleted=2012-08-29T12:46:28.980 clientapp=.Net SqlClient Data Provider hostname=WIMVMARCHJOR1 hostpid=1440 loginname=MetalogixPAM isolationlevel=read committed (2) xactid=30347084588 currentdb=126 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
2012-08-29 12:46:34.76 spid18s executionStack
2012-08-29 12:46:34.76 spid18s frame procname=JOurnalExchangeDB.metalogixpam.SP_EXPAM_MARKARCHIVEDMAILINDAPOOL line=14 stmtstart=468 stmtend=582 sqlhandle=0x03007e0027427f676df9af0090a000000100000000000000
2012-08-29 12:46:34.76 spid18s DELETE FROM EXCHANGEPAMDAPOOL
WHERE POOLID = @POOLID
2012-08-29 12:46:34.76 spid18s inputbuf
2012-08-29 12:46:34.76 spid18s Proc [Database Id = 126 Object Id = 1736393255]
2012-08-29 12:46:34.76 spid18s process id=processa84f048 taskpriority=0 logused=33104260 waitresource=PAGE: 126:1:3153543 waittime=2427 ownerId=30347084281 transactionname=UPDATE lasttranstarted=2012-08-29T12:46:28.860 XDES=0x51e184b00 lockMode=U schedulerid=24 kpid=19660 status=suspended spid=394 sbid=0 ecid=0 priority=0 trancount=2 lastbatchstarted=2012-08-29T12:46:28.853 lastbatchcompleted=2012-08-29T12:46:28.853 clientapp=.Net SqlClient Data Provider hostname=WIMVMARCHJOR1 hostpid=1440 loginname=MetalogixPAM isolationlevel=read committed (2) xactid=30347084281 currentdb=126 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
2012-08-29 12:46:34.76 spid18s executionStack
2012-08-29 12:46:34.76 spid18s frame procname=JOurnalExchangeDB.metalogixpam.SP_EXPAM_MANAGEDAPOOL line=16 stmtstart=580 stmtend=808 sqlhandle=0x03007e000ea50f05e6f8af0090a000000100000000000000
2012-08-29 12:46:34.76 spid18s UPDATE EXCHANGEPAMDAPOOL SET MSGSTATUS = @MSGSTATUS WHERE JOBID = @JOBID AND (MSGSTATUS <> 3 AND MSGSTATUS <> 4)
2012-08-29 12:46:34.76 spid18s inputbuf
2012-08-29 12:46:34.76 spid18s Proc [Database Id = 126 Object Id = 84911374]
2012-08-29 12:46:34.76 spid18s resource-list
2012-08-29 12:46:34.76 spid18s pagelock fileid=1 pageid=13610500 dbid=126 objectname=JOurnalExchangeDB.metalogixpam.EXCHANGEPAMDAPOOL id=lock2e4235280 mode=U associatedObjectId=72057594052149248
2012-08-29 12:46:34.76 spid18s owner-list
2012-08-29 12:46:34.76 spid18s owner id=processa84f048 mode=U
2012-08-29 12:46:34.76 spid18s waiter-list
2012-08-29 12:46:34.76 spid18s waiter id=processa810508 mode=IX requestType=wait
2012-08-29 12:46:34.76 spid18s pagelock fileid=1 pageid=3153543 dbid=126 objectname=JOurnalExchangeDB.metalogixpam.EXCHANGEPAMDAPOOL id=lock2e6628700 mode=IX associatedObjectId=72057594042318848
2012-08-29 12:46:34.76 spid18s owner-list
2012-08-29 12:46:34.76 spid18s owner id=processa810508 mode=IX
2012-08-29 12:46:34.76 spid18s waiter-list
2012-08-29 12:46:34.76 spid18s waiter id=processa84f048 mode=U requestType=wait
2012-08-29 12:46:52.30 spid17s deadlock-list
2012-08-29 12:46:52.30 spid17s deadlock victim=process81b048
2012-08-29 12:46:52.30 spid17s process-list
2012-08-29 12:46:52.30 spid17s process id=process81b048 taskpriority=0 logused=1284 waitresource=PAGE: 126:1:13613549 waittime=21068 ownerId=30347088820 transactionname=INSERT lasttranstarted=2012-08-29T12:46:31.233 XDES=0x85186b3c0 lockMode=IX schedulerid=1 kpid=16572 status=suspended spid=64 sbid=0 ecid=0 priority=0 trancount=2 lastbatchstarted=2012-08-29T12:46:31.233 lastbatchcompleted=2012-08-29T12:46:31.233 clientapp=.Net SqlClient Data Provider hostname=WIMVMARCHJOR1 hostpid=1440 loginname=MetalogixPAM isolationlevel=read committed (2) xactid=30347088820 currentdb=126 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
2012-08-29 12:46:52.30 spid17s executionStack
2012-08-29 12:46:52.30 spid17s frame procname=JOurnalExchangeDB.metalogixpam.SP_EXPAM_ADDMAILTODAPOOL line=22 stmtstart=916 stmtend=1572 sqlhandle=0x03007e00ee1d8b666df9af0090a000000100000000000000
2012-08-29 12:46:52.30 spid17s INSERT INTO EXCHANGEPAMDAPOOL (MBXID, URL, ACTION, OTHERPARAMETERS, ARCHIVEMETHOD, BODYASCONTENT, USEHTMLBODY,
CURRENTUSER, JOBID, MSGSTATUS, JOBSTART, RETCATID)
VALUES (@MBXID, @URL, @ACTION, @OTHERPARAMETERS, @ARCHIVEMETHOD, @BODYASCONTENT, @USEHTMLBODY, @CURRENTUSER, @JOBID, @MSGSTATUS, @JOBSTART, @RETCATID)
2012-08-29 12:46:52.30 spid17s inputbuf
2012-08-29 12:46:52.30 spid17s Proc [Database Id = 126 Object Id = 1720393198]
2012-08-29 12:46:52.30 spid17s process id=processa84f048 taskpriority=0 logused=243852580 waitresource=PAGE: 126:1:2812446 waittime=3451 ownerId=30347084281 transactionname=UPDATE lasttranstarted=2012-08-29T12:46:28.860 XDES=0x51e184b00 lockMode=U schedulerid=24 kpid=19660 status=suspended spid=394 sbid=0 ecid=0 priority=0 trancount=2 lastbatchstarted=2012-08-29T12:46:28.853 lastbatchcompleted=2012-08-29T12:46:28.853 clientapp=.Net SqlClient Data Provider hostname=WIMVMARCHJOR1 hostpid=1440 loginname=MetalogixPAM isolationlevel=read committed (2) xactid=30347084281 currentdb=126 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
2012-08-29 12:46:52.30 spid17s executionStack
2012-08-29 12:46:52.30 spid17s frame procname=JOurnalExchangeDB.metalogixpam.SP_EXPAM_MANAGEDAPOOL line=16 stmtstart=580 stmtend=808 sqlhandle=0x03007e000ea50f05e6f8af0090a000000100000000000000
2012-08-29 12:46:52.30 spid17s UPDATE EXCHANGEPAMDAPOOL SET MSGSTATUS = @MSGSTATUS WHERE JOBID = @JOBID AND (MSGSTATUS <> 3 AND MSGSTATUS <> 4)
2012-08-29 12:46:52.30 spid17s inputbuf
2012-08-29 12:46:52.30 spid17s Proc [Database Id = 126 Object Id = 84911374]
2012-08-29 12:46:52.30 spid17s resource-list
2012-08-29 12:46:52.30 spid17s pagelock fileid=1 pageid=13613549 dbid=126 objectname=JOurnalExchangeDB.metalogixpam.EXCHANGEPAMDAPOOL id=lock2e6f0ef00 mode=U associatedObjectId=72057594052149248
2012-08-29 12:46:52.30 spid17s owner-list
2012-08-29 12:46:52.30 spid17s owner id=processa84f048 mode=U
2012-08-29 12:46:52.30 spid17s waiter-list
2012-08-29 12:46:52.30 spid17s waiter id=process81b048 mode=IX requestType=wait
2012-08-29 12:46:52.30 spid17s pagelock fileid=1 pageid=2812446 dbid=126 objectname=JOurnalExchangeDB.metalogixpam.EXCHANGEPAMDAPOOL id=lock7634f4c00 mode=IX associatedObjectId=72057594042318848
2012-08-29 12:46:52.30 spid17s owner-list
2012-08-29 12:46:52.30 spid17s owner id=process81b048 mode=IX
2012-08-29 12:46:52.30 spid17s waiter-list
2012-08-29 12:46:52.30 spid17s waiter id=processa84f048 mode=U requestType=wait
Post #1351501
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse