Summary
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.
More Information
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:
2649852Cumulative 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:
2497794 Cumulative update package 3 for BizTalk Server 2010
Status
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
References
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:
952555 How to maintain and troubleshoot BizTalk Server databasesFor 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:
2555976 Service pack and cumulative update list for BizTalk Server
For more information about BizTalk Server hotfixes, click the following article number to view the article in the Microsoft Knowledge Base:
2003907 Information about BizTalk Server hotfixes
