????? ??????

Select the product you need help with

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

???? ???????: 952555 - ??? ???????? ???? ????? ????? ??? ???????.

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

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

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

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

??? ????? ????? ?????????? ???????? ? ????? ?????? ?????????? ?????? Microsoft SQL Server.
??? ????? ???? Max ??????? ??????? ???? ????.
????? ??? ????? ????? ??????? BizTalk Server.
?? ???? ????? deadlocking ?? ?????.
?? ????? ?????? ?? ????? ???????? ??????? ?? ???????.
???? ???? SQL BizTalk Server
???? ?????? ??????.
?? ????? ?????? ?? ?????? SQL Server ? BizTalk Server.
??? ???? ????? ???? ????????? ?? BizTalk Server.

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

?????

???? ??? ??????? ????? ??????? ????? ????? ????? ???????? BizTalk Server ?????? ?????? ??? ????? ???????? BizTalk Server.

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

??????? ????

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

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

??? ????? ????? ?????? ?????????? ? ????? ?????????? ???????? ?????? ?? ????? ???????? ????????????????. ?????? ?? ??? ?? ????? ??? ?????????? ????? ????????? ??????? ??????? ?? SQL Server:

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

??? ????? ????? ???????????? ??? ?????. ??? ?? ????? ??? ??????? ??? ???? ????? ??????? ?????? ????????? ??????? ??????? ?? SQL Server:

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

????? ?? ?????????? ???? ??? ????? ???????? ??????? ???? ???????? ?? ????? ????? Microsoft:

917845

(http://support.microsoft.com/default.aspx?scid=kb;EN-US;917845)

????? ???? deadlock ?????? ?? ?????? SQL Server ???? ??? ?????? ??????? ?????? ???????? "????????????????" ?? BizTalk Server

912262

(http://support.microsoft.com/default.aspx?scid=kb;EN-US;912262)

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

??? ????? ???? Max ??????? ??????? ???? ????

??? ????????? ???? ?????? SQL Server ???????? ????? ?????? ????????????????? ????? ???? Max ??????? ????? run_value ? config_value ??? ???? 1. ????? ???? Max ??????? ???????? ?? ?????? ?? ??? ????? ??????? ?? ??????? ????? ???????? ?? SQL Server:

exec sp_configure 'max degree of parallelism'

??? ?? ??? ????? ????? run_value ? config_value ????? 1? ????? ??????? ?????? ?? SQL Server ??? ??????? ??? 1:

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

????? ?? ?????????? ???? ??? ????? ???????? ??????? ???? ???????? ?? ????? ????? Microsoft:

899000

(http://support.microsoft.com/default.aspx?scid=kb;EN-US;899000)

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

917845

(http://support.microsoft.com/default.aspx?scid=kb;EN-US;917845)

????? ???? deadlock ?????? ?? ?????? SQL Server ???? ??? ?????? ??????? ?????? ???????? "????????????????" ?? BizTalk Server

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

?? ????? ???? ??????? BizTalk Server (???? ????: 1). ????? ??????? ????? SQL Server ?? DBCC ????????? ???? ??????? ????? ??????? BizTalk Server.

???? ??????? BizTalk Server ?????? ??? GUID. ????? ???? ?? ???? ???????. ??? ???? ???? "????? ????? ??????" ???? ??? ??????? ?????? ??????? ????????? DBCC ??? ?? 30 ?? ??????? ???? ????? ????? ??????? BizTalk Server ????? ??? ?????? ?? ?????.

????? ??????? BizTalk Server ?????? ?? ??????? ???? ?????? ??????? ??? ????????. ?? ???? ????? ????? ??? ???????? ?? ??? ???????. ????? ??? ??? ????? ????? BizTalk Server ????? BizTalk Server ??????? ??????.

????? ?? ?????????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:

917845

(http://support.microsoft.com/default.aspx?scid=kb;EN-US;917845)

????? ???? deadlock ?????? ?? ?????? SQL Server ???? ??? ?????? ??????? ?????? ???????? "????????????????" ?? BizTalk Server

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

http://technet.microsoft.com/en-us/library/cc966523.aspx

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

?? ???? ????? deadlocking ?? ???

????????? ???? ??????? ???? ?? ???? BizTalk Server. ??? ????? ?? ???? ???? ??? ??????? ?? ??? ????? ?????. ????? ??? ? deadlocking ??? ????? ??????.

????? ?? ?????????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:

917845

(http://support.microsoft.com/default.aspx?scid=kb;EN-US;917845)

????? ???? deadlock ?????? ?? ?????? SQL Server ???? ??? ?????? ??????? ?????? ???????? "????????????????" ?? BizTalk Server

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

????? ?? ??? ????? ???????? ???????????????? ???? ?? 5 ????????? ???? ?? ???? ????? ??????. ????????? ????? ???????? ???????????????? ??? ??? ????? ??? ??????. ????? ?????? ???????????????? ????? ???? ???? ??? ??? ?????? ???????? ?? ????? ??? ????? ???????? ????????????.

?? ???? ???? ???? ?????? ???? SQL ????? ?? ??????? ??????? ? orchestrations ???? ?????? ?? ????? ?????? ???????????????? ???? ?? 5 ????????. ??? ?? ???? ???? ????? ?????? orchestrations ???? ?? ????? ?????? ???????????????? ???? ????? ?? 5 ????????.

?? ??? ????? ??? ?? ????? ???????? ????????????. ??? ????? ?? ???? ????? ??????? ????? ???????? ??? ?????? ???? ????. ????? ??? ?????? ???????? 15 ??? 20 ???????? ???? ????. ??? ??? ???? ????? ?????? ????? BizTalk Server? ?? ?????? ???????? ???????:

????? ????? ??? ????? ???????? ????????????????. ??? ????? ?? ???? ??? ????? ???? ???????? ???? ?????.
BizTalk Server ????? ???? ?? ??????? ??????? ??? ??????? ???? ????? ?????.
????????? ????? ????? ???? (????) ?????? ????? ???? ?? ??????? ???? ????? ????.
?? ??? ?????? ??? ??? ????? ????????.
????? ???? ???? ???? SQL BizTalk ???? ?? ???????.
??? ??????? ???? ????? ?? ?????? ???? ????? ???? ???? ?????? ????????.

???? ?? ???? ????? ?????? ????? ?????? ??????. ?? ????? ??? ??????? ???????:

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

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

???? ???????? ??? ????? ???? ??? ?????? ?????????. ????? BizTalk ?????? ????? ?????? ?????? ?? ?????? ??? ???? ????. ??? ????? "????"? ???? ???????? ?? ????? ?????? (???) ??? ?????? ????? ???????? ?? ????? ???????? ???????????????? ??? ????? ???????? ????????????. ??? ?? ????? ?????? ??????? ??? ??? ???????? ??? ????? ???????? ???????????? ? TrackingData_x_x ?????? ??????? ?? ????? ???????? ????????????????.

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

???? ?? ???? ???? ???? ????? ???? ?? ????. ?? ???? ?? ??? ???? ?? ?????? ???? ???? ????? ????. ???????? ??? ???? ????? ??? ????? ?? ?????? ???? ??? ????? ?? ??? ?? ???????? ?? ??????. ??? ???? ??????? ????? ???? dta_DebugTrace ????? ????? ???? ?? ?? ???? ???? ????? ????. A ??? ??????????? ?????? Q_Suspended ???? ????? ??? ???? ???? ?? 200 ??? ???? ???? ????? ????.

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

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

?? ????? ????????? BizTalk Server ???? ???? SQL ???? ?? ??????? ?????? ??????? ?????? ????? ????????? ?????? ???????? BizTalk Server. ????? ??? ?????? ???? ????? ???????? BizTalk Server ??????? "???? ????????? ??????". ??? ????? ??? ?????? ????? BizTalk Server ????. ???? ??????? ?????? SQL Server ?????? ??? ??????? ????? ???????? BizTalk Server ??? ??? ?? ????? ????? ???? SQL Server ???? ????? ???? ?????? ?????? BizTalk Server.

?? MessageBox_Message_ManageRefCountLog_BizTalkMsgBoxDb ??? ????? ????? ???? SQL Server ???????. ????? ???? ??????? ?????? ???? SQL Server ???? ????? ????. ??? ??? ???? ??? ????? ????? ???? ????? ????? ?????? ?????? ????? ???????. ????? ????? ????? ?????. ???????? ??? ???? ????? ??? ??????? ??????. ????? ??? ???? ??????? ??? ?????? ??????? ?????? ?? ??? ?????? ?? ?????? ???? ????? ?????.

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

?? ????? DTA ?????? ????? ?????? ???? SQL Server ?? ?????? ??? ????? ???????? ???????????? ???? ????? ???????? ????????. ??? ?????? ?????? ?? ?? ?? ?????? ??????? ?????? ?????? ?????? ?? ??? ??? ??? ????? ?????.

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

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

919776

(http://support.microsoft.com/default.aspx?scid=kb;EN-US;919776)

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

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

???? ????? (?????????) ?????? ?????? ?? ????? (??? ?????????). ?? ???? ??? ??????? ???? ???????? ?? ????? ??????.

????? ??? ??? ?????? ?????? ???????????????? ???? ??? ??? ????? ???????? ????? ?? ??? ?????. ???? ?????? ?????? ?? ???? ??????? ???????? ????? ?????? BizTalk:

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

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

????? ?? ????????? ??? ???????? ????? Terminate.vbs? ?? ?????? ???? msdn ??? ??? ??????:

http://msdn.microsoft.com/en-us/library/bb203857.aspx

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

?? ???? ?????? ??????? ?????? ?? ???? ????? ???????? ????? ?????? ??????? ?? ???????. ??? ??????? ??? ?????? ????? ??????. ???? ????? ?????? ????? ??????? ?????? ????? ??????? ?????? ?? BizTalk Server 2006? ????? ??????? ?????? ?? ????? ????? ????? Microsoft 936536. ?? ????? ??? ??????? ?? BizTalk Server 2006 R2 ?????????? ??????.

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

????? ?? ?????????? ???? ??? ??? ??????? ?????? ???? ??????? ?? "????? ????? ????????":

936536

(http://support.microsoft.com/default.aspx?scid=kb;EN-US;936536)

?????: ????? ????? ?????? ?? BizTalk Server 2006 ???? ????? ????? ?????? ?? ??? ??? ??????

??? ????? ???? ???? BizTalk Server, ????? ???? ??????? ?? ?? ??? ?????. ??? ??? ?????? ?? BizTalk Server 2006 ?? ????? ??????? ?????? ?? ????? ????? ????? Microsoft 944426. ?? BizTalk Server 2006 R2? ?? ?????? ???? ?????? service Pack 1 ?????? BizTalk 2006 R2. ?? ????? ??? ??????? ?? BizTalk Server 2009 ?? ????????? ??????.

????? ?? ?????????? ???? ??? ????? ???????? ??????? ???? ???????? ?? ????? ????? Microsoft:

974563

(http://support.microsoft.com/default.aspx?scid=kb;EN-US;974563)

????? ????????? ??????? ? Microsoft BizTalk Server ???? ???? ??????? ?? BizTalk Server 2006 R2 Service Pack 1

944426

(http://support.microsoft.com/default.aspx?scid=kb;EN-US;944426)

?????: ?????? ??????? ????? ??????? ?????? ???? ???? ?? ??????? ?????? ?????? ???????? ????? ????? ???????? ???????????????? ?? BizTalk Server 2006 ??? BizTalk Server 2006 R2

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

????? ?????? ???? ??? ?? ???? "????? ?????? ?????" (????) ??????????Q ? ??????????????? Q_Suspended. ?? ??? ????? ?? ????? ??? ????? ??? ?????? ?? ????? ???????? ???????????????? ???????. ??????? ??? ??????? ?? BizTalk Server 2006? ????? ??????? ?????? ?? ????? ????? ????? Microsoft 941690. ?? ????? ??? ??????? ?? BizTalk Server 2006 R2 ?????????? ??????.

????? ?? ?????????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:

941690

(http://support.microsoft.com/default.aspx?scid=kb;EN-US;941690)

?????: ?? ??? ????? ???????? ??? ??????? ?? <biztalkhostname>?????? Q_Suspended ??? ???? BizTalk Server 2006</biztalkhostname>

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

???? "??????? ?????" ?????? "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 Server ? BizTalk Server

???? BizTalk Server ???? ????????? ?????? ????? ???? ??? SQL Server ???? ?????. ??? ??? ?? ???? ?? ????? ???? SQL ??? ??????? ??? ????? BizTalk Server ????? ??????. ?? "?????? ??????"? ?????? Avg. Disk sec/????? ????? ???/????? ????? ? ?????/??????? ??? ??? avg. ?????? ?????? ???????? ?? PhysicalDisk ???? ??????. ?????? ?????? ??? ?? 10 ????? ????? (???? ?????). ????? ???? 20 ???? ????? ?? ???? ??? ??????.

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

http://technet.microsoft.com/en-us/library/cc966540.aspx

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

????? ?? ????????? ??? ??????? ???? ????? BizTalk Server 2004 ????? ????????? ?? ?????? ???? msdn ??? ??? ??????:

http://msdn.microsoft.com/en-us/library/ms942187.aspx

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

????? ?? ????????? ??? ??????? ???? ????? ????? ???????? BizTalk Server 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/default.aspx?scid=kb;EN-US;298475)

????? ??????? ?????? ?? ?????? SQL Server

271509

(http://support.microsoft.com/default.aspx?scid=kb;EN-US;271509)

????? ?????? ??? ?? SQL Server 2005 ??? SQL Server 2000

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

??? ????? ???? SQL Server ??? ???? SQL. ??? ????? ???? SQL Server? ?? ???? ????? ???? ???? ???? SQL BizTalk ??????? ???? ????? ??????? ?? ????? ????? ????????. ???? ??? ?????? ??? ????? ????????? ??? ????? ??? ????? ?????? ?? ??????. ??? ????? ????? ????? ???????? BizTalk Server ?? BizTalk Server 2004 Service Pack 2 (SP2) ?? ????????? ??????.

?? ????? SQL Server LDF ???????? ??? ?????? ????? ??????. ????? ???? ????? LDF ???????? ?????? ???????? ???????????????? ????????????? ??? ???? ??????? ????? ???? ?? ???? ????? ?????.

?? ???? ??? ??????? ?? ?? ??????? ??????? ????? ??? ??????. ??? ????? ?? ???? ???? ???? ???? ?????? ???? ???? ??????? ????? ????? ???????? ??????? ???????? ??? ??. ??? ??? ????? ???? ?? ????? ???? ???? ??????? ??? ????????. ??? ????? ???? ?? ???????? ????? ??? ????? ???????? BizTalk Server. ?? ???? ??? ???? ???????? ??? ????? ????? ???? ?? ???????? ???? TrackedMessages_Copy_BizTalkMsgBoxDb ? ????? DTA ?????? ???? ?????? ???? ???? SQL Server ?????.

????????? ???? ????? ????????? ???? ???? ????. ???????? ?????? ???????? ????? ?? ?????? ????? ????????? BizTalk Server ?????? ???? SQL Server ?????? ??. ????? ?? ????????? ??? ?????? BizTalk Server? ?? ?????? ???? msdn ??? ??? ??????:

http://msdn.microsoft.com/en-us/library/bb743398.aspx

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

???? ???? ??????? ??????? sp_ForceFullBackup ??????? ?? ????? ???????? BizTalkMgmtDb ???????? ?? ????? ???? ???? ????? ??????? ?????? ???????? ??????. ????? ??????? ?????? ?????? adm_ForceFullBackup ????? 1. ????? ??????? ????? ????????? BizTalk Server ????? ??????? ??? ????? ?????? ????? ??????? ????? ?????? ?????.

???? ??????? BizTalk Server ???? ????????? ???? (BPA) ?????? ??? BizTalk Server. BPA ????? ?????? ?? ????????? ???????? ?????? ????????. ????? ?? ????????? ??? BPA? ?? ?????? ???? Microsoft ?????? ??? ???:

????FamilyID = 93d432fe-1370-4b6d-aaa8-a0c43c30f5ab & displaylang = en

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

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

????? ???? ??????? ????? ??????? ?????? ???????? BizTalk Server SQL Server ??? ??? ??????? ????? ????????? ??? ??? ?? deadlocking. ???????? ????? ????? ?????? BizTalk Server? ???? ??? ???????.

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

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

?? ???? ???? ???? ?????? ??? ??????? ?????? ?? SQL Server ???? ??????? ????? ???????? ????? ????? ???? ????. ???? ??? MessageBox_Message_ManageRefCountLog_BizTalkMsgBoxDb ??? ????? ????? ???? SQL Server ???????. ?????? ????? ??? ???? ??????? ??? ?????? ??????? ?????? ?? ?????? ?? ?????? ???? ????? ?????.

?????? 2: ??????? ???? ????????????

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

???? ???? ???????????? ?? ??????? ??????? ???????? ???? ???? ????? HTML ??? ??????? ????? ??? ????? ?????? ???? ??????. ???? ?? ????? ??????? ???? ?????? ?? ??? ??? ?????? BizTalk Server. ???????? ??? ???? ???? ?????? ???? ?????? ???????? BizTalk Server ???????? BizTalk Server.

????? ?? ????????? ??? ????? ????? ?????? ????????????? ?? ?????? ???? Microsoft ?????? ??? ???:

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

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

????? ?? ????????? ??? ?????? ?? BizTalk Server? ?? ?????? ???? msdn ??? ??? ??????:

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

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

????? ??? ????? BizTalk Server ???? ?? ???????? ?? ?????? ?????? ????????????? ?? ?? ??????? ????? HTML ???? ?? ?????? ??? ?????. ?? ???? ???? ?????? ????????? ???????? ???????? ??????? ?????? ??????.

???????? ??? ???? ????? ??????? ???? ???????????? ??????? ??? ????? ??????? ???? ?? ???? ?????? ???? ???????. ???? ?????? ?????? ????? BizTalk Server ???? ????? ??????. ????? ??????? ??? ???????? ?????? ??? ?? ???? ????? ??????.

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

??????	???
`??? ??????`Q_Suspended	????? ??? ?????? ??? ????? ??? ??????? ???????? ?? ???? ??????? ?????? ???????? ?? ??????? ??????? ????? ????. ???? ??? ?????? ?? ????? ???????? ????????????????.
`??? ??????`Q	????? ??? ?????? ??? ????? ??? ??????? ???????? ?? ???? ??????? ?????? ???? ????? ????? ???? ???? ????. ???? ??? ?????? ?? ????? ???????? ????????????????.
??????? ?????? ????? ???????	??? ??????? ?????? ?????? ??????? ??????? ?? ????? ???????? ????????????????.
??????	???? ??? ?????? ???? ?????? ????? ???????? ?? ????? ???????? ????????????????.
TrackingData_0_x	???? ??? ??????? ??????? ??????? ???? ?????? ???? ??????? (BAM) ????? ?? ????? ???????? ???????????????? ??? ???? ??????? ??? ????? ???????? ????????????????.
TrackingData_1_x	???? ??? ??????? ??????? ??????? ???? ?? ?????? ?? ????? ???????? ???????????????? ??? ???? ??????? ??? ????? ???????? ????????????.
Tracking_Fragments`x` Tracking_Parts`x` Tracking_Spool`x`	???? ????? ?? ?? ??? ??????? ?? ????? ???????? ???????????????? ?????????????. ??? ??? ????????? ?????? ??? ????. ?? BizTalk Server 2004 SP2 ?????????? ??????? ???? ???? ???? ???? SQL TrackedMessages_Copy_BizTalkMsgBoxDb ??????? ???? ?? ?????? ?????? ??? ??? ??????? ?? ????? ???????? ????????????. ?? BizTalk Server 2004 Service Pack 1 (SP1) ??? ????????? ??????? ?? BizTalk Server 2004? ???? ???? ???? SQL TrackedMessages_Copy_BizTalkMsgBoxDb ???? ??????? ???? ?? ?????? ??? ??????? ?? ????? ???????? ????????????????. ???? ???? ???? SQL TrackingSpool_Cleanup_BizTalkMsgBoxDb ??? ??????? ??? ????? ????? ??????? ??? ???????? ????? ?????? ???? ??????? ??? ???????? ??? ?????.
dta_ServiceInstances	???? ??? ?????? ????? ???????? ??????? ?????? ?? ????? ???????? ????????????. ??? ??? ??? ?????? ????? ?? ??????? ?? ????? ???????? ???????????? ????.
dta_DebugTrace	???? ??? ?????? ??????? ?????? ????? ?? ????? ???????? ????????????.
dta_MessageInOutEvents	???? ??? ?????? ????? ??????? ???????? ?? ????? ???????? ????????????. ????? ??? ??????? ????? ???????? ??????? ???? ???????.
dta_ServiceInstanceExceptions	???? ??? ?????? ??????? ????? ??? ???? ?????? ???????? ?????? ?? ????? ???????? ????????????.

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

`??? ??????`????? Q_Suspended

??? ??? ??? ?????????? Q_Suspended ??? ?????? ?? ???????? ???? ?????? ??? ??????? ???? ??????? ??????? ???? ???? ?? ???? ????? ???????? ?? ?? ????. ????? ????? ??? ???????. ??? ?? ???? ?? ??? ??????? ???? ????? ???????? ?? ?? ????? ?? ??????? ?? ??? ??????? ???????? ?????? ?????? ?? ??? ???????? ??? ???????. ????? ??? ????? ???????? ???????? ??????? ???????? ?? ??? ?????? ??????? ???????? ?? ????? ??????? ?????? ??????? ??? ?????.

?? ??? ?????????? ?????? ?????? ??????? ?????????? ?? ????? ?????. ????? ???? ??????? ?????? ???? BizTalk.

`??? ??????`Q ?????

??? ??? ??? ??????Q ????? ??????? ?????? ?? ???????? ?? ???? ????? ??????? ???????:

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

????? BizTalk Server ????? "??????" ??????? ????????. ????? ????? ??? ??? ?????? ????? ?????? ???? ??????? ?? ?????? ???? ?????? ??????? ???????. ???? ?? ???? ??? ????????? ??? ???? ????? ????? ??? ????? ?????? ???????????? ????? ?? ??????? ????? SQL Server.

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

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

???? ??????

??? ??? ??????? BizTalk ?????? ?????? ?? ??????? ??????? ?????? ?? ?????? ??????. ??? ?? ??? ???????? ?????? ??? ??? ???? ???? ????? ????? orchestrations ???? ?????. ???? ???? ?????? ???? ????? ???? ?? ????? ?????? ????? ?? ???? ??????? ??????.

TrackingData_`x`_`x` ???????

??? TrackingData_x_x ????? ?????? ???? ?????? (???) ???? ??? ??????? ?? ?? ???? ?????. ??? ??????? ?????? ???? ??? ???????? ???? ????? ??????? ????? TDDS_FailedTrackingData ?? ????? ???????? ???????????? ???????? ?????. ??? ??? ?????? BizTalk ?? ???? 6 (????? ?????? ?????)? ????? ???? ?????? ??? ??????? ???????? ???? BizTalk ????.

??? ??? ???? ???? ???? ??? ????? ??????? ?? TrackingData_ ????????????????x_x ??????? ???????? ???????????????? ?? TDDS_StreamStatus ????????????? ?? ??? ?? ?? ??? ???????? ?? ????? ???????? ????????????????. ?????? ???? ?????? ???? BizTalk ?????? ?????? ??? ??????? ?????? ????? ??? ?????.

?? BizTalk Server 2006 R2? ????? BizTalk 2006 R2 Service Pack 1 ??????? ????? ?????? ?? ?????? ??????. ????? ?? ?????????? ???? ??? ????? ???????? ??????? ???? ???????? ?? ????? ????? Microsoft:

969870

(http://support.microsoft.com/default.aspx?scid=kb;EN-US;969870)

?????: ?????? ?????? ?? ??? ??? ??? ?? ????? ?? ????? ???????? ???????????????? ??? ????? ???????? ???????????? ?? BizTalk Server 2006 R2

974563

(http://support.microsoft.com/default.aspx?scid=kb;EN-US;974563)

????? ????????? ??????? ? Microsoft BizTalk Server ???? ???? ??????? ?? BizTalk Server 2006 R2 Service Pack 1

???? Tracking_Spool1 ?? Tracking_Spool2

??? ??? ???? Tracking_Spool1 ?? Tracking_Spool2 ???? ????? ?? BizTalk Server 2004 SP1 ?????????? ??????? ?? BizTalk Server 2004? ???? TrackingSpool_Cleanup_BizTalkMsgBoxDb ?????? ???? SQL Server ?? ???? ????? ???? ???????.

????? ?? ?????????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:

907661

(http://support.microsoft.com/default.aspx?scid=kb;EN-US;907661)

Tracking_Spool1 ?? Tracking_Spool2 ??????? ?? ????? ???????? ???????????????? ???? ????? ???? ?? BizTalk Server 2004

????? ?? ????????? ??? ????? SDK ????? ????? ????????? ?? ?????? ???? msdn ??? ??? ??????:

http://msdn.microsoft.com/en-us/library/ms966372.aspx

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

???? dta_DebugTrace ? dta_MessageInOutEvents

??? ??? ?????? dta_DebugTrace ????? ??? ??????? ???????? ??? ????? ??? ?????. ??? ??? ?????? dta_DebugTrace ?????? ?? ???????? ?????? ??? ??????? ????? ??????? ?? ??????. ??? ?? ??? ?????? ????? ????? ???????? ???????? ???? ???? ???????? ??? ??????? ???????? ?????? ?? ????? ?????.

??? ??? ?????? dta_MessageInOutEvents ????? ????? ??????? ??????? ??? ????? ??? orchestrations ?/?? ???? ????????. ??? ??? ??????? ???? ??? ??????? ?? ?????? ????? ???? ?????? ??? ?????? ?? ????? ?/?? ????? ?? ??????.

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

???? ???????? ??? ????? ???? ????????. ??? ?? ??? ???? ???????? ????????? ????? ?????. ????? ?? ?????????? ?? ?????? ???? Microsoft ?????? ??? ???:

http://technet.microsoft.com/en-us/library/bb203858.aspx

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

?? ???? ????? ???? ?????? dta_DebugTrace ?/?? ???? dta_messageInOutEvents ?? ????? ???????? ????????????? ???? ???? ?????? ??????? ?????? ??? ????? ?????? ??????. ???? ?????? ???? BizTalk ???? ??? ???????.

?? BizTalk Server 2004? ???? ??? dtav_FindMessageFacts ?? ????? ???????? ???????????? ???? dta_MessageInOutEvents ?? ??????. ??? ??? ??????? ???? ??????? ???????:

????? ???? ????? DTA ?????? ??????? ??????.
??? ??? ???? ?? ?????? ???? dta_messageInOutEvents? ??? ??? ???? ????? ????? dtav_FindMessageFacts. ?????? ????? ???? ??????? ???????:
1. ?? SQL Server? ?????? ??? ????? ????? "dtav_FindMessageFacts" ?? ????? ???????? ????????????.
2. ?? ?????? ?????? ??? dtav_FindMessageFacts ???? ???? ??? ???? ??????? ?? ???? ??? ????? ?????? ??? SQL. ??? ????? ??????? ?????? SQL ??? ??? ???? ?????? ?????? ??? ??????? ??? ???? ??? ?????.
3. ????? dtav_FindMessageFacts.sql ?????? ??? ?? ???? ??? ???.
4. ?? ?????? ?????? ??? dtav_FindMessageFacts ???? ??? ?? ???? ??? ???. ???? ??? ????? ????.

???? ???? ?????? ?? ????/?????. ?? ???? ?????? ???? dta_messageInOutEvents? ??? ???? ?????? ?????? dta_url. ???? dta_url ????? ??? ?? BizTalk Server 2004.

??? ???????? ?? ???? ???? ??? ??????? ?????? ????? ????? ??? dtav_FindMessageFacts:

??? ??????? ???? ?? SQL Server.
?? ????? ???????? ???????? ???????? ??? ???????????? ????? ????????.
????? ???????? ????? dtav_FindMessageFacts.sql ???????? ?????? ??. ???? ????? ??? ????? ?? ????? ???????? ????????????.

??? ????? ?????? ?????? ? ????? 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: ??????? ?? ?????????? ???? ???? ???

?? ??????? ???? ???? ???? ????? ???? DBCC ??? ???? SQL ??? ??? ????? ??????? ???? ???? ??? ??? ????? SQLERROR.

?? SQL Server 2005 ?? ????????? ??????? ????? ??????? ???????:

DBCC TRACEON (1222,-1)

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

DBCC TRACEON (1204)

???????? ??? ???? ?????? ?????? ???????? PSSDiag ???? ???????? ??? ???????: ???? ???? ??? ?????????? ???????: ???? ???? ??? ?????.

???????????????? ????? ????? ?????? ??????? ??? ?????? (OLTP) ????? ????? ?????? ????????. ??? deadlocking ???????? ???? deadlocking ??? ?????? ?????? ?????? ???? BizTalk Server. ??? ???? ??? ??????? ??? ??? ??? ????? ?? ????? ?????. ??? ?????? ?? ??????? ???? ???? ???? ??? ?? ????? ??? ???? ??? ?? ????? ??????? ?? ???? ???? ??? ???? ?? ???????.

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

830232

(http://support.microsoft.com/default.aspx?scid=kb;EN-US;830232)

?????? ???????? ?????? ???????? PSSDIAG

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

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

??????? "?????? ??????" ?? SQL Server ?????? ??? ???? ??????? ?????? (SPID) ?????? ?????? ???????. ?? ?? ?????? Profiler SQL ?????? ????? SQL ???? ??? ??????? ?? SPID ?????.

???????? ????? ??????? ?????? ?? SQL Server? ?????? PSSDiag ?????? ???????? SQL ????? ???? ??????? SQL ???????? ???? ?? ????? ???????? ????? ?????.

?? SQL Server 2005 ?? ????????? ??????? ????? ????? ???? ????? ???????? ???? ??? ????? ???? SPID ?? ???? Spid ????? ???? ?? ???? ?????? ???? ?????.

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

830232

(http://support.microsoft.com/default.aspx?scid=kb;EN-US;830232)

?????? ???????? ?????? ???????? PSSDIAG

????? ?? ????????? ??? ???? ????? ????????? ?? ?????? ???? msdn ??? ??? ??????:

http://msdn2.microsoft.com/en-us/library/ms181150.aspx

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

?????? ????? ????? ????? ?? ????? ??? ?? SQL Server? ???? ???????? ?????? ??? ??????? ?? Microsoft. ????? ??? ??????? ?? Microsoft ???? ?? ?????? ??? ????? ?????? ?????? ???????? PSSDiag ???????.

???? 5: ????? ???? ???? ???? BizTalk ???????? ????????

??? ???? BizTalk Server 2006 R2 ?????????? ?????? ?????? ????? ?????? (CU). ?????? ????????? ????????? ??????? ????? ???. ??? ????? BizTalk Server 2006 R2 Service Pack 1:

BizTalk Server 2006 R2 Service Pack 1

(http://www.microsoft.com/downloads/en/details.aspx?displaylang=en&FamilyID=1768f7a3-d843-4f5b-aba7-b3d72892c16f)

?? BizTalk Server 2004 SP1 ?? ???? ??? ???????? ?????? ??????? ?????? ???????? ????????????. ??? ??????? ??? ??????? ?? BizTalk Server 2004 SP2. ???????? ??? ??? ????? ???????? ????????????? ????? BizTalk Server 2004 SP2 ?? ?????? ????? ??? ?????? ??????? ??? ????? ???????? ????????????.

?????? ??? ??????? ???????? ???????? ??? ????? BizTalk Server 2004 Service Pack 2? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:

940519

(http://support.microsoft.com/default.aspx?scid=kb;EN-US;940519)

???????? ???????? ???? ?? ??????? ?? ????? ReadmeSP2.htm ?? BizTalk Server 2004 Service Pack 2

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

????? ???? ?????? BizTalk Server 2004 SP2? ???? ?????? ??????? ???????:

?? ?????? ??????? ?????? ?? ????? ????? ????? Microsoft 894253. ???? ??????? ???????? ?? ????? "????? ???????" ?????? ???????? ????? bts_tracking_shrinkexistingdatabase.sql ?? SQL Server 2000. ????? ?? ?????????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
894253
(http://support.microsoft.com/default.aspx?scid=kb;EN-US;894253)
?????: ?? ?????? ????? dtasp_PruneTrackingdatabase() ????? ????? ????? ????? ????? ???????? DTA ?? BizTalk Server 2004
????? BizTalk Server 2004 SP2. ????? ?? ?????????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
888751
(http://support.microsoft.com/default.aspx?scid=kb;EN-US;888751)
????? ?????? ??? ???? ???? ???? BizTalk Server 2004

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

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

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

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

???? ???? ???????? ???????? ?? ????? ???????? ????????????????? ????? ??????? ???? BizTalk ????. ????? ???? ??? ???????.

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

????? ????? ????????? ???? ????? ???????? BizTalk Server. ????? BizTalkMgmtDb.dbo.sp_ForceFullBackup ???? ??????? ??????? ?????? ???? ???? ???????? ????? ?????? ???????? ??????. ????? ??? ??????? ??????? ??? ?? ????? ?????? "???? SQL Server BizTalk ????? ?????????".
???? ???????? ????? Msgbox_cleanup_logic.sql ?? ???? ???????:\Program Files\Microsoft BizTalk 200x\schema ??? ???? SQL.
????? ?????? SQL ??? ??? ????? ?????? "????????????????" ?????? ??????? bts_CleanupMsgbox ???????.
????? ???? BizTalk ???????? ???????? ??????? ???????? ???????. ??? ??? ?????? ?????????? HTTP ?? ?????? SOAP? ????? ????? ????? IIS.
????? ??????? bts_CleanupMsgbox ????? ???? ????? ???????? ????????????????.
??? ????? ???? ?????? ?????? ???????? BizTalk Server.

?????? ??? ?????? ?? ????????? ??? ????? ?????? ?? ??????? bts_CleanupMsgbox ??????? ?? BizTalk Server 2006? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:

924715

(http://support.microsoft.com/default.aspx?scid=kb;EN-US;924715)

?????: ??????? ?? ??? ??? ???????? ?? ????? ?????? ?????? ??? ????? bts_CleanupMsgbox ?? ??????? ?????? ?? ???? ?????? BizTalk Server 2006

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

???? ???? ???????? ?? ????? ?????? ????????????? ????? ??????? ???? BizTalk ????. ????? ?????? ???? ????? ???????.

?????? ??? ????????? ??? ???? ???????. ???? "??????? ???????".

??????? 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)
  ?????? ???? ??? ??????? ???????? ???? ???????.
??????? ???????:
1. ????? ????? ????????? ???? ????? ???????? BizTalk.
2. ????? ??????? dtasp_CleanHMData ???????. ?????? ??? ?????? ??? ??? ????? ???????????? ????? ??? ?????? ?? ??????? ??? ????? ???? ??? ???????.
  
  ?????? ????? ???? ??????? ???????:
  1. ????? ???? BizTalk ???????? ???????? ??????? ???????? ???????. ??? ??? ?????? ?????????? HTTP ?? ?????? SOAP? ????? ????? ????? IIS.
  2. ????? ??????? dtasp_CleanHMData ??????? ?? ????? ???????? ????????????.
  3. ??? ????? ???? ??????? ??????? ???????? BizTalk Server.

????? BizTalk Server 2004 ???

???? ???? ???????? ?? ????? ???????? ???????????? ?? BizTalk Server 2004? ???? ??? ???????.

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

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

?????? ??? ?????? ?? ????????? ??? ??????? dtasp_PruneTrackingdatabase ?????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
894253
(http://support.microsoft.com/default.aspx?scid=kb;EN-US;894253)
?????: ?? ?????? ????? dtasp_PruneTrackingdatabase() ????? ????? ????? ????? ????? ???????? DTA ?? BizTalk Server 2004
??? ????? ???? ??????? ??????? ?????? BizTalk.

?????? ??? ??? ??? ?? ???? ???? ?????? ??????? ????? ????????? ????? ?????? ????????????? ??????? ????? ???????? ??? SQL Server ???? ??? ??? ????? ???????? ???????????? ???????.

??? ??? ????? ??? ?????? ?????? ???????? ???????????? ?? ????? PSSDiag? ???? ?????? ??? ??????? ?? Microsoft. ?????? ??? ????? ????? ?? "????? ??? ???????" ?????? ??????? ???????? ??? ?????? ?????? ?? ?????? ???? Microsoft ?????? ??? ???:

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

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

?????? ??? ??????? "????? ??? ???????"? ??? ???????? ???????????? ?????? PSSDiag ????? ????? ??????? (?????.evt). ?? ???? ????? ????? ??? ??? ??????? ??? BizTalk Server.

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

???????

???? ???????: 952555 - ????? ??? ??????: 12/?????/1432 - ??????: 1.0

????? ???

Microsoft BizTalk Server Branch 2010
Microsoft BizTalk Server Developer 2010
Microsoft BizTalk Server Enterprise 2010
Microsoft BizTalk Server Standard 2010
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 KbMtar

????? ????

???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????

???? ??? ????? ??????? ?????? ??????????952555

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

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