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

???? ?????? ???? ??????
???? ID: 952555 - ?? ???????? ?? ?????? ??? ?? ?? ???? ???? ???? ??.
??? ?? ??????? ???? | ??? ?? ??????? ????

?? ????? ??

??????

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???????? ?? ????? ???? ???, ??????, ?? ???? SQL ????? ?????? deadlock BizTalk ????? 2006 ?? BizTalk ????? 2004 ??? BizTalkMsgBoxDb ??????? ?? ?????? ???? ?? ?????? ???? ???
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 ?????? ??? ??? ???? ????? ?? ??? ????? ???? ?????? ????? ????::
899000SQL ????? ?? BizTalk ????? ?? ???????? ???? ?? ?????? ?? ??? Parallelism ??????
917845???????? ?? ????? ???? ???, ??????, ?? ???? SQL ????? ?????? deadlock BizTalk ????? 2006 ?? BizTalk ????? 2004 ??? BizTalkMsgBoxDb ??????? ?? ?????? ???? ?? ?????? ???? ???

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

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

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

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

???? ??????? ?? ???, Microsoft ?????? ??? ??? ???? ????? ?? ??? ????? ???? ?????? ????? ????::
917845???????? ?? ????? ???? ???, ??????, ?? ???? SQL ????? ?????? deadlock BizTalk ????? 2006 ?? BizTalk ????? 2004 ??? BizTalkMsgBoxDb ??????? ?? ?????? ???? ?? ?????? ???? ???
DBCC SHOWCONTIG ??? ?????? ?? ???????? ???? ?? ??? ???? ???? ?? ???? ??? ???? ??????? ?? ??? ????? Microsoft ??? ???? ?? ????:
HTTP://TechNet.Microsoft.com/en-us/library/cc966523.aspx

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

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

???? ??????? ?? ???, Microsoft ?????? ??? ??? ???? ????? ?? ??? ????? ???? ?????? ????? ????::
917845???????? ?? ????? ???? ???, ??????, ?? ???? SQL ????? ?????? deadlock BizTalk ????? 2006 ?? BizTalk ????? 2004 ??? BizTalkMsgBoxDb ??????? ?? ?????? ???? ?? ?????? ???? ???

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

???? ???? ??? ?? ?? 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
??? BizTalk ????? 2004 SQL Server ????? ????? ?? ???? ??? ???? ??????? ?? ??? Microsoft ???????? ??? ???? ????? ?? ??? ????? ???? ?????? ?? ????? ????:
919776BizTalk ????? 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
?????? ???????????? ??? ????? ???????? ???????, ?? ?? ???? ??????? ?? ?????????? ?????? ?? ??????? ?? ???????? ?? ???? ?????? ??? ?????? ?? ??????? ???? ??? BizTalk ????? 2006 ??? ??? ???? ???????? ?? ??? ?? zombie ??????? ?? ????? ?? ??? 936536 Microsoft ???????? ???? ??? ?????? ???????? ?? ???? ????? ?? ?????? ?? BizTalk 2006 R2 ????? ??? ?? ??? ??? ??? ???? ??? ???

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

???? ??????? ?? ???, Microsoft ?????? ??? ??? ???? ????? ?? ??? ????? ???? ?????? ????? ????::
936536FIX: ?? BizTalk ????? 2006 ?? ???????? ???????? ?? ????? ?? ????????? ????? ???????? ??? ????? ??? ??? ?? ???
?? ??? BizTalk ????? ????? ??????? ??????, ?????????? ?? ??? ???? ?????? ?? ???? ??? BizTalk ????? 2006 ?? BizTalk 2006 R2 ????? ??? ?? ??????? ?? ?????? ?? ??? 944426 Microsoft ???????? ???? ??? ?????? ???????? ?? ???? ????? BizTalk ????? 2009 ??? ?? ?????? ?? ??? ???? ??? ???

???? ??????? ?? ???, Microsoft ?????? ??? ??? ???? ????? ?? ??? ????? ???? ?????? ????? ????::
944426FIX: Orphaned ??? ?????????? ?????????? ?????? ??? BizTalk ????? 2006 BizTalkMsgBoxDb ??????? ??? ????? ?? ???? ?? ???? ??
???? ???? ?? ?????? ?? ?? ?????? ???? ??????? (RFRs) ?? ???? ?? ????? BizTalkHostQ ?? BizTalkHostQ_Suspended ???????? ??? ??? RFRs ???? ????? ??? ???? ???, ?? ?? ??????? BizTalkMsgBoxDb ??????? ?? ????? ?? ???? ?? ???? ??? BizTalk ????? 2006 ??? ?? ?????? ?? ???, 941690 Microsoft ???????? ???? ??? ?????? ???????? ?? ???? ????? ?? ?????? ?? BizTalk 2006 R2 ????? ??? ?? ??? ??? ??? ???? ??? ???

???? ??????? ?? ???, Microsoft ?????? ??? ??? ???? ????? ?? ??? ????? ???? ?????? ????? ????::
941690FIX: ?????? ???? ??????? ??? ???? ?????? <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

?? 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
BizTalk ????? 2004 ??????? ???? ???????? ?? ???? ??? ???? ??????? ?? ??? ????? MSDN ??? ???? ?? ????:
HTTP://MSDN.Microsoft.com/en-us/library/ms942187.aspx
BizTalk ????? 2006 ??????? ???? ???????? ?? ???? ??? ???? ??????? ?? ??? ????? MSDN ??? ???? ?? ????:
HTTP://MSDN.Microsoft.com/en-us/library/aa559920.aspx
???? ??????? ?? ???, Microsoft ?????? ??? ??? ???? ????? ?? ??? ????? ???? ?????? ????? ????::
298475SQL ????? ??????????? ?? ???????? ?? ?????? ???? ????
271509SQL ????? 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
?? ???? ?????? BizTalk ????? ????????? ?? ????????? ???? ?? ??? BizTalk ????? 2006 ????? ?????? ???????? (BPA) ?? ????? ?? ???? ??? BPA ?? ??????? ?? ??????? ???? ???? ???? ??? BPA ?? ???? ??? ???? ??????? ?? ??? ????? Microsoft ??? ???? ?? ????:
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
For more information about throttling in BizTalk Server, visit the following MSDN Web site:
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_SuspendedThis 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.
????????QThis 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_xThis table stores the tracked events in the BizTalkMsgBoxDb database for TDDS to move the events to the BizTalkDTADb database.
Tracking_Fragmentsx
Tracking_Partsx
Tracking_Spoolx
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_ServiceInstancesThis table stores tracked events for service instances in the BizTalkDTADb database. If this table is large, the BizTalkDTADb database is probably large.
dta_DebugTraceThis table stores the Orchestration debugger events in the BizTalkDTADb database.
dta_MessageInOutEventsThis table stores tracked event messages in the BizTalkDTADb database. These tracked event messages include message context information.
dta_ServiceInstanceExceptionsThis 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_xtables
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 ?????? ??? ??? ???? ????? ?? ??? ????? ???? ?????? ????? ????::
907661BiztalkMsgBoxDb ??????? ??? Tracking_Spool1 ?? Tracking_Spool2 ???????? ??? BizTalk ????? 2004 ???? ??? ??
????? 2004 SP1 BizTalk ?? BizTalk ????? ?? ????? ????????? ???, ?? ??????? ???? ??? ?? BizTalkDTADb ??????? ???? ???? BizTalkMsgBoxDb ??????? ?? ????? ??? ?? ????? bodies ?? ?????? ?? ??? ?? ????? ??? ?? ????? bodies ?? ?????

???? ??????? ?? ???, ?????????? MSDN ??? ???? ?? ????::
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
??? dta_DebugTrace ?????? ?? dta_messageInOutEvents ?????? BizTalkTrackingDb ??????? ??? ???? ??? ???, ?? ?? ?? ???? ??? ?? ???????? ?? ???????? ??? ?? ???????? ????? ??? ???? ?? ???? BizTalk 2004, ??? BizTalkDTADb ??????? ??? dtav_FindMessageFacts ????? dta_messageInOutEvents ?????? ?? ????? truncating. ?? ??????? ?? ????? ??? ???? ?? ??? ????? ????? ?? ???? ????:
  1. ???????? ????? ?? DTA ?????? ?? ?????? ?? ????? ?? ??? ?????
  2. ??? ?? 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 ???? ?? ???, ????? ????? ?? ???? ????:
  1. SQL ????? ??? ??? ?? ?????? ?? ??????
  2. ??????????? ??????????? ???, ?? ??? ????BizTalkDTADb???????:.
  3. ???? ????? ?? dtav_FindMessageFacts.sql ????????? ?? ????????? ????? ?? ????? BizTalkDTADb ??????? ??? re-create ??????
???????? ????? ?? DTA ?????? ?? ?????? ?? ????? ?? ???????? ?????
??????? ???? ????????????? ???????? ?? ???? ??? ???? ??????? ?? ??? ????? MSDN ??? ???? ?? ????:
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???? ?????? ?????? PSSDIAG

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

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

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

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

PSSDiag ?????? ?? ???? ??? ???? ??????? ?? ??? Microsoft ???????? ??? ???? ????? ?? ??? ????? ???? ?????? ?? ????? ????:
830232???? ?????? ?????? PSSDIAG
????? ??? ?? ????????? ????????? ?? ???? ??? ???? ??????? ?? ??? ????? MSDN ??? ???? ?? ????:
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????? ???????? BizTalk ????? 2004 ?????? ??? 2 ??? ?? ReadmeS.htm ????? ??? ????? ???? ???
?? ?? BizTalk ????? 2004 SP2 ??????? ??, ?? ??????? ???? ??? ?? ?? ????? ????? ?? ???? ????:
  1. ??????? ?? 894253 Microsoft ???????? ???? ??? ?????? ???????? ?? ???? ????? ??? SQL Server 2000 Bts_tracking_shrinkexistingdatabase.sql ????????? ?? ????????? ???? ?? ??? ?? ???????? ???? ??? ??? ????? ?? ???? ?????

    ???? ??????? ?? ???, Microsoft ?????? ??? ??? ???? ????? ?? ??? ????? ???? ?????? ????? ????::
    894253FIX: dtasp_PruneTrackingdatabase() ???????? ????????? ?? ???? ?? BizTalk ????? 2004 ??? DTA ??????? ?? ??? ???? ?? ??? ?? ????
  2. BizTalk ????? 2004 SP2 ?? ??????? ?????

    ???? ??????? ?? ???, Microsoft ?????? ??? ??? ???? ????? ?? ??? ????? ???? ?????? ????? ????::
    888751BizTalk ????? 2004 ?? ?????? ?????? ??? ?? ??????? ???? ?? ??? ???? ????

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

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

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

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

???? ??????? ?? ???, Microsoft ?????? ??? ??? ???? ????? ?? ??? ????? ???? ?????? ????? ????::
924715FIX: ?? BizTalk ????? 2006 ??????? ??????? ??? ???? ???? ????? ???? ?? ???????? ??????? ?? ?? bts_CleanupMsgbox ????? ?? ??? ????? ???????? ?????????
BizTalkMsgBoxDb ??????? ?? ??? ???? ?? ????? ?? ??? ????? ????? ?? ???? ????:

???:?? ?????? ?? ??? ????? ?? ????? ??? ??????? ?????? ???, ????? ????? ?? ???? ???? ???
  1. ??? BizTalk Server ??????? ?? ????? ????
  2. Msgbox_cleanup_logic.sql ????????? ?? ????????? ???????????: \Program Files\Microsoft BizTalk 200xSQL ????? ?? ??? \schema.
  3. ????????? bts_CleanupMsgbox ???????? ????????? ?? ?????? ???? ?? ??? BizTalkMsgBoxDb ??????? ?? ??????? ?? SQL ????????? ???
  4. ??? BizTalk ???????, ??????, ?? ????? ??? ??????? ?? ??? ????? ??? ?? HTTP ?? SOAP ??????? ?????, IIS ?????? ???????? ?????
  5. ??? BizTalkMsgBoxDb ??????? ?? bts_CleanupMsgbox ???????? ????????? ????????? ?????
  6. ??? ??????? ?? BizTalk ????? ?????? ???????? ?????

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

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

???:????? ??????? ??? ??????? ?? ??? ????
  • ?????? 1::
    1. ??? BizTalk Server ??????? ?? ????? ????
    2. Dtasp_PurgeAllCompletedTrackingData ???????? ????????? ????????? ????? Dtasp_PurgeAllCompletedTrackingData ???????? ????????? ?? ???? ??? ???? ??????? ?? ??? ????? MSDN ??? ???? ?? ????:
      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 ??????? ?? ??? ???? ?? ????? ?? ??? ????? ????? ?? ???? ????:

???:?? ?????? ????? ??? ??????? ?? ????? ???
  1. ??? BizTalk Server ??????? ?? ????? ????
  2. ??? BizTalk ???????, ??????, ?? ????? ??? ??????? ?? ??? ????? ??? ?? HTTP ?? SOAP ??????? ?????, IIS ?????? ???????? ?????
  3. ??????? ?? 894253 Microsoft ???????? ???? ??? ?????? ???????? ?? ???? ????? ??? SQL Server 2000 Bts_tracking_shrinkexistingdatabase.sql ????????? ????? ?? ??? ?? ???????? ???? ??? ??? ????? ?? ???? ?????

    ???? ??????? ?? ???, Microsoft ?????? ??? ??? ???? ????? ?? ??? ????? ???? ?????? ????? ????::
    894253FIX: dtasp_PruneTrackingdatabase() ???????? ????????? ?? ???? ?? BizTalk ????? 2004 ??? DTA ??????? ?? ??? ???? ?? ??? ?? ????
  4. ??? ??????? ?? BizTalk ?????? ???????? ?????
???:??? ???? ???????? ???? ?????, BizTalkDTADb ??????? ?? ???? ?? ??? ???? ???? SQL Server ??????? ???????????? ????, ?? ??? ??? BizTalkDTADb ??????? purge.

??? ?? ????? ??? MsgBoxViewer ???? ?? PSSDiag ?????? ?? ???????? ?? ??? ??, ?? Microsoft ?????? ?????? ???? ?? ?????? ????? ?????? ?????? ???? ?? ??? ?????? ?? ?????? ????? ?? ???? ??? ??????? ?? ???? ????, ?? ??? ????? Microsoft ??? ???? ?? ????:
http://support.microsoft.com/contactus/?ws=support
???:???? ???? ?? ?? ?????? ?????? ???? ?? ?????? ????, MsgBoxViewer ????, PSSDiag ??????, ?? ?????? ?? ?? ????? ??? (.evt ???????) ??????? ????? ?? ?? ??????? ?? ???? BizTalk ????? ?? ??? ?????? ???????? ?? ????? ?? ???? ???

???

???? ID: 952555 - ????? ???????: 07 ?????? 2010 - ??????: 2.0
???? ???? ???? ??:
  • 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

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

 

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