5

I am new to Sharepoint, but I used to work with SQL Server a lot. I realized that Sharepoint changes some of the SQL Server settings to non default values. One is the max degree of parallelism, why doesn't sharepoint like parallel plan executions? Also why should I turn off "auto update statistics? I couldn't find answers to these two questions. I am on Sharepoint 2013

  • 1
    Does This Blogs.msdn provide any help ? – Shanky Oct 6 '15 at 15:12
  • 1
    auto update statistics should be turned off since the product automatically updates statistics when/as needed. maxdop should be set to 1 to allow a larger number of simultaneous requests to be processed. If the server hosting the SharePoint databases has a large number of processors, you might see better individual query performance with a maxdop = 2, but naturally that will decrease the concurrency of the system. – Max Vernon Oct 6 '15 at 16:35
  • Thank you max, thats what I thought as well. I saw that sharepoint will update stats as needed as well, just wondering what might be different when sql server updates it directly. Shanky thanks i will read that later :) – RayofCommand Oct 6 '15 at 20:10
1

A busy SharePoint site is expected to have a lot of users which generate a huge volume of simple database requests.

If you had 8 cores and 200 users, you'd fill the queues parallelising just a few user's worth of workloads. By forcing each workload onto one core, you are ensuring a better "minimum standard" experience for everyone while reducing the time wasted due to context switching where it wasn't strictly necessary (as those queries were simple and would finish quickly enough on one core anyway).

That's my understanding of it.

Regarding the indexing, that's done by Sharepoint when it installs/upgrades and you don't need to touch it. As Shanky and Max posted, Sharepoint (and some other high-end Microsoft products like SCOM) manages maintenance on itself.

I still do weekly maintenance on top of that to keep it standard across my servers. It doesn't break anything.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.