??????? ???? ???????? ?????? ?????? MAXDOP

???? ???????: 329204 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???????? ????? ????? ??????? ?????? ?????? ???????
????? ???? | ?? ????

?? ??? ??????

??????

?????? ??? ??????? ??? ??????? ???? ????????? ?????? ?????? ???? ???? parallelism (MAXDOP) ?? Microsoft SQL Server ??? ??????? ????? ?????? ?????? sp_configure.

???????? ??? ???? ???? ????? ??????? ????????? SQL ???????? OPTION (MAXDOP) ???? ??????? ???? ???? parallelism ?? ???? sp_configure ????????? ???? ???? ??? ?????? ???. ?? SQL Server 2000 ??????? ???? ??????? ??? ??? ???? ?????? ??????? ?? ??????? ??? ?? ?? ????? ?????? sp_configure. ?? SQL Server 2005 ?? ?? SQL Server 2008 ??????? ????? ???? ???????. ??? ????? MAXDOP ?????? ???? ?? ??????? ???????? Governor ??????? "????? ?????" ?????? ???? Governor ??????? MAXDOP ?? SQL Server 2008. ???? ????? ?????? ????????? ?? ???? ??????? ???? ???? parallelism ????? ??????? ??? ??????? ????? ????????? MAXDOP.

???? parallelism ????? ????? ???? ???? ??? ??? "???????".
???? ??? ?????? | ????? ???????

??????? ????

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

?????? ????????? ??????? ??? ????? ???? MAXDOP:
  • ?????? ??? ???????? ???? ?????? ???? ?? ?????? ??????? ??????? ??????? ??????: MAXDOP = 8.
  • ???????? ???? ????? ??? ?????? ?? ??? ????????? ??????? ??????? ?????? ??? N ????? ??? ?????????: MAXDOP = 0 ??? N.
  • ???????? ???? ??? NUMA ????? ??? MAXDOP ??? ?????? ??? ????? ???????? ???????? (CPUs) ???? ?? ??????? ??? ?? ???? NUMA.
  • ???????? ???? ??? ??????? ????? ??? ??? ???? MAXDOP ??? ?????? ??? ????????? ???????.
??? ????????? ?????? ???. ?? ???? ???? ??? ??????????? ??? ??? ?????????. ??? ???? ??????? ?? ?????? ??????? ??????? ???????:
  • ??? ??? ?????? ??? ???? ??????? ??? ?????? ?????? (OLTP) - ???????? ??? ??????.
  • ??? ??? ?????? ????? ????? ??????? ?????? ??? ???? ?? ?? ????? ???????? ???? ??????.
  • ??? ??? ?????? ????? ?????? ??????? ???? ????.
?????? ?????? ??????? ??? ????? ????????? ??? ???? ?????.

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

SQL Server 2005

????? ?? ????????? ??? SQL Server 2005 ?????? ????? ???? ???? ????? Microsoft (MSDN) ?????? ??? ?????:
http://msdn.microsoft.com/en-us/library/ms188611.aspx
(http://msdn.microsoft.com/en-us/library/ms188611.aspx)

SQL Server 2000

?? ???? ?????? ??????? ??? ?????? SQL Server ? ??? ??????? ????? ???? (1). ??? ???? ?? ???? ?????? ??????? parallelism SQL Server, ???? ???? ??????? ???? ????????? ???????? (??? ?? ?????? ?????? ????? ????? ????????? MAXDOP) ??????? ??? ??????. ??? ???? ??????? ??? ??? ?????? MAXDOP = 0 ??? ???? 32 ????? SQL Server ????? ??????? ???? ????????? 32 ??? ?? ??? ?? ????????? ???? ????? ??? ?????? ???? ???? ????? ?????? ??? ??? ?????? ?????? ????? ???? ???. ????? ??? ?????? all-or-nothing ??? ????? SQL Server ??? ?????? ?? ????? ????? ????????? MAXDOP ??? ???? ?????? ?? 8, outweighs ????? ???? ??????? ??? ???? SQL ?????? ???? ????????? ??? ???? ????? ????? ??????? ??? ??????.

??? ????? ??????? MAXDOP ?? ???? ?? ?????. ??????? ?? ???? CPU ????? ?? ??? ????? ???????? ???????? (CPU) ???? ?? ?????? ?????? MAXDOP ????? ?? ??? ?? ???. ?? ???? ????? ??????? ?? ??? ????? ? ?? ?????? ??? ?????? ??????? ???? ???????? ????????? ??????? MAXDOP.
???? ??? ?????? | ????? ???????

?????

  • ?????? MAXDOP ???? ??????? "???? ????? ?? Parallelism ????" "??" ??????? "????? Parallelism" ?? "??? SQL Server ???????".
  • ???? ????? ??? parallelism ???? ?????? "?????? ????????? Parallel" ???? ??????? "????? ????? ?????????" ?? "??? SQL Server ???????".
???? ??? ?????? | ????? ???????

???????

???? ???????: 329204 - ????? ??? ??????: 03/????? ??????/1430 - ??????: 9.0
????? ???
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Express Edition
  • Microsoft SQL Server 2005 Workgroup Edition
  • Microsoft SQL Server 2000 Service Pack 3a
  • Microsoft SQL Server 2000 Service Pack 3
  • Microsoft SQL Server 2000 Service Pack 2
  • Microsoft SQL Server 2000 Service Pack 1
  • Microsoft SQL Server 7.0 Service Pack 4
  • Microsoft SQL Server 7.0 Service Pack 3
  • Microsoft SQL Server 7.0 Service Pack 2
  • Microsoft SQL Server 7.0 Service Pack 1
  • Microsoft SQL Server 7.0 Standard Edition
????? ??????: 
kbmt kbinfo KB329204 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????329204
(http://support.microsoft.com/kb/329204/en-us/ )
???? ??? ?????? | ????? ???????

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

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