2

In SQL server the default setting for cost threshold for parallelism is 5.

I know that this setting can't be modified in Azure SQL server (as mentioned here).

My question is whether Azure SQL server updates that value depending on the needs of that database

1 Answer 1

1

As far as I know the answer is no.

Try to run:

SELECT * FROM sys.configurations
WHERE name = 'cost threshold for parallelism'

while your Azure SQL Database is under heavy load, I'm quite sure you will not see that value change. (I haven't tried)

Is well knows that cost threshold for parallelism is set to 5 by default even on the latest versions of SQL Server. My assumption is that nowadays this is part of that legacy code that has been ported to Azure.

It stays there in a corner, forgot, and no one notice it.

And god only knows how Azure handles cost threshold for parallelism behind the curtains in the cloud.

But sure you have no vision of it and you cannot tune it.

2
  • Thanks that query worked. Unfortunately, the cost value was set to 5.
    – Moshe
    Dec 22, 2021 at 15:21
  • It will always be set to 5 and you cannot change it Dec 22, 2021 at 15:34

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.