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.