???? ID: 952555 - ????? ???????: 07 ?????? 2010 - ??????: 2.0

???? ???? ?? BizTalk Server ??????? ???????? ?? ?????? ???? ????

???? ?????? ???????? KB ?? ???????? ????? ?? ??? ???? ????? ????

?? ???????? ?? ?????? ??? ?? ?? ???? ???? ???? ??.

?????? ??????This article applies to a different operating system than the one you are using. Article content that may not be relevant to you is disabled.

?? ????? ??

??? ?? ??????? ???? | ??? ?? ??????? ????

Microsoft BizTalk Server ??????? ?? ????????? ?? ??????? ?? ?? ??? BizTalk ????? ????? ?????? ?? ??? ???? ?????????? ??? ?? ???? ?? BizTalk Server ??????? ?? ??? ??? ???? ?? ????? ???? ?? ??? ?????????? ??? ?? ????? ???? ??? ?? ????? ??? ????? ????? ???:

????? ???? ????????: ?????? ??????, ??????? ????? ??????Microsoft SQL Server ???????
?? ??? ??? ?? ?????? ??? ??? ?? Parallelism ??? ??? ???? ?????
??? ?? ?? ?? ???? ??? ?? BizTalk ????? ????????????? ????????? ?????
??????, deadlocking ?? ????? ?? ??? ?? ???? ???
???? ??????? ?? ?????? ?? ??? ?????? ????? ?? ?????
SQL ????? ????? BizTalk ?????
???? ?????????? ?? ??????? ???? ?? ???? ?? ???? ???
?? SQL ????? ?? BizTalk ????? ???????? ???????? ?? ????? ?? ?????
???? BizTalk ????? ??? ????? ????? ?? ???? ???? ??????

????? ?? ???? ????

?????

?? ???? ????? ???? ?? ?? ???? BizTalk Server ??????? ?? ???? ???? ?? ??? ?? BizTalk Server ??????? ???????? ?? ?????? ???? ?????

????? ?? ???? ????

???? ???????

????? ?????

????: ?????? ?????? ?? ????? ????? ?????? ?????? ?? ????? ???? ????

????? ???? ????????? ????? ??????, ??????: ?????? ???????????? BizTalkMsgBoxDb ??????? ?? ??? ??? ????? ?? ???? ?? ???????? ????? ???, ?? ??? ????? ???????? ???????????? SQL ????? ??? ?????????:

exec sp_dboption 'BizTalkMsgBoxDB', 'auto create statistics'
exec sp_dboption 'BizTalkMsgBoxDB', 'auto update statistics'

CurrentSetting ?????? ?? "???." ???? ?? ??? ??? ???? ????? ??? ?? ?????? ?? "??" ???? ?? ??? ??? ??, ?? ??? ??? SQL ????? ??? ????? ???????? ???????????? ????????? ??:

exec sp_dboption 'BizTalkMsgBoxDB', 'auto create statistics', 'off'
exec sp_dboption 'BizTalkMsgBoxDB', 'auto update statistics', 'off'

???? ??????? ?? ???, Microsoft ?????? ??? ??? ???? ????? ?? ??? ????? ???? ?????? ????? ????::

917845� (http://support.microsoft.com/kb/917845/ ) ???????? ?? ????? ???? ???, ??????, ?? ???? SQL ????? ?????? deadlock BizTalk ????? 2006 ?? BizTalk ????? 2004 ??? BizTalkMsgBoxDb ??????? ?? ?????? ???? ?? ?????? ???? ???

912262� (http://support.microsoft.com/kb/912262/ ) ????: ?????? ????? ?????? ???, ????: ??? ????? ??????, ?? Parallelism ?????? ??? ??? SQL Server 2000 ?? SQL Server 2005 ??????? ??????? BizTalk ????? 2004 ?? ????? 2006 BizTalkMsgBoxDB BizTalk ??????? ?? ????? ???? ?? ?? ???

?????? ??? Parallelism ?? ??? ???? ?????????? ?????? ??

???????? ?? ?? SQL ????? ?? ??? ?? ?? BizTalkMsgBoxDb ??????? ?? ????? ???? ????, ??? Parallelism run_value ?? config_value ????? ?? ?????? ??? ??? 1 ??? ???????? ????????? ?? ?????? ?? ??????? Parallelism ?????? ?? ?????? ??? ????????? ??, ????? ?? ????????? ???? ?? ??? SQL Server ??? ???????:

exec sp_configure 'max degree of parallelism'

Run_value ?? config_value ??? ??? 1 ?? ??? ???? ???, ??? SQL ????? ??? ????? ???????? ????????? ?????????:

exec sp_configure 'max degree of parallelism', '1'
reconfigure with override

???? ??????? ?? ???, Microsoft ?????? ??? ??? ???? ????? ?? ??? ????? ???? ?????? ????? ????::

899000� (http://support.microsoft.com/kb/899000/ ) SQL ????? ?? BizTalk ????? ?? ???????? ???? ?? ?????? ?? ??? Parallelism ??????

??? ?? ?? ?? ???? ??? ?? BizTalk ????? ????????????? ????????? ????

??????? BizTalk ????? ????????????? clustered ??? (ID ???????????: 1). BizTalk ????? ???????? ?? ??? ????????????? ??????? ????????? ???? ?? ??? ?? DBCC SHOWCONTIG ??? ?? ????? ?? ???? ????

GUID-?????? ????? ?? BizTalk ????????????? ??? ???? ?????, ????????????? ?????????? ?? ???? ??? ??? DBCC SHOWCONTIG ??? ?? ?????? ???? ??? ?? ?? ????? ????? ??? ?? ?? 30 ??????? ??, BizTalk ????? ????????????? ???????? ?? ????? rebuilt ?? ???? ????

?? BizTalk ????? ???????? ??? DataType ????????? ?? ????? ???? ???? ????? ???? ?????? ?????????? ???? ?? ?? ???? ?? ??????? ???? ???, ????? ?? ????? ??? ???? ?? BizTalk ????? ????????????? ??? BizTalk ????? ?? ???? ??????? ???? ???

???? ??????? ?? ???, Microsoft ?????? ??? ??? ???? ????? ?? ??? ????? ???? ?????? ????? ????::

DBCC SHOWCONTIG ??? ?????? ?? ???????? ???? ?? ??? ???? ???? ?? ???? ??? ???? ??????? ?? ??? ????? Microsoft ??? ???? ?? ????:

HTTP://TechNet.Microsoft.com/en-us/library/cc966523.aspx (http://technet.microsoft.com/en-us/library/cc966523.aspx)

??????, deadlocking ?? ????? ?? ??? ?? ???? ??

??????????, locks ?? ??????? ?? BizTalk ????? ??????? ??? ??? ???????, ?? locks ?? ????? ???? ???? ???? ????????? ??? ?? ???? ?????, ????? ?? ??? ?? ?? deadlocking ????? ???? ??????? ???????

???? ??????? ?? ???, Microsoft ?????? ??? ??? ???? ????? ?? ??? ????? ???? ?????? ????? ????::

???? ??????? ?? ?????? ?? ??? ?????? ????? ?? ???? ???

???? ???? ??? ?? ?? BizTalkMsgBoxDb ??????? 5 GB ?? ???? ??, ?? ???????? ? ???? ??? Ideally, BizTalkMsgBoxDb ??????? ????? ???? ???? ?? ???? ?? ???? ?? ????? BizTalkMsgBoxDb ??????? ???? ???? ???? ?? ????? ?? ?? ???? ??????? ?? BizTalkDTADb ??????? ?? ??? ?? ???? ??? ?? ???

?? ??????? ?? ???? ???? ??? ?? ???? ???? ???? orchestrations ?? ????? SQL ????? ?? ????? ???? ?? ?? 5 GB ?? ???? ?? ?? BizTalkMsgBoxDb ??????? ?? ???? ???

??? ???? ???? orchestrations ?? ????? ???? ?? ?? ?? ????-??? ??????? ??? 5 GB ?? ???? ?? ?? BizTalkMsgBoxDb ??????? ???? ??????

BizTalkDTADb ??????? ???? ??? ???? ??? ???????, ??? ?????? ???????? ????? ??, ?? ??????? ?????? ???? ??? ??? ??????????, 15 GB 20 GB ?? ??? ???? ??? ???? ??? ?? ???? BizTalk Server ??????? ??, ?? ?? ????? ???????? ?? ????? ?? ????:

BizTalkMsgBoxDb ??????? ????? ???? ?? ??? ???? ???? ??? ???????, ??? ????? ?? ???? ?? ???? ?? ?????
BizTalk ????? ?? ?? ??? ??????? ????? ?????? ???????? ?? ??????? ???? ?? ??? ??????? ?? ???? ??? ???? ???
????????? ?? ??????? ???????? (HAT) ???????? ?? ??????? ?? ???? ??? ?? ?? ??? ????? ?? ???? ???
??????? ??? ????? ???? ??? ???? ???
SQL ????? ????? BizTalk ????? ?? ??????? slower ??????
??? ???????? ???????????? ??? ???? ??? ?? ???? ??? ???? ???? ????????? ????? ?????? ?? ??????? ???? ?? ??? ???

??????? ??????? ?????? ?? ??? ?? ???? ???? ?? ?????? ?? ????? ????? ?? ???? ??:

SQL ????? ????? BizTalk ????? ???? ??? ??? ???
???? ?????? ??? ?????? ??????????
????? ??????
????????
?????????
SQL ????? ???????????
??????? latency

????????? ???? ?? ?? ????? ??? ?? ???? ??? ?? ???? ??????? ??? ????????? ???? ?? ???? ??? ???? ?????? ??????? ?? ??? ???

???????? ??? ??, ???????? ??????? ????? ?? ????? ???? ??? ??? BizTalk ?? ?? ????????????? ???? ?? ?????? ????????? ?? ???? ??? ????? ??? ???? ?? ???? ??? ???????? ????? ???? ??? ??, ?? ???????? ???? ????? ???? (TDDS) ???????? ?? ???? ?? BizTalkDTADb ??????? ?? ??? BizTalkMsgBoxDb ??????? ?? ????? ????? If the tracking host is stopped, TDDS does not move the data to the BizTalkDTADb database and the TrackingData_x_x tables in the BizTalkMsgBoxDb database will grow.

We recommend that you dedicate one host to tracking. To allow for TDDS to maintain new tracking events in high-volume scenarios, you can create multiple instances of a single tracking host. No more than one tracking host should exist.

You can have too many rows in a table. There is no set number of rows that are too many. Additionally, this number of rows varies by what kind of data is stored in the table. For example, a dta_DebugTrace table that has more than 1 million rows probably has too many rows. A????????Q_Suspended table that has more than 200,000 rows probably has too many rows.

Use the correct BizTalk SQL Server Agent jobs

SQL ????? ????? BizTalk ????? BizTalk Server ??????? ?? ???????? ???? ?? ??? ?? ???? ??????????? ?? ?????? ?? ??? ?????????? ????

????? BizTalk ?????SQL ????? ?????????? ?? BizTalk Server ??????? ?? ????? ?? ??? ??????? ??????? ????? ??? ?? ????? ????? ????????????? ???? ?? ?? ????? ???? ?? ??? ??? BizTalk Server ??????? ?? ??? ???? ?? ??? ?????? ??? ?? ?? ????? ?? ???? healthy BizTalk ????? ?????? ?? ??? ???????? ???? ?????? ???? ??? SQL ????? ???? ???? ???? ?? ?? ??? ??? BizTalk ????? ????????? ??? ?? BizTalk Server ??????? ?? ????? ???? ?? ??? ?? SQL Server ??????? ?? ????? ?? ???? ????

SQL ????? ????? MessageBox_Message_ManageRefCountLog_BizTalkMsgBoxDb ????? infinitely ????? ??? ?????, SQL Server ????? ????? ?????? ??? ???? ????? ?? ??? ????? ??? ??? ???? ?????? ??????? ???? ??, ????? ?? ???? ??? ???????? ?? ???? ?? ?? infinitely ????? ?? ??? ???? ???? ??? ?????, ?? ?? ???? ??? ???????? ??? ?? ??????? ??????? ??? ??, ?? ????? ?? ?????? ??? ?? ???? ???? ?? ????? ?? ?????? ????? ?? ?? ????? constantly ???? ???? ?? ?? ???????? ?? ???? ?? ??? ?????? ???? ???? ??????

SQL Server ????? MessageBox_Message_Cleanup_BizTalkMsgBoxDb ????? ?? ?? ???? ????? ????? ???? ?? MessageBox_Message_ManageRefCountLog_BizTalkMsgBoxDb ????? ??????? ???? ?? ??????? ???? BizTalk ????? ????? ???

DTA ?????? ?? SQL Server ????? ?????? ?? ????? BizTalkDTADb ??????? ?? ?????? ?? ????? ??? ?? ????? ?????? ?? ?????? ???? ???? ??? ???? ??? ???? ??? ?? ????? ?? ???????? ?????? ??? ?????? ???? ?? ?? ???? ??????? ???? ????? ?????? ?? ???? ?? ?? ????????? ???? ?? ??? ??? ??????? ?? ????? ???? ???

MessageBox_Message_ManageRefCountLog_BizTalkMsgBoxDb SQL Server ????? ????? ?? ???? ?? ???? ??? BizTalk SQL Server ????? ????? ??????????? ?? ???? ??????

??? BizTalk ????? SQL Server ????? ????? ?? ??? ????? ?? ??? ????? Microsoft ?????????? ?????? ??????? (MSDN) ??? ???? ?? ????:

HTTP://MSDN.Microsoft.com/en-us/library/aa561960.aspx (http://msdn.microsoft.com/en-us/library/aa561960.aspx)

??? BizTalk ????? 2004 SQL Server ????? ????? ?? ???? ??? ???? ??????? ?? ??? Microsoft ???????? ??? ???? ????? ?? ??? ????? ???? ?????? ?? ????? ????:

919776� (http://support.microsoft.com/kb/919776/ ) BizTalk ????? 2004 ??? SQL Server ????? ????? ?? ?????

???? ?????????? ??????? ???? ?? ???? ??

???? ?????????? ??????? (resumable) ?? (resumable ????) ?? ??????? ???? ?? ???? ???? ?? ???? ?????????? Messaging, Orchestration ?? ????? ?? ??? ?? ???? ???

????? ?????? ?? ???? ?????????? BizTalkMsgBoxDb ??????? ????? unnecessarily.These ?????????? ?? ?????? ?? ???? ??? ??? ???? ??? ????? ?????? ?????? ?? ??? ??? ????? ???? ?? ????, BizTalk ??????? ?? ???? ?? ???????? ???? ??:

?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????

	???? ??	???	Terminate.vbs
BizTalk ????? 2009	???	????	???
BizTalk 2006 R2 ?????	???	???	???
BizTalk ????? 2006	???	???	???
BizTalk ????? 2004	????	???	???

Terminate.vbs ????????? ???? ?? ???? ??? ???? ??????? ?? ??? ????? MSDN ??? ???? ?? ????:

HTTP://MSDN.Microsoft.com/en-us/library/bb203857.aspx (http://msdn.microsoft.com/en-us/library/bb203857.aspx)

?????? ???????????? ??? ????? ???????? ???????, ?? ?? ???? ??????? ?? ?????????? ?????? ?? ??????? ?? ???????? ?? ???? ?????? ??? ?????? ?? ??????? ???? ??? BizTalk ????? 2006 ??? ??? ???? ???????? ?? ??? ?? zombie ??????? ?? ????? ?? ??? 936536 Microsoft ???????? ???? ??? ?????? ???????? ?? ???? ????? ?? ?????? ?? BizTalk 2006 R2 ????? ??? ?? ??? ??? ??? ???? ??? ???

???:Zombie ????? ??? ??? ????? ??? ???? ??? ?? ????? consumed ???? ???

???? ??????? ?? ???, Microsoft ?????? ??? ??? ???? ????? ?? ??? ????? ???? ?????? ????? ????::

936536� (http://support.microsoft.com/kb/936536/ ) FIX: ?? BizTalk ????? 2006 ?? ???????? ???????? ?? ????? ?? ????????? ????? ???????? ??? ????? ??? ??? ?? ???

?? ??? BizTalk ????? ????? ??????? ??????, ?????????? ?? ??? ???? ?????? ?? ???? ??? BizTalk ????? 2006 ?? BizTalk 2006 R2 ????? ??? ?? ??????? ?? ?????? ?? ??? 944426 Microsoft ???????? ???? ??? ?????? ???????? ?? ???? ????? BizTalk ????? 2009 ??? ?? ?????? ?? ??? ???? ??? ???

???? ??????? ?? ???, Microsoft ?????? ??? ??? ???? ????? ?? ??? ????? ???? ?????? ????? ????::

944426� (http://support.microsoft.com/kb/944426/ ) FIX: Orphaned ??? ?????????? ?????????? ?????? ??? BizTalk ????? 2006 BizTalkMsgBoxDb ??????? ??? ????? ?? ???? ?? ???? ??

????? ?? ???? ????

???? ???? ?? ?????? ?? ?? ?????? ???? ??????? (RFRs) ?? ???? ?? ????? BizTalkHostQ ?? BizTalkHostQ_Suspended ???????? ??? ??? RFRs ???? ????? ??? ???? ???, ?? ?? ??????? BizTalkMsgBoxDb ??????? ?? ????? ?? ???? ?? ???? ??? BizTalk ????? 2006 ??? ?? ?????? ?? ???, 941690 Microsoft ???????? ???? ??? ?????? ???????? ?? ???? ????? ?? ?????? ?? BizTalk 2006 R2 ????? ??? ?? ??? ??? ??? ???? ??? ???

???? ??????? ?? ???, Microsoft ?????? ??? ??? ???? ????? ?? ??? ????? ???? ?????? ????? ????::

941690� (http://support.microsoft.com/kb/941690/ ) FIX: ?????? ???? ??????? ??? ???? ?????? <biztalkhostname>BizTalk ????? 2006 ????? ?? Q_Suspended ??????</biztalkhostname> ??

????? ?? ???? ????

???? "????? ?????" ?? "zombie ?????" ????? ????? interchangeably ???

?? ????? ????? ?? ?????? ??????? ???? ?? ?? ?? ????? ??? ?????? ?? ???, ??? ?????? ???? ??????? ????? ????? ???

Zombie ????? ??? ??? ????? ??? ???? ??? ?? ????? consumed ???? ??? ?????? ?? ???, ???? convoy orchestration ???? ?? ??? ??? ????? ?????? ???? ??? ??? ???????, convoy orchestration ???? ???? ??? ?? ??? Orchestration ??????? ???? ?? ???? ??? ????? ?? ??? ?? ?? ?? ?? ?? zombie ????? ?? ??? ??? ???? ???? ???

Zombie ??????? ?? ?????, ?? ??? ????? MSDN ??? ???? ?? ????:

HTTP://blogs.MSDN.com/biztalk_core_engine/Archive/2004/06/30/169430.aspx (http://blogs.msdn.com/biztalk_core_engine/archive/2004/06/30/169430.aspx)

?? SQL ????? ?? BizTalk ????? ???????? ???????? ?? ????? ?? ???? ??

BizTalk ????? ???? ????, ???? ?? ?????? ????????? ?? ???????????? SQL ????? ?? ??? ?? ???? ?? ????? ??? SQL ????? ?? ??????? sustain ???? ?? ???? ??, ?? ?? BizTalk ????? ??????????? ?? ???????? ?? ????? ?? ????? ??????Avg. ????? ?????/?????, ??? ????? ?????/??????????, ??Avg. ????? ?????/???? ???????? ????????? countersPhysicalDisk???????? ?? ??????????? ??? ????????? ??? ??? ?? ?? 10 ms (?????????) ??? ???? ??? ?? 20 ms ?? ??? ???? ???????? ???? ???? ??

SQL ????? ??????????? ?? ???? ??? ???? ??????? ?? ??? ????? Microsoft ??? ???? ?? ????:

HTTP://TechNet.Microsoft.com/en-us/library/cc966540.aspx (http://technet.microsoft.com/en-us/library/cc966540.aspx)

BizTalk ????? 2004 ??????? ???? ???????? ?? ???? ??? ???? ??????? ?? ??? ????? MSDN ??? ???? ?? ????:

HTTP://MSDN.Microsoft.com/en-us/library/ms942187.aspx (http://msdn.microsoft.com/en-us/library/ms942187.aspx)

BizTalk ????? 2006 ??????? ???? ???????? ?? ???? ??? ???? ??????? ?? ??? ????? MSDN ??? ???? ?? ????:

HTTP://MSDN.Microsoft.com/en-us/library/aa559920.aspx (http://msdn.microsoft.com/en-us/library/aa559920.aspx)

???? ??????? ?? ???, Microsoft ?????? ??? ??? ???? ????? ?? ??? ????? ???? ?????? ????? ????::

298475� (http://support.microsoft.com/kb/298475/ ) SQL ????? ??????????? ?? ???????? ?? ?????? ???? ????

271509� (http://support.microsoft.com/kb/271509/ ) SQL ????? 2005 ?? SQL Server 2000 ??? ???????? ??????? ???? ?? ??? ???? ????

BizTalk ????? ??? ??????? ?????

?? SQL ????? ?? SQL Server ????? ??????? ???? ?????? SQL ????? ????? ??? ??? ??, ?? ??????? ?? ?????? ?? ??? ????????? ??? ?? ?????????? BizTalk SQL Server ????? ????? ???? ??? ????? ?? ??????? ?? ???? ??????? ??? ?????? ????, ?? ?? ?????? ???????? ???????? ?? ???? ?? ???? ??? BizTalk Server ??????? ?????? ?? ????????? ??? BizTalk ????? ?? ??? BizTalk ????? 2004 ?????? ??? 2 (SP2) ??? ?? ??? ?? ????? ???

SQL ????? LDF ?? MDF ??? ?????? ?? ??????? ????? ?? BizTalkMsgBoxDb ?? BizTalkDTADb ??????? ?? ??? LDF ?? MDF ??????? ?? ???? ?????? ???, ?? ???? ????? contention ?? ???? ????

??? ?? ???????? ????? ?? ????? ??? ?? ??? ????, ?? ?????? ????? ????? ?????, ?? ???? ?? ?? ????? ?? ????? ??? ???????? ???? ??? ?? ?????? ?? ???? ?????? ?? ???????? ?? ?????? ???? ??? ????? ???? ?? ???? ??? ?? ?? ???? ???, ?? ????????? ???? ?? ?? ????? ????? ???? ???????? ?? ?? ?????? ?? ???? ??? ?? ???????? ????? ?? ????? ??? ?????, BizTalk Server ??????? ?????? ??? ???? ??? ??? ?????????? ???? ?? ????? ???? ???????? ?????, TrackedMessages_Copy_BizTalkMsgBoxDb ?? DTA ?????? ?? SQL Server ????? ?????? ?? ????? ??????????? ??? ??? ??? ?? ?????? ???? ?? ??? ???????

??????????, ???? ????????? ??? ????? ????? ???????? ??? ???? ?? ??? ????????? ??? ????, ????? BizTalk ????? SQL Server ????? ????? ?? ???? ??? ????? ?? ??? ???????? ????? ???? ??????? ?? ???, ?????????? MSDN ??? ???? ?? ????::

HTTP://MSDN.Microsoft.com/en-us/library/bb743398.aspx (http://msdn.microsoft.com/en-us/library/bb743398.aspx)

?? ???? ?????? BizTalk ????? ????????? ?? ????????? ???? ?? ??? BizTalk ????? 2006 ????? ?????? ???????? (BPA) ?? ????? ?? ???? ??? BPA ?? ??????? ?? ??????? ???? ???? ???? ??? BPA ?? ???? ??? ???? ??????? ?? ??? ????? Microsoft ??? ???? ?? ????:

HTTP://www.Microsoft.com/downloads/details.aspx?FamilyID=93d432fe-1370-4b6d-aaa8-a0c43c30f5ab&displaylang=en (http://www.microsoft.com/downloads/details.aspx?FamilyID=93d432fe-1370-4b6d-aaa8-a0c43c30f5ab&displaylang=en)

????? ?? ???? ????

?????? ??????

??????? BizTalk ????? SQL Server ??????? ?? ??? ??? ?????? ?????? ??????? ??????, ???? ????? ?? ??? ?? ?? deadlocking ?? ?????? ?? ?????? ???? ???? ??? BizTalk Server ??????? ?????? ?? ?????? ?? ??? ????? ????? ?? ???? ?????

??? 1: ????? ?? ?? ??? ?????? BizTalk SQL Server ????? ????? ?????

All the BizTalk SQL Server Agent jobs except the MessageBox_Message_ManageRefCountLog_BizTalkMsgBoxDb job should be enabled and running successfully. Do not disable any other job.

If a failure occurs, use theView Historyoption in SQL Server to view the error information, and then troubleshoot the failure accordingly. Remember that the MessageBox_Message_ManageRefCountLog_BizTalkMsgBoxDb SQL Server Agent job runs infinitely. Therefore, you should only be concerned if the job history reports that the job constantly fails and restarts.

Step 2: Use the MsgBoxViewer tool

Collect MsgBoxViewer data while you reproduce an issue.

The MsgBoxViewer tool is useful for troubleshooting because it provides an HTML report that has detailed information about table sizes and the row count. The report can also help determine whether BizTalk Server is throttling. Additionally, the tool provides a snapshot of the BizTalk Server databases and the BizTalk Server configuration.

When you use the MsgBoxViewer tool, make sure that you click to select all queries on theOptional Queriestab for a complete analysis.

For more information about how to download the MsgBoxViewer tool, visit the following Microsoft Web site:

http://blogs.technet.com/jpierauc/pages/msgboxviewer.aspx (http://blogs.technet.com/jpierauc/pages/msgboxviewer.aspx)

For more information about throttling in BizTalk Server, visit the following MSDN Web site:

http://msdn.microsoft.com/en-us/library/aa559893.aspx (http://msdn.microsoft.com/en-us/library/aa559893.aspx)

When BizTalk Server is running slower than usual, run the MsgBoxViewer tool, click to select all queries on theOptional Queriestab, and then review the generated HTML report for any problems. ??Summary Reportsection lists warnings in yellow and potential problems in red.

Additionally, you can use the MsgBoxViewer tool output to determine which tables are the largest and have the most records. The following table lists the BizTalk Server tables that typically grow the largest. You can use this data to determine where a potential problem may exist.

?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????

??????	?????:
`????????`Q_Suspended	This table contains a reference to messages in the Spool table that are associated with suspended instances for the particular host. This table is in the BizTalkMsgBoxDb database.
`????????`Q	This table contains a reference to messages in the Spool table that are associated with the particular host and are not suspended. This table is in the BizTalkMsgBoxDb database.
Spool Parts Fragments	These tables store actual message data in the BizTalkMsgBoxDb database.
??????	This table stores all instances and their current status in the BizTalkMsgBoxDb database.
TrackingData_`x`_`x`	This table stores the tracked events in the BizTalkMsgBoxDb database for TDDS to move the events to the BizTalkDTADb database.
Tracking_Fragments`x` Tracking_Parts`x` Tracking_Spool`x`	Two of each of these tables are in the BizTalkMsgBoxDb and BizTalkDTADb databases. One is online, and the other is offline. In BizTalk Server 2004 SP2 and in later versions, the TrackedMessages_Copy_BizTalkMsgBoxDb SQL Server Agent job moves tracked message bodies directly to these tables in the BizTalkDTADb database. In BizTalk Server 2004 Service Pack 1 (SP1) and in earlier versions of BizTalk Server, the TrackedMessages_Copy_BizTalkMsgBoxDb SQL Server Agent job copies tracked message bodies into these tables in the BizTalkMsgBoxDb database.The TrackingSpool_Cleanup_BizTalkMsgBoxDb SQL Server Agent job purges the offline tables and makes the tables online while the job also takes the online tables offline.
dta_ServiceInstances	This table stores tracked events for service instances in the BizTalkDTADb database. If this table is large, the BizTalkDTADb database is probably large.
dta_DebugTrace	This table stores the Orchestration debugger events in the BizTalkDTADb database.
dta_MessageInOutEvents	This table stores tracked event messages in the BizTalkDTADb database. These tracked event messages include message context information.
dta_ServiceInstanceExceptions	This table stores error information for any suspended service instance in the BizTalkDTADb database.

?????????? ???????? ?? ????? ?????

`????????`Q_Suspended tables

???????????Q_Suspended tables have many records, the tables could be valid suspended instances that appear in the???? ??page or in HAT. You can terminate these instances. If these instances do not appear in the???? ??page or in HAT, the instances are probably caching instances or orphaned routing failure reports. When you terminate suspended instances, you clean up the items in this table and their associated rows in the Spool and Instances tables.

`????????`Q tables

???????????Q tables have many of records, the following kinds of instances may exist:

Ready-to-run instances
Active instances
Dehydrated instances

BizTalk Server needs time to "catch up" and process the instances. This table can grow when the incoming rate of processing outpaces the outgoing rate of processing. This scenario can occur when another problem occurs, such as a large BizTalkDTADb database or SQL Server disk delays.

Spool, Parts, and Fragments tables

If the Spool, Parts, and Fragments tables have many records, many messages are currently active, dehydrated, or suspended. Depending on the size, the number of parts, and the fragmentation settings in these tables, a single message may spawn all these tables. Each message has exactly one row in the Spool table and at least one row in the Parts table.

Instances table

The BizTalk Administrator should not allow for many suspended instances to remain in the Instances table. Many dehydrated instances should only remain if the business logic requires long-running orchestrations. Remember that one service instance can be associated with many messages in the Spool table.

TrackingData_`x`_`x`tables

If the TrackingData_x_xtables are large, the Tracking host (TDDS) is not running or is not running successfully. If the tracking host instance is running, review the event logs and the TDDS_FailedTrackingData table in the BizTalkDTADb database for error information.

Tracking_Spool1 or Tracking_Spool2 tables

If the Tracking_Spool1 or Tracking_Spool2 tables become large in BizTalk Server 2004 SP1 and in earlier versions of BizTalk Server, confirm that the TrackingSpool_Cleanup_BizTalkMsgBoxDb SQL Server Agent job is enabled and running.

???? ??????? ?? ???, Microsoft ?????? ??? ??? ???? ????? ?? ??? ????? ???? ?????? ????? ????::

907661� (http://support.microsoft.com/kb/907661/ ) BiztalkMsgBoxDb ??????? ??? Tracking_Spool1 ?? Tracking_Spool2 ???????? ??? BizTalk ????? 2004 ???? ??? ??

????? 2004 SP1 BizTalk ?? BizTalk ????? ?? ????? ????????? ???, ?? ??????? ???? ??? ?? BizTalkDTADb ??????? ???? ???? BizTalkMsgBoxDb ??????? ?? ????? ??? ?? ????? bodies ?? ?????? ?? ??? ?? ????? ??? ?? ????? bodies ?? ?????

???? ??????? ?? ???, ?????????? MSDN ??? ???? ?? ????::

HTTP://MSDN.Microsoft.com/en-us/library/ms966372.aspx (http://msdn.microsoft.com/en-us/library/ms966372.aspx)

dta_DebugTrace ??????

??? dta_DebugTrace ?????? ??? ???? ???????? ??, orchestration ??????? ????? ???? ?? ??? ?? ?? ????? ???? ?? ??? ??? ??? orchestration ??????? ???? ?????? ???????? ?? ??? ?????? ??, ?? orchestration ???? ???? ????? ????? ??? orchestration ???? ???? ????? ?? ?? ??? ???? backlog BizTalkMsgBoxDb ??????? ??? ????? ??, dta_DebugTrace ?????? TDDS dta_DebugTrace ?????? ??? ?? ???? ?? ?? ???? ?? ??? ???? ???? ?? ??????? ????? ???? ???? ?? ???? ????

???????? ??? ??, ??????? ???????? ????? ??? ??? ??????? ???????? ?????? ???? ??, ?? ????? ???? ?? ????? ???? ??????? ?? ???, Microsoft ?? ????? ??? ???? ?? ????::

HTTP://TechNet.Microsoft.com/en-us/library/bb203858.aspx (http://technet.microsoft.com/en-us/library/bb203858.aspx)

??? dta_DebugTrace ?????? ?? dta_messageInOutEvents ?????? BizTalkTrackingDb ??????? ??? ???? ??? ???, ?? ?? ?? ???? ??? ?? ???????? ?? ???????? ??? ?? ???????? ????? ??? ???? ?? ???? BizTalk 2004, ??? BizTalkDTADb ??????? ??? dtav_FindMessageFacts ????? dta_messageInOutEvents ?????? ?? ????? truncating. ?? ??????? ?? ????? ??? ???? ?? ??? ????? ????? ?? ???? ????:

???????? ????? ?? DTA ?????? ?? ?????? ?? ????? ?? ??? ?????
??? ?? dta_messageInOutEvents ?????? ?? ?? ???? ????? ???, ?????? ?? ?? dtav_FindMessageFacts ????? ?? ????? ??? ??? ???? ?? ???, ????? ????? ?? ???? ????::
1. ??? SQL Server BizTalkDTADb ??????? ??? dtav_FindMessageFacts ????? ????? ???
2. ????-????? ????dtav_FindMessageFacts?????, ????? ??????? ??????? ????-????? ????, ?? ???? ???SQL ????????? ????? ????. ??SQL ????????? ????? ????????? ????? ??? ???? ??, ??? ?? ???????? ????, ?? ???? ???OK.
3. ????? dtav_FindMessageFacts.sql ???, ?? ???? ??? ????? ??????????.
4. ????-????? ????dtav_FindMessageFacts?????, ?? ???? ??? ????? ?????????. ????? ????,??? ??????.

?? ???? ?????? ?? ???????? ?? ?? ?? ???? ???? ??? ?? dta_messageInOutEvents ?????? ?? ??, ?? ?? dta_url ?????? ?? ?? ???? ????? ???? dta_url ?????? BizTalk ????? 2004 ??? ????? ???

?? ?? ?????? ?? ???, ?? dtav_FindMessageFacts ????? re-create ???? ?? ???, ????? ????? ?? ???? ????:

SQL ????? ??? ??? ?? ?????? ?? ??????
??????????? ??????????? ???, ?? ??? ????BizTalkDTADb???????:.
???? ????? ?? dtav_FindMessageFacts.sql ????????? ?? ????????? ????? ?? ????? BizTalkDTADb ??????? ??? re-create ??????

???????? ????? ?? DTA ?????? ?? ?????? ?? ????? ?? ???????? ?????

????? ?? ???? ????

??????? ???? ????????????? ???????? ?? ???? ??? ???? ??????? ?? ??? ????? MSDN ??? ???? ?? ????:

HTTP://MSDN.Microsoft.com/en-us/library/aa559162.aspx (http://msdn.microsoft.com/en-us/library/aa559162.aspx)

dta_ServiceInstanceExceptions ??????

?? dta_ServiceInstanceExceptions ?????? ?????????? ???? ?????? ??? ?? ?????????? ??????? ?? ?? ?? ??????? ??? ?????

??? 3: deadlock ???????? ?? ???? ????

Deadlock ??? ???????? ??? SQL ????? ?? DBCC tracing ?? ????? ???? ???? deadlock ??????? SQLERROR ??? ???? ?? ??? ???? ???? ???

SQL ????? 2005 ??? ?? ??? ?? ????????? ???, ????? ??? ?????????:

DBCC TRACEON (1222,-1)

SQL Server 2000 ??? ????? ??? ????????? ????:

DBCC TRACEON (1204)

??? ??, ?? ???? ??????? ???? ?? ??? PSSDiag ?????? ?? ????? ?????????: Deadlock????? ???????: Deadlock ?????????

BizTalkMsgBoxDB ??????? ??? ?? ????-??? ?? ????-????????? ?????? ?????? ????????? (OLTP) ??????? ??? ??? deadlocking ???????? ??, ?? ?? deadlocking ?? internally ?? ??????? BizTalk ????? ????? ?? ??????? ?? ???? ??, ?? ??? ????????? ???? ?????? ??? ??? ???????? ???? ?? ?? ???? deadlock ?????? ?? ???? deadlock ?????? ??? investigating ??? ?? ????? ??? ??? ?? deadlock ?????? ?? ??? correlated ???? ??????

???? ??????? ?? ???, Microsoft ?????? ??? ??? ???? ????? ?? ??? ????? ???? ?????? ????? ????::

830232� (http://support.microsoft.com/kb/830232/ ) ???? ?????? ?????? PSSDIAG

????? ?? ???? ????

??? 4: ????? ??? ?? ??????????? ?? ??? ?????

?? ????? ?? ???? ??????? ?????? SQL ????? ??? ????? ????????? ?????????? (SPID) ?? ??? ?????? ?????? ????????? ?? ??????? ???? ?? ???? ???, SQL ??? ??? ?????? SPID ????????? ?? ??? ?? ?? ?? ????????? ???? ?? ??? SQL Profiler ??????

SQL ????? ??? ??? ?????? ?? ????????? ?????? ?? ?????? ?? ??? ??? Transact SQL ?? ????? ????? ????????? ????? ?? ?? ?????? ???? ?? ??? PSSDiag ?????? ?? ????? ?????

SQL ????? 2005 ??? ?? ??? ?? ????????? ???, ?? ????????? ?? ???? ???????? ??? ?? ????????? ?????????SPID ?? SPID ?? ???? ?????? ????????? ????????? ?? ???????? ??? ?? ?? ????????? ???? ?? ??? ??? ?? ??? ???

PSSDiag ?????? ?? ???? ??? ???? ??????? ?? ??? Microsoft ???????? ??? ???? ????? ?? ??? ????? ???? ?????? ?? ????? ????:

830232� (http://support.microsoft.com/kb/830232/ ) ???? ?????? ?????? PSSDIAG

????? ??? ?? ????????? ????????? ?? ???? ??? ???? ??????? ?? ??? ????? MSDN ??? ???? ?? ????:

HTTP://msdn2.Microsoft.com/en-us/library/ms181150.aspx (http://msdn2.microsoft.com/en-us/library/ms181150.aspx)

???:?? ?? ????? ?? ?? ?????? ?? SQL ????? ??? ????????? ??????, ?? ??????? ???? ??? ?? ?? Microsoft ?????? ?????? ???? ?? ?????? ????? Microsoft ?????? ?????? ???? ???? ??? PSSDiag ?????? ???????? ?? ???????? ???? ??? ??? ?? ???? ????

??? 5: BizTalk ????? 2004 SP2 ??????? ????

BizTalk ????? 2004 SP1 ??? ??? built-in ?????? ?? BizTalkDTADb ??????? ?? ??? ??????????? ?? ?????? ??? ?? ??????????? BizTalk ????? 2004 SP2 ?? ??? ????? ??? BizTalkDTADb ??????? ?? ???? ?? ???? ?? BizTalk ????? 2004 SP2 ?? ??????? ?? ?? ???? ?? ???? ??????? ????? ????????? purges BizTalkDTADb ????????

?? ?? ?? ???? ?? ?? ?? BizTalk ????? 2004 ?????? ??? 2 ??????? ????? ???????? ?? ???? ??? ???? ??????? ?? ??? Microsoft ???????? ??? ???? ????? ?? ??? ????? ???? ?????? ?? ????? ????:

940519� (http://support.microsoft.com/kb/940519/ ) ????? ???????? BizTalk ????? 2004 ?????? ??? 2 ??? ?? ReadmeS.htm ????? ??? ????? ???? ???

????? ?? ???? ????

?? ?? BizTalk ????? 2004 SP2 ??????? ??, ?? ??????? ???? ??? ?? ?? ????? ????? ?? ???? ????:

??????? ?? 894253 Microsoft ???????? ???? ??? ?????? ???????? ?? ???? ????? ??? SQL Server 2000 Bts_tracking_shrinkexistingdatabase.sql ????????? ?? ????????? ???? ?? ??? ?? ???????? ???? ??? ??? ????? ?? ???? ?????

???? ??????? ?? ???, Microsoft ?????? ??? ??? ???? ????? ?? ??? ????? ???? ?????? ????? ????::
894253� (http://support.microsoft.com/kb/894253/ ) FIX: dtasp_PruneTrackingdatabase() ???????? ????????? ?? ???? ?? BizTalk ????? 2004 ??? DTA ??????? ?? ??? ???? ?? ??? ?? ????
BizTalk ????? 2004 SP2 ?? ??????? ?????

???? ??????? ?? ???, Microsoft ?????? ??? ??? ???? ????? ?? ??? ????? ???? ?????? ????? ????::
888751� (http://support.microsoft.com/kb/888751/ ) BizTalk ????? 2004 ?? ?????? ?????? ??? ?? ??????? ???? ?? ??? ???? ????

????? ?? ???? ????

??? ???? ?????

??? ??????? ???? ??? ???, ?? ??? ???? ?? ????? ?? ??? ?????? ??????? ???? ??, ??? ?? ???? ?? ??? ???? ????

??????????? ?? ???? ?? ????? ???? ?? ??????? ??? ???? ???? ?????????? ??????? ?? ?? ??? ???? ?? ???????? ???

????? ?? ?????? BizTalkMsgBoxDb ???????

???? ??????? ?? ???, Microsoft ?????? ??? ??? ???? ????? ?? ??? ????? ???? ?????? ????? ????::

924715� (http://support.microsoft.com/kb/924715/ ) FIX: ?? BizTalk ????? 2006 ??????? ??????? ??? ???? ???? ????? ???? ?? ???????? ??????? ?? ?? bts_CleanupMsgbox ????? ?? ??? ????? ???????? ?????????

BizTalkMsgBoxDb ??????? ?? ??? ???? ?? ????? ?? ??? ????? ????? ?? ???? ????:

???:?? ?????? ?? ??? ????? ?? ????? ??? ??????? ?????? ???, ????? ????? ?? ???? ???? ???

??? BizTalk Server ??????? ?? ????? ????
Msgbox_cleanup_logic.sql ????????? ?? ????????? ???????????: \Program Files\Microsoft BizTalk 200xSQL ????? ?? ??? \schema.
????????? bts_CleanupMsgbox ???????? ????????? ?? ?????? ???? ?? ??? BizTalkMsgBoxDb ??????? ?? ??????? ?? SQL ????????? ???
??? BizTalk ???????, ??????, ?? ????? ??? ??????? ?? ??? ????? ??? ?? HTTP ?? SOAP ??????? ?????, IIS ?????? ???????? ?????
??? BizTalkMsgBoxDb ??????? ?? bts_CleanupMsgbox ???????? ????????? ????????? ?????
??? ??????? ?? BizTalk ????? ?????? ???????? ?????

???????? ?? ?????? BizTalkDTADb ???????

BizTalkDTADb ??????? ?? ??? ???? ?? ????? ?? ??? ?? ????? ??????? ??? ?? ???? ?? ?? ????? ?? ???? ??:

???:????? ??????? ??? ??????? ?? ??? ????

?????? 1::
1. ??? BizTalk Server ??????? ?? ????? ????
2. Dtasp_PurgeAllCompletedTrackingData ???????? ????????? ????????? ????? Dtasp_PurgeAllCompletedTrackingData ???????? ????????? ?? ???? ??? ???? ??????? ?? ??? ????? MSDN ??? ???? ?? ????:
  HTTP://MSDN.Microsoft.com/en-us/library/aa561918.aspx (http://msdn.microsoft.com/en-us/library/aa561918.aspx)
  ???:?? ?????? ????? ??? ??????? ?? ????? ???
???? 2:
1. ??? BizTalk ??????? ?? ????? ????
2. Dtasp_CleanHMData ???????? ????????? ????????? ????? ??? BizTalkDTADb ??????? ??? ?? ?????? ?????????? ??????? ?????? ?? ?? ???? ?? ?????? ?? ????? ?????
  
  ??? ???? ?? ???, ????? ????? ?? ???? ????::
  1. ??? BizTalk ???????, ??????, ?? ????? ??? ??????? ?? ??? ????? ??? ?? HTTP ?? SOAP ??????? ?????, IIS ?????? ???????? ?????
  2. Dtasp_CleanHMData ???????? ????????? BizTalkDTADb ??????? ?? ????????? ?????
  3. ??? ??????? ?? BizTalk ????? ?????? ???????? ?????

???? BizTalk ????? 2004 ???

BizTalk ????? 2004 ??? BizTalkDTADb ??????? ?? ??? ???? ?? ????? ?? ??? ????? ????? ?? ???? ????:

???:?? ?????? ????? ??? ??????? ?? ????? ???

??? BizTalk Server ??????? ?? ????? ????
??? BizTalk ???????, ??????, ?? ????? ??? ??????? ?? ??? ????? ??? ?? HTTP ?? SOAP ??????? ?????, IIS ?????? ???????? ?????
??????? ?? 894253 Microsoft ???????? ???? ??? ?????? ???????? ?? ???? ????? ??? SQL Server 2000 Bts_tracking_shrinkexistingdatabase.sql ????????? ????? ?? ??? ?? ???????? ???? ??? ??? ????? ?? ???? ?????

???? ??????? ?? ???, Microsoft ?????? ??? ??? ???? ????? ?? ??? ????? ???? ?????? ????? ????::
894253� (http://support.microsoft.com/kb/894253/ ) FIX: dtasp_PruneTrackingdatabase() ???????? ????????? ?? ???? ?? BizTalk ????? 2004 ??? DTA ??????? ?? ??? ???? ?? ??? ?? ????
??? ??????? ?? BizTalk ?????? ???????? ?????

???:??? ???? ???????? ???? ?????, BizTalkDTADb ??????? ?? ???? ?? ??? ???? ???? SQL Server ??????? ???????????? ????, ?? ??? ??? BizTalkDTADb ??????? purge.

??? ?? ????? ??? MsgBoxViewer ???? ?? PSSDiag ?????? ?? ???????? ?? ??? ??, ?? Microsoft ?????? ?????? ???? ?? ?????? ????? ?????? ?????? ???? ?? ??? ?????? ?? ?????? ????? ?? ???? ??? ??????? ?? ???? ????, ?? ??? ????? Microsoft ??? ???? ?? ????:

http://support.microsoft.com/contactus/?ws=support (http://support.microsoft.com/contactus/?ws=support)

???:???? ???? ?? ?? ?????? ?????? ???? ?? ?????? ????, MsgBoxViewer ????, PSSDiag ??????, ?? ?????? ?? ?? ????? ??? (.evt ???????) ??????? ????? ?? ?? ??????? ?? ???? BizTalk ????? ?? ??? ?????? ???????? ?? ????? ?? ???? ???

????? ?? ???? ????

???? ???? ???? ??:

Microsoft BizTalk Server 2009 Enterprise
Microsoft BizTalk Server 2009 Developer
Microsoft BizTalk Server 2009 Standard
Microsoft BizTalk Server 2009 Branch
Microsoft BizTalk Server 2006 R2 Enterprise Edition
Microsoft BizTalk Server 2006 R2 Developer Edition
Microsoft BizTalk Server 2006 R2 Standard Edition
Microsoft BizTalk Server 2006 Enterprise Edition
Microsoft BizTalk Server 2006 Developer Edition
Microsoft BizTalk Server 2006 Standard Edition
Microsoft BizTalk Server 2004 Enterprise Edition
Microsoft BizTalk Server 2004 Developer Edition
Microsoft BizTalk Server 2004 Standard Edition

????? ?? ???? ????

kbPubTypeKC kbinfo kbhowto kbmt KB952555 KbMthi

????? ?? ???? ????

???? ?????? ????????

??????????: ?? ???? ?? ???? ??????? ?? ????? ?? Microsoft ????-?????? ?????????? ?????? ?????? ???? ??? ??. Microsoft ???? ??? ????-???????? ?? ????-???????? ????? ?????? ?? ???? ???????? ???? ?? ???? ????? ????? ??? ?? ??? ?????? ?? ???? ???? ???? ??? ????? ??. ???????, ????-???????? ???? ????? ???? ???? ???? ???. ?????, ????????, ?????-???? ?? ??????? ?? ???????? ?? ???? ???, ???? ?? ??? ?????? ???? ???? ??? ????? ??? ?? ???? ??. Microsoft ??????? ??? ???? ?? ?????? ?? ??????????, ????????? ?? ??? ?????? ?? ???? ????? ?? ???? ???????? ?? ??? ???? ????? ?? ??? ????????? ???? ??. Microsoft ????-?????? ?????????? ?? ????? ?????? ?? ?? ??? ??.

?????????? ?? ??????? ????????? ??????? ??:952555� (http://support.microsoft.com/kb/952555/en-us/ )

????? ?? ???? ????

This site in other countries/regions:

???? ???? ?? BizTalk Server ??????? ???????? ?? ?????? ???? ????

?? ????? ??

??????

?????

???? ???????

????? ?????

????: ?????? ?????? ?? ????? ????? ?????? ?????? ?? ????? ???? ????

?????? ??? Parallelism ?? ??? ???? ?????????? ?????? ??

??? ?? ?? ?? ???? ??? ?? BizTalk ????? ????????????? ????????? ????

??????, deadlocking ?? ????? ?? ??? ?? ???? ??

???? ??????? ?? ?????? ?? ??? ?????? ????? ?? ???? ???

Use the correct BizTalk SQL Server Agent jobs

???? ?????????? ??????? ???? ?? ???? ??

?? SQL ????? ?? BizTalk ????? ???????? ???????? ?? ????? ?? ???? ??

BizTalk ????? ??? ??????? ?????

?????? ??????

??? 1: ????? ?? ?? ??? ?????? BizTalk SQL Server ????? ????? ?????

Step 2: Use the MsgBoxViewer tool

`????????`Q_Suspended tables

`????????`Q tables

Spool, Parts, and Fragments tables

Instances table

TrackingData_`x`_`x`tables

Tracking_Spool1 or Tracking_Spool2 tables

dta_DebugTrace ??????

dta_ServiceInstanceExceptions ??????

??? 3: deadlock ???????? ?? ???? ????

??? 4: ????? ??? ?? ??????????? ?? ??? ?????

??? 5: BizTalk ????? 2004 SP2 ??????? ????

??? ???? ?????

????? ?? ?????? BizTalkMsgBoxDb ???????

???????? ?? ?????? BizTalkDTADb ???????

???? BizTalk ????? 2004 ???

???? ???? ???? ??:

??????:�

???? ?????? ??????

??????

??? ?????? ??????? ????

???? ??????

This site in other countries/regions:

???? ???? ?? BizTalk Server ??????? ???????? ?? ?????? ???? ????

?? ????? ??

??????

?????

???? ???????

????? ?????

????: ?????? ?????? ?? ????? ????? ?????? ?????? ?? ????? ???? ????

?????? ??? Parallelism ?? ??? ???? ?????????? ?????? ??

??? ?? ?? ?? ???? ??? ?? BizTalk ????? ????????????? ????????? ????

??????, deadlocking ?? ????? ?? ??? ?? ???? ??

???? ??????? ?? ?????? ?? ??? ?????? ????? ?? ???? ???

Use the correct BizTalk SQL Server Agent jobs

???? ?????????? ??????? ???? ?? ???? ??

?? SQL ????? ?? BizTalk ????? ???????? ???????? ?? ????? ?? ???? ??

BizTalk ????? ??? ??????? ?????

?????? ??????

??? 1: ????? ?? ?? ??? ?????? BizTalk SQL Server ????? ????? ?????

Step 2: Use the MsgBoxViewer tool

????????Q_Suspended tables

????????Q tables

Spool, Parts, and Fragments tables

Instances table

TrackingData_x_xtables

Tracking_Spool1 or Tracking_Spool2 tables

dta_DebugTrace ??????

dta_ServiceInstanceExceptions ??????

??? 3: deadlock ???????? ?? ???? ????

??? 4: ????? ??? ?? ??????????? ?? ??? ?????

??? 5: BizTalk ????? 2004 SP2 ??????? ????

??? ???? ?????

????? ?? ?????? BizTalkMsgBoxDb ???????

???????? ?? ?????? BizTalkDTADb ???????

???? BizTalk ????? 2004 ???

???? ???? ???? ??:

??????:�

???? ?????? ??????

??????

??? ?????? ??????? ????

???? ??????

`????????`Q_Suspended tables

`????????`Q tables

TrackingData_`x`_`x`tables