Azure-docs: Terrible mistake on default service settings

[AndresUrregoAngel]

According to the documentation every time you create a new SQL server on Azure there are few services coming as default ON.

"Enable automatic tuning on server
On the server level you can choose to inherit automatic tuning configuration from "Azure Defaults" or not to inherit the configuration. Azure defaults are FORCE_LAST_GOOD_PLAN is enabled, CREATE_INDEX is enabled, and DROP_INDEX is disabled."

I have just create a new server and the settings by default are different as the documentation points it out:

FORCE_LAST_GOOD_PLAN is enabled
CREATE_INDEX is disabled
DROP_INDEX is disabled

This is terrible due to the exam DP-200 is based on the documentation but my hands-on experience tell me otherwise, so what the heck here Microsoft?

---

Document Details

⚠ Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.

• ID: 5ef45327-7cdf-fc60-2a04-b785bc12f4cf
• Version Independent ID: b4f8c915-9651-14df-92d7-fa1387780a41
• Content: Enable automatic tuning - Azure SQL Database
• Content Source: articles/sql-database/sql-database-automatic-tuning-enable.md
• Service: sql-database
• Sub-service: performance
• GitHub Login: @danimir
• Microsoft Alias: danil

[MarileeTurscak-MSFT]

@AndresUrregoAngel please provide a link to the document which you are following so that we can help fix this.

[AndresUrregoAngel]

Over this link the documentation is wrong : https://docs.microsoft.com/en-us/azure/sql-database/sql-database-automatic-tuning-enable

Now , here you point out that from March 2020 there is a new behavior over the CREATE_INDEX: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-automatic-tuning

Now the million question which one should I pick if this come into my DP-200 exam? thanks @MarileeTurscak-MSFT

[Mike-Ubezzi-MSFT]

@AndresUrregoAngel Thank you for bringing this to our attention. It appears the screen capture provided in the document needs to be updated. Here are the default values for both server level and database level.

Server Level:

Database Level: (Inherited from Server)

Let me have the content team review this and make an appropriate update.

[danimir]

@AndresUrregoAngel This is expected. On the main Automatic Tuning page, there is a HUGE announcement (in a big blue box towards the bottom of the page) that these settings will be changed in March. There was also an official Azure update, so this is expected. The settings are being rolled out gradually to millions of databases. Once all settings land in, all pages will be updated. I do realize that on this specific sub-page the announcement is missing, so I will make the announcement on this page as well until things are rolled out. Thank you on your understanding.

[AndresUrregoAngel]

Guys I totally get it we can fix it quickly , now my question more towards what should I do in the DP-200 exam in the case the configuration at server level will still consider the previous configuration, should I rely in how that was before or move forward with the new default settings?

[danimir]

The roll-out is not yet complete. For the exam you can respond with the old defaults. This really is not a question for the product group, but for the people who are administering the exam.

[Mike-Ubezzi-MSFT]

We will now proceed to close this thread. If there are further questions regarding this matter, please comment and we will gladly continue the discussion.