Events
Mar 31, 11 PM - Apr 2, 11 PM
The ultimate Microsoft Fabric, Power BI, SQL, and AI community-led event. March 31 to April 2, 2025.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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 |
Requires the VIEW DATABASE STATE
permission.
Events
Mar 31, 11 PM - Apr 2, 11 PM
The ultimate Microsoft Fabric, Power BI, SQL, and AI community-led event. March 31 to April 2, 2025.
Register today