FIX: Hotfix that improves the performance of the tracking feature in BizTalk Server is available

This article describes a hotfix that improves the performance of the tracking feature in Microsoft BizTalk Server 2009 and Microsoft BizTalk Server 2010.

BizTalk Server has the following tracking features:

• The tracking feature for receive ports, for send ports, for orchestrations, and for pipelines
• The Business Activity Monitoring (BAM) asynchronous tracking feature for the Orchestration event stream and for the Buffered event stream

Tracking data is stored in the TrackingData_X_Y tables in the BizTalkMsgBoxDb database.

Notes

• The value of X is 1 for the tracking feature for receive ports, for send ports, for orchestrations, and for pipelines.
• The value of X is 0 for the BAM asynchronous tracking feature.
• The value of Y is an integer in the 0 through 3 range.

When a tracking operation is complete, the tracking data is moved to the BizTalkDTADb and BAMPrimaryImportDb databases.

Before you apply this hotfix, BizTalk Server 2010 takes a long time to process tracking data if a large backlog exists.

This hotfix improves the TDDS_GetTrackingData stored procedure in the BizTalkMsgBoxDb database. After you apply this hotfix, the performance of BizTalk Server 2010 is improved when it processes the tracking data.