sys.database_automatic_tuning_mode (Transact-SQL)

Applies to: SQL Server 2017 (14.x) and later versions Azure SQL Database Azure SQL Managed Instance SQL database in Microsoft Fabric

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