<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2008
»
SQL Server 2008 - General
»
Sharepoint SQL Server
Sharepoint SQL Server
Rate Topic
Display Mode
Topic Options
Author
Message
jswong05
jswong05
Posted Saturday, March 09, 2013 1:24 PM
SSC Rookie
Group: General Forum Members
Last Login: Monday, March 18, 2013 7:54 AM
Points: 27,
Visits: 421
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
george sibbald
george sibbald
Posted Saturday, March 09, 2013 2:45 PM
SSCertifiable
Group: General Forum Members
Last Login: Yesterday @ 12:30 PM
Points: 5,269,
Visits: 11,205
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
GilaMonster
GilaMonster
Posted Saturday, March 09, 2013 3:29 PM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 5:54 AM
Points: 37,726,
Visits: 29,985
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
jswong05
jswong05
Posted Monday, March 11, 2013 2:24 PM
SSC Rookie
Group: General Forum Members
Last Login: Monday, March 18, 2013 7:54 AM
Points: 27,
Visits: 421
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
GilaMonster
GilaMonster
Posted Monday, March 11, 2013 4:10 PM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 5:54 AM
Points: 37,726,
Visits: 29,985
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
Lynn Pettis
Lynn Pettis
Posted Monday, March 11, 2013 4:13 PM
SSC-Insane
Group: General Forum Members
Last Login: Yesterday @ 11:17 PM
Points: 21,617,
Visits: 27,450
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
GilaMonster
GilaMonster
Posted Monday, March 11, 2013 4:34 PM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 5:54 AM
Points: 37,726,
Visits: 29,985
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
Sergiy
Sergiy
Posted Monday, March 11, 2013 9:53 PM
SSCarpal Tunnel
Group: General Forum Members
Last Login: Today @ 5:47 AM
Points: 4,550,
Visits: 8,201
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 »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
