question

Subhan avatar image
Subhan asked

Can any one can tell me what is use of MAXDOP ?

Plz tel me....!

sql server
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

WRBI avatar image WRBI commented ·

Don't play with MAXDOP unless you really have to. The query engine is a refined beast that does a good job of choosing the correct settings most of the time.

0 Likes 0 ·
Kev Riley avatar image
Kev Riley answered

Start with the official documentation, and if there is anything you need to ask after that, come back here :)

https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-the-max-degree-of-parallelism-server-configuration-option?view=sql-server-2017

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Ange avatar image
Ange answered

Kendra Little gives a good explanination here:

https://littlekendra.com/2016/07/14/max-degree-of-parallelism-cost-threshold-for-parallelism/

The "Cost" she is talking about is the overall "Estimated Subtree Cost" in your execution plan.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.