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

?????? ????????? ?????? ?????????
???? ???????: 917845 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

???????

?? Microsoft BizTalk Server? ????? ?? ???? ????? ???? ??? ?????? ?? ????? ????? ??????? Microsoft SQL Server ??? ?????? ??????? ?????? ?????? BizTalkMsgBoxDb.

?????

?? ???? ??? ??????? ??? ???? ?? ???? ?? ?????? ??????? ??????:
  • " ???????? ????? ???????? ??? ????? ?????? ??? ????? ???????? BizTalkMsgBoxDb.
  • " ???????? ??????? ???????? ??? ????? ?????? ??? ????? ???????? BizTalkMsgBoxDb.
  • " ???? parallelism ???? ?????? ??? ????? ?????? ??? ???? ??? 1 ??? ????????? ???? ?????? SQL Server ????? ?????? ????? ?????? BizTalkMsgBoxDb.
  • ????? ????? ?? ????? ????? ???? ?? ????? ???????? BizTalkMsgBoxDb ??? BizTalk Server ??????? ????????.

????

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

??????? ??????: ????? ?????? ???????? Create Statistics ??????? "???????? ??????? ????????"

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

??????? 2: ????? ???? parallelism ???? ???? ?????? ??? 1

??? ??? ???????? ?? ?????? ???? parallelism ???? ?????? ?????? 1 ??? ????????? ???? ?????? SQL Server.

??????? 3: ????? ???? ??? BizTalk Server ??????? ????????

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

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

??????? ????

??????? bts_RebuildIndexes ?????

??????? ?????? ??????? ?????? ???? ???? ?? ????? ???????? BizTalkMsgBoxDb ?????? bts_RebuildIndexes ??????? ??????. ?? BizTalk Server 2006 ?????????? ??????? ????? ????? dtasp_RebuildIndexes ??????? ?????? ?????? ???? ????? ?? ????? ???????? ????????????.

???? ??????? BizTalk GUID-?????. ????? ?????????? ?????? ?? ?? ?? ???? ?? ??? ??? ???????? ????? GUID-????? ????? ???? ???? ?? ??????? ????? ??? ?????? ????? ????? ?????? BizTalk. ?? ???? ??? ??? ?????. ????? ????? ???????? ?? ??????? ???????? ?? ???? ????? ?????? ??? ???? ?? ????? ????? ????? ????????. ??? ??? ?? ??????? ?????? ?? ???????? ????? ?? ????? ???????? ??????????????? ????? ????? ???? ????? ?????? ????? ???? ????????. ??? ????? ??? ????????? ?????? ????????.

????? ??????? ??? DBCC DBREINDEX SQL ?????? ????? ???? ?? ????? ???????? ?????? ?? BizTalk Server. ?????? ??? ???? ?? ????? ??????? ??? DBCC DBREINDEX SQL, ???? ????? ??????? ??? bts_RebuildIndexes ??????? ??????, ??? ?? ???? ??? ?????.

??????????? ????? ??????? ????? ???????? ????? ???? BizTalk Server ????? ???? Microsoft ???. ???? ????? ???? ?????? ?????? ????? SQL Server ??? ????? ????? ????? ????. ??? ?????bts_RebuildIndexes ??????? ?????? ?? BizTalk Server 2006 ?????????? ??????, ?? ????? ???? ????? ????? ???????:
????? ??????? ?????? 1
Msg 5239? ????? 16, ???? 1? ??????? bts_RebuildIndexes? ??? 4
??? ???? ??? ?????? ?????? ???? 674101442 (???? '???????????')
?? ????? ??? ????? ???? (DBCC) ????? ????? ???????? ??? ??? ????? ?? ????????.
????? ??????? ?????? 2
Msg 5239? ????? 16, ???? 1? ??????? bts_RebuildIndexes? ??? 4 ??? ???? ??? ?????? ?????? ???? 722101613 (???? '???????????') ???? ?? ????? ??? ????? DBCC ???????? ?? ??? ?????.

???? ??? ??????? ??????????????????? ??? ?? BizTalk Server 2006 ?????????? ??????. ??? ??? ???????? ?? ?????????? ??????? ?? ?? ?????bts_RebuildIndexes ??????? ??????:
  1. ????? ???? ????? ?????? ?? bts_RebuildIndexes ??????? ??????.
    DBCC DBREINDEX ('[dbo].[TrackingData]') WITH NO_INFOMSGS
    
  2. ??? ?????? ??????? bts_RebuildIndexes ??????? ??????.
    DBCC DBREINDEX ('[dbo].[TrackingData_0_0]') WITH NO_INFOMSGS
    DBCC DBREINDEX ('[dbo].[TrackingData_0_1]') WITH NO_INFOMSGS
    DBCC DBREINDEX ('[dbo].[TrackingData_0_2]') WITH NO_INFOMSGS
    DBCC DBREINDEX ('[dbo].[TrackingData_0_3]') WITH NO_INFOMSGS
    DBCC DBREINDEX ('[dbo].[TrackingData_1_0]') WITH NO_INFOMSGS
    DBCC DBREINDEX ('[dbo].[TrackingData_1_1]') WITH NO_INFOMSGS
    DBCC DBREINDEX ('[dbo].[TrackingData_1_2]') WITH NO_INFOMSGS
    DBCC DBREINDEX ('[dbo].[TrackingData_1_3]') WITH NO_INFOMSGS
    

???????

???? ???????: 917845 - ????? ??? ??????: 25/????? ???????/1432 - ??????: 2.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 Branch
  • Microsoft BizTalk Server 2009 Developer
  • Microsoft BizTalk Server 2009 Enterprise
  • Microsoft BizTalk Server 2009 Standard
  • Microsoft BizTalk Server 2006 R2 Branch
  • Microsoft BizTalk Server 2006 R2 Developer Edition
  • Microsoft BizTalk Server 2006 R2 Enterprise Edition
  • Microsoft BizTalk Server 2006 R2 Standard Edition
  • Microsoft BizTalk Server 2006 Standard Edition
  • Microsoft BizTalk Server 2006 Developer Edition
  • Microsoft BizTalk Server 2006 Enterprise Edition
  • Microsoft BizTalk Server 2004 Standard Edition
  • Microsoft BizTalk Server 2004 Developer Edition
  • Microsoft BizTalk Server 2004 Enterprise Edition
  • Microsoft BizTalk Server 2004 Partner Edition
????? ??????: 
kbbts kbtshoot kbprb kbmt KB917845 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????917845

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

 

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