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

??????????

????SQL Server ?к????????????????????в??????дSQL Server??????????????????????????????CPU??????????????????——???顣

?????????1?У????SP_Configure?洢??????????ж????0?????????????????????SQL Server????????????м?????????????????????CPU????????????4??SQLServer?????4??????????????????????1???????????ж??

?????????2?У????OPTION?????????????ò??в??????????????SELECT???????С??????????????MAXDOP =1????ζ?????ò??ж???в???????????????????MAXDOP =0????ζ????SQLServer????????????ò??ж????С?

?????????SET STATISTICS TIME????????????????????????????CPU???

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

???????????????и?????????ж??????Σ???????????????????????????????????????????????????????????????SQL Server?????????????????????????CPU???????????OLTP???У????????????????????????OLAP???У??????????????

???????????????16???????????MaxDegree of Parallelism???8??????????????8???????????SQL Server??????????????????????ó???8?????????????????????У??????????SQL Server???????????п????????