New in Sql server 2017

~ S

New things are getting from sql server 2017.

Now , I founded : Automatic tuning.See here more : automatic-tuning. 

The engine will automatically resolve problems that it identifies

This is based on query store.

sys.dm_db_tuning_recommendations

 

To enable automatically tuning :

ALTER DATABASE current SET AUTOMATIC_TUNING ( FORCE_LAST_GOOD_PLAN = ON )

 

S

Unknown's avatar

Published by S

fan of t-sql some years experience with sql server

Leave a comment