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