SQL ????? ?? BizTalk ????? ?? ???????? ???? ?? ?????? ?? ??? Parallelism ??????

???? ?????? ???? ??????
???? ID: 899000 - ?? ???????? ?? ?????? ??? ?? ?? ???? ???? ???? ??.
??? ?? ??????? ???? | ??? ?? ??????? ????

?????

?? ?? Microsoft BizTalk ????? ?? ???????? ????ParallelismMicrosoft SQL Server ?? BizTalk Server ??????? houses ?? ?????? ?? ??? ?????? ????????? ?? ?? ??? ?? ??????? ????? ???? ?? ??? SQL ????? ?? ?????? ?? ?? ?? ???? ???????? ?????? ??? ?? ?? BizTalk ?????, ???????? ?????????? Parallelism ?? ??? ???setting is set to 1 in the instance of SQL Server that hosts the BizTalkMsgBoxDB database.

???:TheParallelismsetting does not affect the number of processors that SQL Server uses in a multiple-processor environment. TheParallelismsetting only governs the number of processors on which any particular Transact-SQL statement can run at the same time. ???Parallelismsetting is set to use one processor, the SQL Server query optimizer will not create execution plans that permit any particular Transact-SQL statement to run on multiple processors at the same time.

???? ???????

BizTalk Server ??????? ?????? ?????????? ???? ???, ?? ?????? ????? ????????? ????? ?????, BizTalk Server ??????? ?????? ???? ??? ?? ???Parallelism????????? ???? ?? ?? ?????? ?? ?? ?? ???? ???????? ?? ????? ?? ??? ??? ?????Parallelism?? ?? ???? ???????? ?? ????? ????????? ???? ?? ??? ?????? adverse BizTalk Server ??????? ?????? ?? ?????? ??? ???? ???

???:??? SQL Server 2000 ?? BizTalk ????? houses ?? ?????? databases ?????? ??, ???? ?? ???????? ????? ?????? ???????? ?? ????? ?????? ??????? ?????Parallelism. ?? ??? ??????,??? ?????? ???????? ?? ????? ????functionally ?? ?????? ??"N" ???????? ?? ????? ?????? ???1???????? ?? ?????? ?? ??? ??? ????? ?????

????? ?? ???ParallelismSQL Server 2000 ?? ?? ?????? ?? ??? ??? ?? ??? ??, ????? ????? ?? ???? ????:
  1. ????? ????,????????? ????? ????,????????????? ????? ????,Microsoft SQL Server?? ????-????? ????, ?? ???? ????????????? ???????SQL ????? ?????????? ??????? ?? ??????? ?????
  2. ?????? ????? ??? ????? ???? ??????? ?????
  3. ?????? ????? ?? ????-????? ????, ?? ???? ??? ????? ???????.
  4. ?????SQL ????? ???????? ????? ???, ????? ??????????????? ?? ????? ????..
????? ?? ???ParallelismSQL ????? 2005 ?? ?????? ??????? ?? ?? ?????? ?? ??? ??? ?? ??? ??, ????? ????? ?? ???? ????:
  1. ????? ????,????????? ????? ????,????????????? ????? ????,Microsoft SQL Server 200x?? ????-????? ????, ?? ???? ???SQL ????? Studio ???????.
  2. SQL ????? ?? ?? ????? ??? ?? ??????? ?? ?????? ?????
  3. ?????? ????? ?? ????-????? ????, ?? ???? ??? ????? ???????.
  4. ????? ????,?????. ????????? Parallelism ?? ??? ??????? ??? ??? ??? ?????
?? ?? ??? ???? ???ParallelismSQL ????? ?? ?????? ?? ??? ????? Transact SQL ??? ????????? ?? ?? SQL ????? ??????? ?? ??? ???????
USE master 
EXEC sp_configure 'max degree of parallelism'
??? ??? 1 ?? ??? ???? ??, ?? ????? Transact SQL ??? ?? SQL ????? ??????? ?? ?????????:
USE master 
EXEC sp_configure 'max degree of parallelism', '1' 
reconfigure with override
???run_value?? ?????? ?????? ??? ?? ????? ?? ????? ???? ??ParallelismSQL ????? ?? ?????? ?? ??? ??? ?? ??? ???

??? ?????Parallelism?? SQL ????? ??????? ?? ??? ?????? ??????? ?? ????????? ?? ?? ??? ??? ?? ???? ??????? ????????? ?? ?????? adverse ?? ???? ??, SQL ????? ??????????? Framework ???????? ?? ????? ?? ???? BizTalk Server ??????? ?? house ???? ?? ?? ??? ???????? ????? ??????

??????

????? Parallelism ?????? ?? ?????? ??? ?? ????????? ?? BizTalk ????? ?? ???????? ???? ?? ???? ??? ???? ??????? ?? ??? Microsoft ???????? ??? ???? ????? ?? ??? ????? ???? ?????? ?? ????? ????:
912262????: ?????? ????? ?????? ???, ????: ??? ????? ??????, ?? Parallelism ?????? ??? ??? BizTalk ????? BizTalkMsgBoxDB ??????? ?? ????? ???? SQL Server ??????? ??????? ???
?? ???? ??? ???? ??????? ?? ???Parallelism??? SQL ????? ?????? ?? ???? ????? Microsoft ?????? ??????? (MSDN) ??? ????:
(SQL.80) http://msdn2.Microsoft.com/en-us/library/aa196725 .aspx
HTTP://MSDN.Microsoft.com/en-us/library/ms181007.aspx

???

???? ID: 899000 - ????? ???????: 05 ?????? 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 Standard Edition
  • Microsoft BizTalk Server 2006 Enterprise Edition
  • Microsoft BizTalk Server 2006 Developer Edition
  • Microsoft BizTalk Server 2004 Developer Edition
  • Microsoft BizTalk Server 2004 Enterprise Edition
  • Microsoft BizTalk Server 2004 Partner Edition
  • Microsoft BizTalk Server 2004 Standard Edition
??????: 
kbbiztalk2004-2006swept kbinfo kbmt KB899000 KbMthi
???? ?????? ????????
??????????: ?? ???? ?? ???? ??????? ?? ????? ?? Microsoft ????-?????? ?????????? ?????? ?????? ???? ??? ??. Microsoft ???? ??? ????-???????? ?? ????-???????? ????? ?????? ?? ???? ???????? ???? ?? ???? ????? ????? ??? ?? ??? ?????? ?? ???? ???? ???? ??? ????? ??. ???????, ????-???????? ???? ????? ???? ???? ???? ???. ?????, ????????, ?????-???? ?? ??????? ?? ???????? ?? ???? ???, ???? ?? ??? ?????? ???? ???? ??? ????? ??? ?? ???? ??. Microsoft ??????? ??? ???? ?? ?????? ?? ??????????, ????????? ?? ??? ?????? ?? ???? ????? ?? ???? ???????? ?? ??? ???? ????? ?? ??? ????????? ???? ??. Microsoft ????-?????? ?????????? ?? ????? ?????? ?? ?? ??? ??.
?????????? ?? ??????? ????????? ??????? ??:899000

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

 

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