Today, I have one very simple question based on following image. A full disclaimer is that I have no idea why it is like that. I tried to reach out to few of my friends who know a lot about SQL Server but no one has any answer.
Here is the question:
If you go to server properties and click on Advanced you will see the following screen. Under the Parallelism section if you noticed there are four options:
- Cost Threshold for Parallelism
- Max Degree of Parallelism
- Query Wait
I can clearly understand why Cost Threshold for Parallelism and Max Degree of Parallelism belongs to Parallelism but I am not sure why we have two other options Locks and Query Wait belongs to Parallelism section. I can see that the options are ordered alphabetically but I do not understand the reason for locks and query wait to list under Parallelism.
Here is the question for you – Why Locks and Query Wait options are listed under Parallelism section in SQL Server Advanced Properties?
Please leave a comment with your explanation. I will publish valid answers on this blog with due credit.
Reference: Pinal Dave (http://blog.sqlauthority.com)