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
Tagasiside
https://aka.ms/ContentUserFeedback.
Varsti tulekul: 2024. aasta jooksul tühistame GitHubi probleemide funktsiooni sisutagasiside mehhanismina ja asendame selle uue tagasisidesüsteemiga. Lisateabe saamiseks vtEsita ja vaata tagasisidet