Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server 2022 (16.x) and later versions
Azure SQL Database
Azure SQL Managed Instance
SQL database in Microsoft Fabric
Returns the Automatic plan correction component of the Automatic tuning configuration settings that are enabled for the current database.
| Column name | Data type | Description |
|---|---|---|
option |
nvarchar(60) | The name of the automatic tuning configuration option. See sp_configure_automatic_tuning for the list of available configuration options. |
option_value |
nvarchar(60) | Indicates the desired option for the automatic tuning configuration. |
type |
nvarchar(60) | Describes the automatic tuning configuration target type. |
type_value |
nvarchar(60) | Indicates the query ID from Query Store that the automatic tuning configuration option is operating on. |
details |
nvarchar(4000) | Textual description of the automatic tuning configuration option. |
state |
bit | Indicates the state of the automatic tuning configuration option. |
Permissions
Requires the VIEW DATABASE STATE permission.