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
Feedback
https://aka.ms/ContentUserFeedback.
Kommer snart: I hele 2024 udfaser vi GitHub-problemer som feedbackmekanisme for indhold og erstatter det med et nyt feedbacksystem. Du kan få flere oplysninger under:Indsend og få vist feedback om