Solved

max degree of parallelism & locks

Posted on 2014-10-23
1
168 Views
Last Modified: 2014-10-24
will the instance setting max degree of parallelism help reduce locks?
http://msdn.microsoft.com/en-us/library/ms189094(v=sql.100).aspx

is 0 the best option? (max parallel operation possible? (instead of setting something like 6 or 8)
0
Comment
Question by:25112
1 Comment
 
LVL 33

Accepted Solution

by:
ste5an earned 500 total points
ID: 40400421
Maybe. But it's kinda snakeoil without further analysis of the cause.
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Solution for warm standby SQL server 20 50
TSQL DateADD update Question 4 40
Separate 2 comma delimited columns into separate rows 2 32
sql 2008 how to table join 2 16
There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question