Anteckning
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
Applies to: 
SQL Server 2017 (14.x) and later versions
Azure SQL Database
Azure SQL Managed Instance
SQL database in Microsoft Fabric
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.