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
No. You can only set MAXDOP at the statement and instance levels.
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
No. It's either at the server level, or at the query level. For help with the latter, see
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.
