sys.database_automatic_tuning_configurations (Transact-SQL)

Applies to: SQL Server 2022 (16.x) Azure SQL Database Azure SQL Managed Instance SQL database in Microsoft Fabric

Returns the Automatic plan correction component of the Automatic tuning configuration settings that are enabled for the current database.

Column name	Data type	Description
option	nvarchar(60)	The name of the automatic tuning configuration option. See sp_configure_automatic_tuning for the list of available configuration options.
option_value	nvarchar(60)	Indicates the desired option for the automatic tuning configuration.
type	nvarchar(60)	Describes the automatic tuning configuration target type.
type_value	nvarchar(60)	Indicates the query ID from Query Store that the automatic tuning configuration option is operating on.
details	nvarchar(4000)	Textual description of the automatic tuning configuration option.
state	bit	Indicates the state of the automatic tuning configuration option.

Permissions

Requires the VIEW DATABASE STATE permission.

Related content

• Automatic tuning
• ALTER DATABASE SET options (Transact-SQL)
• sys.database_query_store_options (Transact-SQL)
• sys.dm_db_tuning_recommendations (Transact-SQL)
• sys.database_automatic_tuning_mode
• sp_configure_automatic_tuning (Transact-SQL)