最大并行度 - MAXDOP [英] Max Degree of Parallelism - MAXDOP

问题描述

我最近对客户进行了SharePoint场分析，他们的生产SQL框有2个物理处理器，每个处理器有16个核心。 此SQL Server仅承载所有SharePoint数据库。 我注意到MAXDOP设置
设置为8，我希望看到1. 我的问题是：

I recently did an analysis of a SharePoint farm for a customer and their production SQL box has 2 physical processors each processor with 16cores.  This SQL server only hosts all of the SharePoint databases.  What I noticed is that the MAXDOP setting is set to 8 where I expected to see 1.  My question is:

1。不会出现错误，甚至将此设置更改为1？

1. Wouldn't SharePoint throw an error or even change this setting to 1?

2。这个设置是否是SharePoint必需和必需的，即使下面的模糊表明大多数应用程序都会从​​并行性中受益？ 

2. Is this setting necessary and required for SharePoint even though the blurb below indicates that most application would benefit from parallelism? 

如果有人有链接解释为什么最好让SharePoint关闭并行执行，请分享。

If anyone has a link explaining why it is best for SharePoint to have parallel execution turned off, please share.

"最大并行度（MAXDOP）是SQL Server实例级别设置，用于定义在并行计划中用于执行查询的处理器数量。它定义了用于查询计划运算符的计算和线程资源，
并行执行工作。尽管使用SQL Server作为数据库后端的许多解决方案都可以从并行性中获益，但SharePoint是关闭并行执行时最有效的解决方案之一（MAXDOP = 1）。对于SharePoint 2007
和2010，它是推荐的设置;但是，对于SharePoint 2013，这是一项艰难的要求。"

"Maximum Degree of Parallelism (MAXDOP) is a SQL server instance level setting that defines the number of processors used for the execution of a query in a parallel plan. It defines the computing and thread resources used for query plan operators that perform the work in parallel. Although many of the solutions using SQL server as a database backend may profit from the parallelism, SharePoint is one of the solutions that works best when the parallel execution is turned off (MAXDOP=1). For SharePoint 2007 and 2010, it is the recommended setting; however, for SharePoint 2013, it is a hard requirement."

谢谢，

Rumi

推荐答案

嗨Rumi，

这意味着有人进入你身后并改变了MAXDOP。  ; SharePoint 2013和更新版本需要MAXDOP为1才能安装。

This means someone went in behind you and changed the MAXDOP.  SharePoint 2013 and newer versions require MAXDOP at 1 in order to install.

我已经看到过去发生过这种情况的人，当他们将其更改回1时，它会导致所有搜索和分布式缓存的各种问题....好吧，分布式缓存和搜索的问题出现了，最终重建了农场到
修复。

I've seen where this has happened to people in the past and when they changed it back to 1, it caused all sorts of issues with search and distributed cache....well, issues with distributed cache and search came about, and ended up rebuilding the farm to fix.

这篇关于最大并行度 - MAXDOP的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！