Automatic tuning will be a new default

Automatic tuning, technology that continuously monitors and automatically improves database performance in SQL Database, will be enabled by default in the upcoming period. Roll out of this change will be gradual and will start from January 15th, 2018. Two weeks before this change happens on any subscription, a notification email will be sent to subscription owners. All servers that do not have automatic tuning explicitly configured will inherit Azure defaults, making automatic tuning enabled. Similarly, all databases that do not have automatic tuning explicitly configured will inherit the configuration from the parent server. All newly created databases by default will inherit the configuration from the parent server.

Automatic tuning has reached the point where it is ready to be enabled by default for SQL Database. Since automatic tuning reached global availability in early 2016, the SQL Database team continued investing in improving its capabilities. Learning from a massive pool of customers who already adopted automatic tuning, we have made advancements in recommendation models, increased the speed and safety of applying tuning actions, and removed obstacles that prevented some of the customers from adopting automatic tuning.

Click here to read about great benefits that SQL Database customers achieved using automatic tuning.

What will happen?

All resources that do not have automatic tuning configured after January 15th, 2018, will be included in transition schedule from unconfigured to having servers configured to inherit from Azure defaults, and databases configured to inherit from parent server. Prior to transition, if automatic transition is configured on any resource, such resource will not be included in the automatic transition.

Click here to read more about how to configure automatic tuning.

Automatic tuning options

Automatic tuning is fully configurable – it can be configured on the server and database level. Servers can be configured to inherit the automatic tuning configuration from Azure defaults, or not to inherit the default configuration. Databases, beside these two options, can be also configured to inherit settings from the parent server. In addition to configuring resource level configuration, on both server and database each automatic tuning option can be explicitly enabled or disabled separately.

Click here to read more about automatic tuning in Azure SQL Database.

Specifying automatic tuning configuration

In case you would like to start using automatic tuning earlier, create a custom automatic tuning configuration, or disable automatic tuning on your resources, please configure the automatic tuning on your resources before January 15th, 2018.

Click here to read more about how to configure automatic tuning.

Source: Azure Blog Feed

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.