BizTalk Server - Deadlocking in MessageBox..

Author

Deadlocking in MessageBox..

Mark B

2007-12-18, 1:26 pm

fairly new to biztalk, but hope someone knows about this.

Have detected numerous daily deadlocks occurring particularly within
MessageBox db, more specifically being caused by
bts_DeQueueMessages_Aggregation and bts_UpdateMsgbox_Aggregation stored
procedures.

the former proc is being chosen as the victim (because it has an explicit
low priority setting).

This is happening on the ix _aggregationQ index of the aggregationQ table.

Has anyone seen this before?

thanks.