????? ????? ???????? ????? ????? ???????? 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 ????? ???? deadlock ?????? ?? ?????? SQL Server ???? ??? ?????? ??????? ?????? ???????? "????????????????" ?? BizTalk Server
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 ????? ??????? ???? SQL Server ????? ???? ?????? BizTalk Server
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 ????? ???? deadlock ?????? ?? ?????? SQL Server ???? ??? ?????? ??????? ?????? ???????? "????????????????" ?? BizTalk Server
????? ?? ????????? ??? ????? ????? ????? ?????? ????????? DBCC? ?? ?????? ???? Microsoft ?????? ??? ???:
http://technet.microsoft.com/en-us/library/cc966523.aspx

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

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

????? ?? ?????????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
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 ??? ????? ???? 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
?? ???? ?????? ??????? ?????? ?? ???? ????? ???????? ????? ?????? ??????? ?? ???????. ??? ??????? ??? ?????? ????? ??????. ???? ????? ?????? ????? ??????? ?????? ????? ??????? ?????? ?? BizTalk Server 2006? ????? ??????? ?????? ?? ????? ????? ????? Microsoft 936536. ?? ????? ??? ??????? ?? BizTalk Server 2006 R2 ?????????? ??????.

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

????? ?? ?????????? ???? ??? ??? ??????? ?????? ???? ??????? ?? "????? ????? ????????":
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 ????? ????????? ??????? ? Microsoft BizTalk Server ???? ???? ??????? ?? BizTalk Server 2006 R2 Service Pack 1
944426 ?????: ?????? ??????? ????? ??????? ?????? ???? ???? ?? ??????? ?????? ?????? ???????? ????? ????? ???????? ???????????????? ?? BizTalk Server 2006 ??? BizTalk Server 2006 R2
????? ?????? ???? ??? ?? ???? "????? ?????? ?????" (????) ??????????Q ? ??????????????? Q_Suspended. ?? ??? ????? ?? ????? ??? ????? ??? ?????? ?? ????? ???????? ???????????????? ???????. ??????? ??? ??????? ?? BizTalk Server 2006? ????? ??????? ?????? ?? ????? ????? ????? Microsoft 941690. ?? ????? ??? ??????? ?? BizTalk Server 2006 R2 ?????????? ??????.

????? ?? ?????????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
941690 ?????: ?? ??? ????? ???????? ??? ??????? ?? <biztalkhostname>?????? Q_Suspended ??? ???? BizTalk Server 2006</biztalkhostname>
???? "??????? ?????" ?????? "zombie" ?????? ????? ???????.

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

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

?????? ??? ??? ??????? ??????? ?? ?????? ???? msdn ??? ??? ??????:
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
????? ?? ????????? ??? ??????? ???? ????? BizTalk Server 2004 ????? ????????? ?? ?????? ???? msdn ??? ??? ??????:
http://msdn.microsoft.com/en-us/library/ms942187.aspx
????? ?? ????????? ??? ??????? ???? ????? ????? ???????? BizTalk Server 2006? ?? ?????? ???? msdn ??? ??? ??????:
http://msdn.microsoft.com/en-us/library/aa559920.aspx
????? ?? ?????????? ???? ??? ????? ???????? ??????? ???? ???????? ?? ????? ????? Microsoft:
298475 ????? ??????? ?????? ?? ?????? SQL Server

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
???? ???? ??????? ??????? sp_ForceFullBackup ??????? ?? ????? ???????? BizTalkMgmtDb ???????? ?? ????? ???? ???? ????? ??????? ?????? ???????? ??????. ????? ??????? ?????? ?????? adm_ForceFullBackup ????? 1. ????? ??????? ????? ????????? BizTalk Server ????? ??????? ??? ????? ?????? ????? ??????? ????? ?????? ?????.

???? ??????? BizTalk Server ???? ????????? ???? (BPA) ?????? ??? BizTalk Server. BPA ????? ?????? ?? ????????? ???????? ?????? ????????. ????? ?? ????????? ??? BPA? ?? ?????? ???? Microsoft ?????? ??? ???:
????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
????? ?? ????????? ??? ?????? ?? BizTalk Server? ?? ?????? ???? msdn ??? ??? ??????:
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_Fragmentsx
Tracking_Partsx
Tracking_Spoolx
???? ????? ?? ?? ??? ??????? ?? ????? ???????? ???????????????? ?????????????. ??? ??? ????????? ?????? ??? ????.

?? 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 ?????: ?????? ?????? ?? ??? ??? ??? ?? ????? ?? ????? ???????? ???????????????? ??? ????? ???????? ???????????? ?? BizTalk Server 2006 R2

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 Tracking_Spool1 ?? Tracking_Spool2 ??????? ?? ????? ???????? ???????????????? ???? ????? ???? ?? BizTalk Server 2004


????? ?? ????????? ??? ????? SDK ????? ????? ????????? ?? ?????? ???? msdn ??? ??? ??????:
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
?? ???? ????? ???? ?????? dta_DebugTrace ?/?? ???? dta_messageInOutEvents ?? ????? ???????? ????????????? ???? ???? ?????? ??????? ?????? ??? ????? ?????? ??????. ???? ?????? ???? BizTalk ???? ??? ???????.

?? BizTalk Server 2004? ???? ??? dtav_FindMessageFacts ?? ????? ???????? ???????????? ???? dta_MessageInOutEvents ?? ??????. ??? ??? ??????? ???? ??????? ???????:
  1. ????? ???? ????? DTA ?????? ??????? ??????.
  2. ??? ??? ???? ?? ?????? ???? 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:
  1. ??? ??????? ???? ?? SQL Server.
  2. ?? ????? ???????? ???????? ???????? ??? ???????????? ????? ????????.
  3. ????? ???????? ????? dtav_FindMessageFacts.sql ???????? ?????? ??. ???? ????? ??? ????? ?? ????? ???????? ????????????.
??? ????? ?????? ?????? ? ????? DTA ?????? ????.
????? ?? ????????? ??? ???? ??????? ??????? ????? ????????? ?? ?????? ???? msdn ??? ??? ??????:
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 ?????? ???????? ?????? ???????? PSSDIAG

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

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

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

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

?????? ??? ???? ?? ????????? ??? PSSDiag ? SQL? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
830232 ?????? ???????? ?????? ???????? PSSDIAG
????? ?? ????????? ??? ???? ????? ????????? ?? ?????? ???? msdn ??? ??? ??????:
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
?? BizTalk Server 2004 SP1 ?? ???? ??? ???????? ?????? ??????? ?????? ???????? ????????????. ??? ??????? ??? ??????? ?? BizTalk Server 2004 SP2. ???????? ??? ??? ????? ???????? ????????????? ????? BizTalk Server 2004 SP2 ?? ?????? ????? ??? ?????? ??????? ??? ????? ???????? ????????????.

?????? ??? ??????? ???????? ???????? ??? ????? BizTalk Server 2004 Service Pack 2? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
940519 ???????? ???????? ???? ?? ??????? ?? ????? ReadmeSP2.htm ?? BizTalk Server 2004 Service Pack 2
????? ???? ?????? BizTalk Server 2004 SP2? ???? ?????? ??????? ???????:
  1. ?? ?????? ??????? ?????? ?? ????? ????? ????? Microsoft 894253. ???? ??????? ???????? ?? ????? "????? ???????" ?????? ???????? ????? bts_tracking_shrinkexistingdatabase.sql ?? SQL Server 2000. ????? ?? ?????????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
    894253 ?????: ?? ?????? ????? dtasp_PruneTrackingdatabase() ????? ????? ????? ????? ????? ???????? DTA ?? BizTalk Server 2004
  2. ????? BizTalk Server 2004 SP2. ????? ?? ?????????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
    888751 ????? ?????? ??? ???? ???? ???? BizTalk Server 2004

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

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

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

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

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

?????? ???? ??? ??????? ???? ???????. ???? ????? ?????? ?? ???? ????? ??? ??????? ?? ???? ?????.
  1. ????? ????? ????????? ???? ????? ???????? BizTalk Server. ????? BizTalkMgmtDb.dbo.sp_ForceFullBackup ???? ??????? ??????? ?????? ???? ???? ???????? ????? ?????? ???????? ??????. ????? ??? ??????? ??????? ??? ?? ????? ?????? "???? SQL Server BizTalk ????? ?????????".
  2. ???? ???????? ????? Msgbox_cleanup_logic.sql ?? ???? ???????:\Program Files\Microsoft BizTalk 200x\schema ??? ???? SQL.
  3. ????? ?????? SQL ??? ??? ????? ?????? "????????????????" ?????? ??????? bts_CleanupMsgbox ???????.
  4. ????? ???? BizTalk ???????? ???????? ??????? ???????? ???????. ??? ??? ?????? ?????????? HTTP ?? ?????? SOAP? ????? ????? ????? IIS.
  5. ????? ??????? bts_CleanupMsgbox ????? ???? ????? ???????? ????????????????.
  6. ??? ????? ???? ?????? ?????? ???????? BizTalk Server.
?????? ??? ?????? ?? ????????? ??? ????? ?????? ?? ??????? bts_CleanupMsgbox ??????? ?? BizTalk Server 2006? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
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
      ?????? ???? ??? ??????? ???????? ???? ???????.
  • ??????? ???????:
    1. ????? ????? ????????? ???? ????? ???????? BizTalk.
    2. ????? ??????? dtasp_CleanHMData ???????. ?????? ??? ?????? ??? ??? ????? ???????????? ????? ??? ?????? ?? ??????? ??? ????? ???? ??? ???????.

      ?????? ????? ???? ??????? ???????:
      1. ????? ???? BizTalk ???????? ???????? ??????? ???????? ???????. ??? ??? ?????? ?????????? HTTP ?? ?????? SOAP? ????? ????? ????? IIS.
      2. ????? ??????? dtasp_CleanHMData ??????? ?? ????? ???????? ????????????.
      3. ??? ????? ???? ??????? ??????? ???????? BizTalk Server.
????? BizTalk Server 2004 ???
???? ???? ???????? ?? ????? ???????? ???????????? ?? BizTalk Server 2004? ???? ??? ???????.

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

    ?????? ??? ?????? ?? ????????? ??? ??????? dtasp_PruneTrackingdatabase ?????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
    894253 ?????: ?? ?????? ????? dtasp_PruneTrackingdatabase() ????? ????? ????? ????? ????? ???????? DTA ?? BizTalk Server 2004
  4. ??? ????? ???? ??????? ??????? ?????? BizTalk.
?????? ??? ??? ??? ?? ???? ???? ?????? ??????? ????? ????????? ????? ?????? ????????????? ??????? ????? ???????? ??? SQL Server ???? ??? ??? ????? ???????? ???????????? ???????.

??? ??? ????? ??? ?????? ?????? ???????? ???????????? ?? ????? PSSDiag? ???? ?????? ??? ??????? ?? Microsoft. ?????? ??? ????? ????? ?? "????? ??? ???????" ?????? ??????? ???????? ??? ?????? ?????? ?? ?????? ???? Microsoft ?????? ??? ???:
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

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

 

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