2

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?

1 Answer 1

6

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:

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.