Select the product you need help with

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

Article ID: 2627804

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.

Back to the top | Give Feedback

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

Back to the top | Give Feedback

STATUS

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

Back to the top | Give Feedback

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

Back to the top | Give Feedback