• 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 TaskProxy:(0x00000006E7F03950) Value:0x5a142748 Cost:(20/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 TaskProxy:(0x00000006E7F02F80) Value:0x57c1b88 Cost:(0/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 TaskProxy:(0x00000006E7F03830) Value:0xa0dd42c8 Cost:(0/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 TaskProxy:(0x00000006E7F037D0) Value:0xa2e642c8 Cost:(0/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 TaskProxy:(0x00000006E7F03890) Value:0x5a142508 Cost:(0/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 TaskProxy:(0x00000006E7F03530) Value:0x5ac5dc8 Cost:(0/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 TaskProxy:(0x00000006E7F036B0) Value:0x5a1422c8 Cost:(0/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 TaskProxy:(0x00000006E7F03770) Value:0xa2e64088 Cost:(0/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 TaskProxy:(0x00000006E7F034D0) Value:0x5ace748 Cost:(0/10000)