Arun Sirpal shows off one of the more interesting features in SQL Server 2017:
Before we begin any further let’s do a little recap. Automatic tuning in SQL Server 2017 notifies you whenever a potential performance issue is detected, and lets you apply corrective actions, or lets the Database Engine automatically fix performance problems, this is also available in Azure SQL Database.
There are 2 parts to it, automatic plan correction and automatic index management, for SQL Server 2017, automatic index management it IS NOT part of the product.
To switch automatic plan correction on you will need to run the following code against your database.
I’m looking forward to seeing this expand much further.