Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Sharepoint SQL Server Expand / Collapse
Author
Message
Posted Saturday, March 9, 2013 1:24 PM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, August 22, 2014 10:17 AM
Points: 27, Visits: 467
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
Post #1428927
Posted Saturday, March 9, 2013 2:45 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, August 21, 2014 3:52 PM
Points: 5,988, Visits: 12,923
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.


---------------------------------------------------------------------

Post #1428939
Posted Saturday, March 9, 2013 3:29 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 3:07 PM
Points: 42,812, Visits: 35,931
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 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1428940
Posted Monday, March 11, 2013 2:24 PM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, August 22, 2014 10:17 AM
Points: 27, Visits: 467
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
Post #1429474
Posted Monday, March 11, 2013 4:10 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 3:07 PM
Points: 42,812, Visits: 35,931
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 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1429522
Posted Monday, March 11, 2013 4:13 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 3:06 PM
Points: 23,276, Visits: 31,996
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.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1429523
Posted Monday, March 11, 2013 4:34 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 3:07 PM
Points: 42,812, Visits: 35,931
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 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1429529
Posted Monday, March 11, 2013 9:53 PM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Monday, August 18, 2014 9:16 PM
Points: 4,576, Visits: 8,347
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?
Post #1429570
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse