????: ?????? ????? ?????? ???, ????: ??? ????? ??????, ?? Parallelism ?????? ??? ??? BizTalk ????? BizTalkMsgBoxDB ??????? ?? ????? ???? SQL Server ??????? ??????? ???

???? ID: 912262 - ?? ???????? ?? ?????? ??? ?? ?? ???? ???? ???? ??.
???? ?????? ???????????? ?????? ???????? KB ?? ???????? ????? ?? ??? ???? ????? ????
??? ?? ??????? ???? | ??? ?? ??????? ????

?????

?? ???? ?????? ?? ????? ???? ??????: ??? ???????????? ??????: ?????? ???????????? ????? ??? ???????? Parallelism ?? ??? ????????? ?? ??? ??? ??1Microsoft BizTalk ????? ?? ????? ???? ?? ?? Microsoft SQL ????? ??????? ???BizTalkMsgBoxDB???????:.
????? ?? ???? ???? | ??????????? ???

???? ???????

BizTalk Server relies heavily on SQL Server for accurate and rapid data processing. Theauto create statistics??????auto update statisticoption, and theMax Degree of Parallelismsetting can significantly change the execution plan of a query from one instance of SQL Server to another instance of SQL Server. Therefore, to provide consistent support for all customers, BizTalk Server pre-hints all queries with the best possible search criteria for each query scenario. This behavior enables consistent BizTalk Server to SQL Server interaction. The interaction can be benchmarked and supported by Microsoft regardless of the customer environment.

??? ?? ??? ??? ????? ???? ?? ??? BizTalk ????? ?? ????? ???? ?? ??? ????? ?????? ??? ??? ???BizTalkMsgBoxDb???????::
  • ????: ??? ??????
  • ????: ?????? ??????
??? ??,?????? Parallelism ?? ??? ????????? ?? ??? ??? ??1??? SQL ????? ??????? ?? ????? ???? ??BizTalkMsgBoxDB???????:.
????? ?? ???? ???? | ??????????? ???

??????

??? SQL Server 2000 ?? BizTalk ????? ??? Parallelism ?????? ?? ???? ??? ???? ??????? ?? ??? Microsoft ???????? ??? ???? ????? ?? ??? ????? ???? ?????? ?? ????? ????:
899000
(http://support.microsoft.com/kb/899000/ )
SQL ????? ?? BizTalk ????? ?? ???????? ???? ?? ?????? ?? ??? Parallelism ??????
????? ?? ???? ???? | ??????????? ???

???

???? ID: 912262 - ????? ???????: 06 ?????? 2010 - ??????: 2.0
???? ???? ???? ??:
  • 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 Edition
  • 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 Developer Edition
  • Microsoft BizTalk Server 2006 Standard Edition
  • Microsoft BizTalk Server 2006 Enterprise Edition
  • Microsoft BizTalk Server 2004 Enterprise Edition
  • Microsoft BizTalk Server 2004 Developer Edition
  • Microsoft BizTalk Server 2004 Partner Edition
  • Microsoft BizTalk Server 2004 Standard Edition
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 Web
  • Microsoft SQL Server 2008 Workgroup
  • Microsoft SQL Server 2008 Express
  • Microsoft SQL Server 2008 Express with Advanced Services
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Enterprise X64 Edition
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Standard X64 Edition
  • Microsoft SQL Server 2005 Workgroup Edition
  • Microsoft SQL Server 2005 Enterprise Edition for Itanium-based Systems
  • Microsoft SQL Server 2000 Standard Edition
??????: 
kbbts kbtshoot kbinfo kbmt KB912262 KbMthi
???? ?????? ????????
??????????: ?? ???? ?? ???? ??????? ?? ????? ?? Microsoft ????-?????? ?????????? ?????? ?????? ???? ??? ??. Microsoft ???? ??? ????-???????? ?? ????-???????? ????? ?????? ?? ???? ???????? ???? ?? ???? ????? ????? ??? ?? ??? ?????? ?? ???? ???? ???? ??? ????? ??. ???????, ????-???????? ???? ????? ???? ???? ???? ???. ?????, ????????, ?????-???? ?? ??????? ?? ???????? ?? ???? ???, ???? ?? ??? ?????? ???? ???? ??? ????? ??? ?? ???? ??. Microsoft ??????? ??? ???? ?? ?????? ?? ??????????, ????????? ?? ??? ?????? ?? ???? ????? ?? ???? ???????? ?? ??? ???? ????? ?? ??? ????????? ???? ??. Microsoft ????-?????? ?????????? ?? ????? ?????? ?? ?? ??? ??.
?????????? ?? ??????? ????????? ??????? ??:912262
(http://support.microsoft.com/kb/912262/en-us/ )
????? ?? ???? ???? | ??????????? ???

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

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