Modifying Max Degree Of Parallelism To 1 For Azure Sql Server

I'm able to query 'max degree of parallelism(maxdop)' value from sys.configurations but unable update the same for an azure-sql server. I'm not very sure if there is an alternativ

Solution 1:

You will not be able to change Max DOP in SQL DB and it is equivalent to 0 (for SQL DB v12) which is a different behavior in SQL DB V11 (which is 1) always. If you see your query plans impacting the performance and need to reset it to 1, please open a support ticket to MSFT and this will be fixed.

Solution 2:

Hmm.. I'm pretty sure that SQL Azure actively ignores any MAXDOP query hint passed to it anyway, which may render your question a moot point perhaps?

AFAIK it's just set to 1 by default, and you get an error if you try to change it up, as you are finding.