Deadlock occurring between bts_InsertTrackingData and TDDS_GetTrackingRecord

Recently, I saw an issue where we were observing deadlocks between the stored procedures ‘bts_InsertTrackingData’ and ‘TDDS_GetTrackingRecord’ and this happens when there is a huge load for BizTalk to process. What we found that Tracking was enabled on multiple hosts. We disabled tracking on hosts such that we have only one tracking host and this…