Redigera

Dela via


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