New Azure SQL Database automatic tuning default settings—March 2020
Published date: 10 February, 2020
In March 2020, Azure SQL Database will introduce new automatic tuning default settings designed to provide optimal database performance.
Existing servers that are not configured with automatic tuning will have the new default settings automatically applied and enabled. Servers that are already configured for automatic tuning will not be affected.
When new Azure SQL Database servers are created, the default settings for automatic tuning will be FORCE LAST GOOD PLAN = enabled, CREATE INDEX = disabled and DROP INDEX = disabled.