Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

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


View products that this article applies to.

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.

↑ Back to the top


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.

↑ Back to the top


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

↑ Back to the top


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


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

↑ Back to the top


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

↑ Back to the top


Keywords: kbautohotfix, kbqfe, kbhotfixserver, kbfix, kbbiztalk2009presp1fix, KB2224680

↑ Back to the top

Article Info
Article ID : 2224680
Revision : 4
Created on : 5/23/2011
Published on : 5/23/2011
Exists online : False
Views : 500