Azure SQL Database - Modify cost threshold for parallelism

Question

I attempted to update the value of cost threshold for parallelism but since my database is an Azure SQL database I can't run the command:

EXEC sp_configure 'cost threshold for parallelism', 40 ;
GO
RECONFIGURE

due to an error of "Could not find stored procedure 'sp_configure'."

Is it possible to update this setting in Azure SQL database?

Answer 1

You cannot change the cost threshold for parallelism for the Azure SQL Database PaaS service.

You can only change the MAXDOP at the query and database levels. Details here.

Ref:

• Azure SQL Database and Cost Threshold for Parallelism by Blobeater
• Change the setting "Cost Threshold For Parallelism"