Is it possible to tell if a database has AUTOMATIC_TUNING switched on? In SQL Server 2017 is it possible to tell if automatic tuning is switched on? This relates to tuning of the plan. So the database automatically monitors itself and if the plan gets worse it goes back to an old plan
Automatic query tuning requires that Query Store be enabled first, then you can enable Automatic Tuning.

To check Query Store, select * from sys.database_query_store_options. You're looking for actual_state_desc to be READ_WRITE.

Then check the tuning options with select * from sys.database_automatic_tuning_options where name = 'FORCE_LAST_GOOD_PLAN'. You're looking for actual_state to be set to ON.