| title | sys.database_automatic_tuning_options (Transact-SQL) | ||||
|---|---|---|---|---|---|
| description | Learn how to view automatic tuning options on SQL Server or Azure SQL Database. See required permissions and view additional available resources. | ||||
| author | danimir | ||||
| ms.author | danil | ||||
| ms.reviewer | wiassaf | ||||
| ms.date | 07/06/2021 | ||||
| ms.prod | sql | ||||
| ms.prod_service | database-engine, sql-database | ||||
| ms.technology | system-objects | ||||
| ms.topic | reference | ||||
| f1_keywords |
|
||||
| helpviewer_keywords |
|
||||
| dev_langs |
|
||||
| monikerRange | =azuresqldb-current||>=sql-server-2017||>=sql-server-linux-2017||=azuresqldb-mi-current |
[!INCLUDEsqlserver2017-asdb-asdbmi]
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 |
| desired_state_desc | nvarchar(60) | Textual description of the desired operation mode of Automatic Tuning option. OFF ON |
| 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 [!INCLUDEssNoVersion] Enterprise edition |
Requires the VIEW DATABASE STATE permission.