FIX: The "MessageBox_Parts_Cleanup_BizTalkMsgBoxDb" SQL Server agent job runs very slowly in BizTalk Server

Article translations Article translations
Article ID: 2224680 - View products that this article applies to.
Expand all | Collapse all

On This Page

SYMPTOMS

On a computer that is running Microsoft BizTalk Server 2006 R2, in BizTalk Server 2009 or in BizTalk Server 2010, the MessageBox_Parts_Cleanup_BizTalkMsgBoxDbSQL Server agent job runs very slowly. When this issue occurs, the job purges limited records of message parts per second from the Parts table in the BizTalkMsgBoxDb database. For example, the job only processes about 100 records per second. However, if you run the job manually in the query window, the job processes about 5000 records per second.

CAUSE

The issue occurs because an inefficient query plan is used in the stored procedure for the MessageBox_Parts_Cleanup_BizTalkMsgBoxDb SQL Server Agent job. This causes the job to run very slowly.

RESOLUTION

Cumulative update information

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:
2497789 Cumulative update package 1 for BizTalk 2010

Cumulative update informationThe hotfix that resolves this issue is included in cumulative update package 2 for BizTalk Server 2009.

For more informationabout 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 2 for BizTalk Server 2009

The hotfix that resolves this problem is included in cumulative update package 2 for BizTalk Server 2006 R2 Service Pack 1.

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:

2211420 Cumulative update package 2 for BizTalk Server 2006 R2 Service Pack 1

STATUS

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

MORE INFORMATION

The MessageBox_Parts_Cleanup_BizTalkMsgBoxDb SQL Server agent job removes all message parts that are no longer referenced by a message in the BizTalkMsgBoxDb database tables. All messages are composed of one or more message parts that contain the message data.

For more information about the description of the SQL Server Agent jobs in BizTalk Server, click the following article number to view the article in the Microsoft Knowledge Base:
919776 Description of the SQL Server Agent jobs in BizTalk Server

REFERENCES

For more information about the description of the SQL Server Agent jobs in BizTalk Server, click the following article number to view the article in the Microsoft Knowledge Base:

919776 Description of the SQL Server Agent jobs in BizTalk Server

For more information about software update terminology, click the following article number to view the article in the Microsoft Knowledge Base:
824684 Description of the standard terminology that is used to describe Microsoft software updates
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


For more information about the list of Microsoft BizTalk Server hot fixes that are included in BizTalk Server 2006 R2 Service Pack 1, click the following article number to view the article in the Microsoft Knowledge Base:
974563 List of Microsoft BizTalk Server hot fixes that are included in BizTalk Server 2006 R2 Service Pack 1

Properties

Article ID: 2224680 - Last Review: May 23, 2011 - Revision: 4.0
APPLIES TO
  • Microsoft BizTalk Server 2009 Branch
  • Microsoft BizTalk Server 2009 Developer
  • Microsoft BizTalk Server 2009 Enterprise
  • Microsoft BizTalk Server 2009 Standard
  • Microsoft BizTalk Server 2006 R2 Branch Edition
  • Microsoft BizTalk Server 2006 R2 Developer Edition
  • Microsoft BizTalk Server 2006 R2 Enterprise Edition
  • Microsoft BizTalk Server 2006 R2 Standard Edition
Keywords: 
kbautohotfix kbqfe kbhotfixserver kbfix kbbiztalk2009presp1fix KB2224680

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