sys.database_automatic_tuning_mode (Transact-SQL)
Applies to: SQL Server 2017 (14.x) and later Azure SQL Database Azure SQL Managed Instance
Returns the automatic tuning mode for this database. Refer to ALTER DATABASE SET AUTOMATIC_TUNING (Transact-SQL) for available options.
Column name | Data type | Description |
---|---|---|
desired_state | smallint | Desired state of the automatic tuning mode. |
desired_state_desc | nvarchar(60) | Textual description of the desired operation mode of automatic tuning. |
actual_state | smallint | Indicates the operation mode of automatic tuning mode. |
actual_state_desc | nvarchar(60) | Textual description of the actual operation mode of automatic tuning. |
Permissions
Requires the VIEW DATABASE STATE
permission.
See also
Tilbakemeldinger
https://aka.ms/ContentUserFeedback.
Kommer snart: Gjennom 2024 faser vi ut GitHub Issues som tilbakemeldingsmekanisme for innhold, og erstatter det med et nytt system for tilbakemeldinger. Hvis du vil ha mer informasjon, kan du se:Send inn og vis tilbakemelding for