Timeline for Why is a max degree of parallelism 1 recommended and used for Sharepoint in SQL Server?
Current License: CC BY-SA 3.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Apr 21, 2016 at 5:51 | answer | added | Cody Konior | timeline score: 1 | |
| Mar 24, 2016 at 6:24 | history | edited | Paul White♦ |
edited tags
|
|
| Oct 6, 2015 at 20:10 | comment | added | RayofCommand | 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 :) | |
| Oct 6, 2015 at 16:35 | comment | added | Hannah Vernon♦ |
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.
|
|
| Oct 6, 2015 at 16:21 | history | tweeted | twitter.com/StackDBAs/status/651432061685862401 | ||
| Oct 6, 2015 at 15:12 | comment | added | Shanky | Does This Blogs.msdn provide any help ? | |
| Oct 6, 2015 at 14:49 | history | asked | RayofCommand | CC BY-SA 3.0 |