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

Article translations Article translations
Article ID: 2627804
Expand all | Collapse all

On This Page

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 databases
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:

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

Properties

Article ID: 2627804 - Last Review: January 21, 2012 - Revision: 3.1
Keywords: 
kbbtsbam kbqfe kbfix kbsurveynew kbexpertiseadvanced kbbiztalk2009presp1fix KB2627804

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com