sys.database_automatic_tuning_mode (Transact-SQL)

Applies to: SQL Server 2017 (14.x) and later Azure SQL Database Azure SQL Managed Instance

Returns the automatic tuning mode for this database. Refer to ALTER DATABASE SET AUTOMATIC_TUNING (Transact-SQL) for available options.

Column name	Data type	Description
desired_state	smallint	Desired state of the automatic tuning mode.
desired_state_desc	nvarchar(60)	Textual description of the desired operation mode of automatic tuning.
actual_state	smallint	Indicates the operation mode of automatic tuning mode.
actual_state_desc	nvarchar(60)	Textual description of the actual operation mode of automatic tuning.

Permissions

Requires the VIEW DATABASE STATE permission.

See also

• Automatic tuning
• ALTER DATABASE SET AUTOMATIC_TUNING (Transact-SQL)
• sys.database_query_store_options (Transact-SQL)
• sys.dm_db_tuning_recommendations (Transact-SQL)
• sys.database_automatic_tuning_options