question

FVedro avatar image
FVedro asked

Can you SET MAXDOP at database level in SQL2008?

Does anyone know of a way to set the MAXDOP at the database level, I know it can be set at the server level and also within a query using hints, but we would could really use a database level setting if that is possible. Thanks Frank.vedro@optum.com
sql-server-2008performancequery-hint
10 |1200 characters needed characters left characters exceeded

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

JoeBx avatar image
JoeBx answered
No. You can only set MAXDOP at the statement and instance levels.
10 |1200 characters needed characters left characters exceeded

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

Oleg avatar image
Oleg answered
From what I know, it is not possible at the database level. MAXDOP is not included in the list of valid database [SET Options][1]. [1]: http://msdn.microsoft.com/en-us/library/bb522682.aspx
10 |1200 characters needed characters left characters exceeded

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

ThomasRushton avatar image
ThomasRushton answered
No. It's either at the server level, or at the query level. For help with the latter, see
1 comment
10 |1200 characters needed characters left characters exceeded

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

Server **instance**, that is. @JoeBx is right.
0 Likes 0 ·
Blackhawk-17 avatar image
Blackhawk-17 answered
Besides administration and RAM, MAXDOP/CPU/NUMA are reasons for individual instances. If you want to control a particular dB to that extent set up a new instance on the server and possibly create a Linked Server to the original instance if the databases need to query each other.
10 |1200 characters needed characters left characters exceeded

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.