When running SQL assessment in several machine which has Cost threshold set 50 and above it suggests to make it 5 ,but CTFP 5 is an old configuration ,any thought why this suggestion ?

I had a look at it, and I agree this should be changed - probably it sholud flag if the default value has been left unchanged. There are some other options where it does exactly this.

I see that SQL Assessment is in preview in Azure Data Studio, but it relies on the SQL Assessment API: https://techcommunity.microsoft.com/t5/sql-server-blog/released-sql-assessment-api-ga/ba-p/989677.

There is a public github repository, so you could open an issue yourself to have this addressed: https://github.com/microsoft/sql-server-samples/tree/master/samples/manage/sql-assessment-api.

Hi @Wondi ,

Welcome to Microsoft Q&A!
Microsoft does not provide recommendations for setting the CTFP.
A common suggestion is setting it to a value between 15 and 50, with the understanding that the best value for it depends on the workload.
Here is a related document for you: https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/configure-the-cost-threshold-for-parallelism-server-configuration-option?view=sql-server-ver15

Best regards,
Seeya

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

So this suggestion should be removed from sql assessment tool as it is misleading

We have changed this rule to warn the user if the value is set to anything other than the default value. We don't recommend a specific value but ask the user to review it, if it has been changed.