• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 274
  • Last Modified:

max degree of parallelism & locks

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
25112
Asked:
25112
1 Solution
 
ste5anSenior DeveloperCommented:
Maybe. But it's kinda snakeoil without further analysis of the cause.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now