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
Phản hồi
https://aka.ms/ContentUserFeedback.
Sắp ra mắt: Trong năm 2024, chúng tôi sẽ dần gỡ bỏ Sự cố với GitHub dưới dạng cơ chế phản hồi cho nội dung và thay thế bằng hệ thống phản hồi mới. Để biết thêm thông tin, hãy xem:Gửi và xem ý kiến phản hồi dành cho