DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 2627804 - Last Review: January 21, 2012 - Revision: 3.1

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:

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:
2497794  (http://support.microsoft.com/kb/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 (http://support.microsoft.com/kb/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  (http://support.microsoft.com/kb/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   (http://support.microsoft.com/kb/2003907 / ) Information about BizTalk Server hotfixes
Keywords: 
kbbtsbam kbqfe kbfix kbsurveynew kbexpertiseadvanced kbbiztalk2009presp1fix KB2627804
Share
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support