New Azure SQL Database automatic tuning default settings—March 2020

Azure Updates

Discussionpowered by zap.ms

Published

Feb 10, 2020

Status

In development

Timeline

  • February 2020
    Private Preview

Product

Azure SQL Database

Tag

Features
Services

Category

Databases
Hybrid + multicloud

Description

In March 2020, Azure SQL Database will introduce new automatic tuning default settings designed to provide optimal database performance.

Existing servers that aren’t configured with automatic tuning will have the new default settings automatically applied and enabled. Servers that are already configured for automatic tuning won’t 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.

Learn how to enable automatic tuning on a server or database.