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.

Cumulative update information

BizTalk Server 2009

The hotfix that resolves this issue is included in cumulative update package 5 for BizTalk Server 2009.

For more information about how to obtain the cumulative update package, click the following article number to view the article in the Microsoft Knowledge Base:

2649852  (http://support.microsoft.com/kb/2649852/ ) Cumulative update package 5 for BizTalk Server 2009

BizTalk Server 2010

The hotfix that resolves this issue is included in cumulative update package 3 for BizTalk Server 2010.

For more information about how to obtain the cumulative update package, click the following article number to view the article in the Microsoft Knowledge Base:

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

For information about how to maintain and troubleshoot BizTalk Server databases, click the following article number to view the article in the Microsoft Knowledge Base:

For information about the service pack and cumulative update list for BizTalk Server, click the following article number to view the article in the Microsoft Knowledge Base:


For more information about BizTalk Server hotfixes, click the following article number to view the article in the Microsoft Knowledge Base: