March 9, 2013 at 1:24 pm
http://technet.microsoft.com/en-us/library/cc298801.aspx
•To ensure optimal performance, we strongly recommend that you set max degree of parallelism (MAXDOP) to 1 SQL Server instances that host SharePoint Server 2010 databases
?
can someone explain why sharepoint team put this document with the above line? Sharepoint surpresses all parallelism?
Jason
http://dbace.us
😛
March 9, 2013 at 2:45 pm
with microsoft products that use SQL server as a backend they often don't follow their own best practices 🙂
the code as written must work better if parallelism is suppressed, seems a shame and I don't know why, one can only hope they have thoroughly tested and proved it.
---------------------------------------------------------------------
March 9, 2013 at 3:29 pm
The sharepoint database design is pretty bad (very bad), and about the only way to make the queries work acceptably is to force maxdop 1.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 11, 2013 at 2:24 pm
Microsoft SharePoint team needs to communicate with SQL Server team, vice versus. Parallelism is a good feature to use, not to surppess.
Jason
http://dbace.us
😛
March 11, 2013 at 4:10 pm
Communication? What a novel idea!
The sharepoint DB needs a complete redesign first, and to be honest, that's not going to happen.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 11, 2013 at 4:13 pm
GilaMonster (3/11/2013)
Communication? What a novel idea!The sharepoint DB needs a complete redesign first, and to be honest, that's not going to happen.
Same could be said ot their CRM product as well.
March 11, 2013 at 4:34 pm
Lynn Pettis (3/11/2013)
GilaMonster (3/11/2013)
Communication? What a novel idea!The sharepoint DB needs a complete redesign first, and to be honest, that's not going to happen.
Same could be said ot their CRM product as well.
Wasn't that bought rather than developed inhouse?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 11, 2013 at 9:53 pm
Configuration storage and IOPS
....
Transaction logs for the Configuration database can be large, therefore we recommend that you change the recovery model for the database from full to simple.
School project?
_____________
Code for TallyGenerator
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply