Deadlock due to Body Tracking - BizTalk Server 2006

You receive a similar alert as this one
ISSUE:
Event Type: Error
Event Source: BizTalk Server 2006
Event Category: BizTalk Server 2006
Event ID: 6912Date: 19/12/2007
Time: 08:09:11
User: N/A
Computer: SOMESERVER
Description:The following stored procedure call failed: " { call [dbo].[bts_UpdateMsgbox_HostInstanceName]( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)}". SQL Server returned error string: "Transaction (Process ID 102) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.;Duplicate key was ignored.".

RESOLUTION:
Disable body tracking!!

Problem was due to problems in BizTalk 2006 when you have multiple tracking on the same message. E.g. Before and After without changing the message (Pass-through) and in multiple place like when sending to many send ports/send port groups and tracking in all of them or tracking pipelines and schemas as well. Only tracking the same message in one place solved the problem. This was not fixed due to too complex and not happening too often