sys.database_automatic_tuning_options (Transact-SQL)
Applies to: SQL Server 2017 (14.x) and later Azure SQL Database Azure SQL Managed Instance
Returns the automatic tuning options for this database.
Column name | Data type | Description |
---|---|---|
name | nvarchar(128) | The name of the automatic tuning option. Refer to ALTER DATABASE SET AUTOMATIC_TUNING (Transact-SQL) for available options. |
desired_state | smallint | Indicates the desired operation mode for automatic tuning option, explicitly set by user. 0 = OFF 1 = ON 2 = DEFAULT |
desired_state_desc | nvarchar(60) | Textual description of the desired operation mode of automatic tuning option. OFF ON DEFAULT |
actual_state | smallint | Indicates the operation mode of automatic tuning option. 0 = OFF 1 = ON |
actual_state_desc | nvarchar(60) | Textual description of the actual operation mode of automatic tuning option. OFF ON |
reason | smallint | Indicates why actual and desired states are different. 2 = DISABLED 11 = QUERY_STORE_OFF 12 = QUERY_STORE_READ_ONLY 13 = NOT_SUPPORTED |
reason_desc | nvarchar(60) | Textual description of the reason why actual and desired states are different. DISABLED = Option is disabled by system QUERY_STORE_OFF = Query Store is turned off QUERY_STORE_READ_ONLY = Query Store is in read-only mode NOT_SUPPORTED = Available only in SQL Server Enterprise edition |
Permissions
Requires the VIEW DATABASE STATE
permission.
See also
Feedback
https://aka.ms/ContentUserFeedback.
În curând: Pe parcursul anului 2024, vom elimina treptat Probleme legate de GitHub ca mecanism de feedback pentru conținut și îl vom înlocui cu un nou sistem de feedback. Pentru mai multe informații, consultați:Trimiteți și vizualizați feedback pentru